Viewing 12 posts - 1 through 12 (of 12 total)
January 3, 2018 at 3:50 pm
January 3, 2018 at 2:29 pm
January 2, 2018 at 6:08 pm
January 2, 2018 at 12:13 pm
Hmmm.... they're overdue... I wonder when they're going to throw SSIS on the floor and replace it with something else like the old DTS was.
December 29, 2017 at 11:48 am
December 29, 2017 at 11:45 am
You can try to arrange your tables in specific order (to mimic the successful plan, that is the one where TABLE8 gets processed first) and enforce the order using "option(force...
March 16, 2017 at 12:37 pm
To be clear: I suggest using the query with OPTION(MAXDOP 1) not changing the server's settings.
February 10, 2017 at 5:20 pm
I don't know how large those tables involved but certainly would try to limit the number of processes to 1
February 10, 2017 at 4:32 pm
It would help to know what kind of query you are running. Setting MAXDOP 1 should significantly decrease wait time on CXPACKET.
February 10, 2017 at 4:15 pm
declare @min-2 float, @date datetime
set @date = getdate()
select @min-2 = min(abs(datediff(mi, [datetime], @date))) from
select [datetime]
from
group by [datetime]
having min(abs(datediff(mi, [datetime], @date))) =
September 21, 2007 at 1:47 pm
Viewing 12 posts - 1 through 12 (of 12 total)