Viewing 15 posts - 781 through 795 (of 10,144 total)
May 8, 2017 at 2:29 am
May 8, 2017 at 2:04 am
-- "choose priority values" and "eliminate date range dupes" could be done within the same subquery.
SELECT
ServiceID,
StartDate = MIN(StartDate),
EndDate = MAX(EndDate),
May 5, 2017 at 3:21 am
May 5, 2017 at 1:37 am
"In the end the breakdown of those 3.5 seconds is 4 queries taking an average of 0.5 - 0.6 seconds each"
Can you post the execution plans of these...
May 3, 2017 at 7:26 am
May 3, 2017 at 7:22 am
dbunch 89261 - Tuesday, May 2, 2017 7:51 AMUseful post - thanks!
You'd probably find an inline function significantly more performant than this...
May 2, 2017 at 9:21 am
April 27, 2017 at 9:35 am
April 27, 2017 at 9:20 am
April 26, 2017 at 7:14 am
April 26, 2017 at 5:06 am
1) Have you checked that there are matching...
April 25, 2017 at 6:25 am
April 24, 2017 at 4:51 am
have the below code from 3rd party app trying to get rid of...
April 24, 2017 at 2:52 am
Viewing 15 posts - 781 through 795 (of 10,144 total)