Viewing 5 posts - 1 through 6 (of 6 total)
SQLKnowItAll (1/17/2012)
January 17, 2012 at 9:11 am
Divine Flame, thank you very much for your help; your posts are real helpful! I will try to use those queries and see what i discover..
Thank you!
January 17, 2012 at 4:06 am
Regarding update statistics, you may be right... i made some tests and saw that this operation itself is very resource hungry; i'll wait to see what happens;
Regarding traffic, we have...
January 16, 2012 at 11:33 pm
Divine Flame (1/16/2012)
Try to use the MAXDOP hint in your index rebuild statement & test the performance after that:
ALTER INDEX IndexName ON TableName REBUILD WITH (MAXDOP=1)
I am not sure I...
January 16, 2012 at 5:49 am
Thank you for your quick response!
I will remove the "update stats" statement; regarding the job schedule, we used to have it on Saturday at 3AM, but what made us...
January 16, 2012 at 5:05 am
Viewing 5 posts - 1 through 6 (of 6 total)