Viewing 6 posts - 1 through 7 (of 7 total)
GilaMonster (7/21/2015)
Parameter sniffing, or more correctly lack thereof. google: Grant Fritchey parameter sniffing, you should get one of his articles.
I will definitely check this out. Thanks again. It is much...
July 21, 2015 at 12:22 pm
I figured it out! something was funky having @timeint = 5 and @now = GETUTCDATE() and @comma = ', '. I replaced all the variables with what they equal...
July 21, 2015 at 8:44 am
Luis Cazares (7/21/2015)
Have you checked if anything is blocking this query, or if you have an adequate index?
There are only indexes for the timestamp column.
July 21, 2015 at 8:23 am
Luis Cazares (7/21/2015)
DECLARE @NACELLE varchar(max) = 'NULL, NULL, NULL, NULL',
@timeint int =...
July 21, 2015 at 8:11 am
djj (7/21/2015)
Try putting a print after each set to find problems
Will do.
July 21, 2015 at 7:54 am
It has been executing for over 6 hours. When I run the same script using a different database, it normally completes in under 20 seconds.
July 21, 2015 at 7:53 am
Viewing 6 posts - 1 through 7 (of 7 total)