Solutions to TSQL Challenge – Reoccurring VisitsCommented on: 3 years ago
(July 19, 2011)
Solution#1, used idx_visitor_dt.
;with Calendar as
select @from dt
select DATEADD(DAY, 1, dt)
where dt < @to
, isnull(todayNum, 0) numvisitors
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.
An in-depth look at some of the concerns involved with enabling/disabling entire SQL Server jobs based upon whether they should be run, or not—and then look at options for addressing those concerns....More