Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Count the Number of Weekend Days between Two Dates

    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

    ...

  • RE: Update Statistic blocked by reorganization

    [...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...

Viewing 2 posts - 1 through 2 (of 2 total)