...
In large databases such a process can take an hour or more, so please be patient about it.
As an alternative, you can delete the oldest data on a percentage base. Substitute <workspace-name> and <percentage> as in your workspace and enter the delete query followed by the go command:
| Code Block |
|---|
1> DELETE FROM NETX_<workspace-name>.dbo.NETX_HISTORICAL_VALUE WHERE LOCAL_DATE IN(SELECT TOP(<percentage>) PERCENT LOCAL_DATE FROM NETX_<workspace-name>.dbo.NETX_HISTORICAL_VALUE ORDER BY LOCAL_DATE ASC)
2> go |