Viewing 4 posts - 1 through 4 (of 4 total)
Be careful when you use DW in a datepart function as the number that represents a particular day will change based on the value of @@DATEFIRST...
February 18, 2011 at 8:03 pm
ON A.caseid = D.caseid
where A.closedate = ' '
group by D.caseid
having sum(case when D.closedate = ' ' then 1 else 0 end) = 0
February 18, 2011 at 7:53 pm
The issue scales with volume anyway and the particular query is largely irrelevant. A query that runs <1 sec on the test box takes 23 seconds on Prod...
February 18, 2011 at 7:39 pm
Is 150MB too low? Well it kind of depends. Are you seeing paging on the servers? How if the page life expectancy in SQL, etc.
February 18, 2011 at 7:09 pm
Viewing 4 posts - 1 through 4 (of 4 total)