Viewing 2 posts - 1 through 2 (of 2 total)
You could use a system table to generate numbers. Depending on the number of objects and expected date range use one or more crossjoins
DECLARE @startdate Date='20180301'
DECLARE @enddate Date='20180430'
;WITH CTE
...
August 23, 2018 at 8:13 am
#2003059
[...if you're defraging the indexes then the next step of this job should be updating the statistics...]
The reorganization takes about 10 hours. All requests for an update of the statistic...
August 12, 2010 at 7:41 am
#1206012