Viewing 15 posts - 2,386 through 2,400 (of 26,488 total)
Do a wait stats analysis. There are 52 parallel operations in the slow plan and only 45 parallel operations in the fast plan. To break it out a bit more:
November 21, 2017 at 9:08 am
November 21, 2017 at 8:58 am
November 21, 2017 at 8:37 am
November 20, 2017 at 3:33 pm
Just took a look at some of the joins, and yes, they could be problematic as well. Conditional joins can be painful.
Jeff puts it well, many problems can...
November 20, 2017 at 2:15 pm
Just looking at the query itself shows that it could deal with a rewrite. The use of the YEAR function in the WHERE clause is going to cause scans on...
November 20, 2017 at 2:11 pm
See if this helps, it is based on us-English settings.
DECLARE @TestDate DATETIME;
SET @TestDate = '2017-11-19';
SELECT DATEADD(WEEK,DATEDIFF(WEEK,0,@TestDate) - 2, 0), DATEADD(DAY,6,DATEADD(WEEK,DATEDIFF(WEEK,0,@TestDate) - 2, 0));
SELECT DATEADD(WEEK,DATEDIFF(WEEK,0,@TestDate) -...
November 20, 2017 at 1:47 pm
November 20, 2017 at 12:42 pm
November 20, 2017 at 12:41 pm
Viewing 15 posts - 2,386 through 2,400 (of 26,488 total)