Viewing 15 posts - 3,811 through 3,825 (of 5,843 total)
Stop using maintenance plans. PLEASE do yourself a HUGE favor and get a copy of Ola Hallengren's FREE and DOCUMENTED maintenance suite (ola.hallengren.com). Learn to use it's goodness....
November 2, 2010 at 8:55 am
1) the fact that table variables are used in the demos is likely creating execution plans that will not play out in the real world where actual tables are used....
November 1, 2010 at 8:01 am
Andy Leonard (10/29/2010)
LOL Guru!I think Alex is trying to tell me the same thing, although he's being much nicer about it than you!
:{>
LOVE your tweet btw! ...
October 29, 2010 at 11:34 am
mkarthi1982 (10/28/2010)
Thanks for the Replies.I have speed up the performance using Maintenance Plan with Rebuild and Reorganize.
If you are doing rebuild and reorg on the same tables, PLEASE have a...
October 29, 2010 at 10:44 am
What an utterly useless and pointless article!! Andy, you need to stick to something you know about, such as SSIS. Messing around with an actual database may well...
October 29, 2010 at 10:42 am
This strikes me as an exceptionally complex and risky evolution, and as such I must STRONGLY recommend you not rely on a forum to assist you. Engage a QUALIFIED...
October 28, 2010 at 7:56 am
here would be my response, in order:
1) dropped index. would do a schema compare from known good config for db
2) new version of code rolled out - same as...
October 27, 2010 at 8:27 am
EchoKilo: forums are a place for SIMPLE - QUICK problem resolution because they are 'staffed' by people volunteering their time. What you have presented could take days or...
October 27, 2010 at 8:19 am
I take it from your statements and question that you have not done a waitstats analysis. Search web for sql server 2005 waits and queues and you will find...
October 24, 2010 at 10:43 pm
1) did you actually CHECK the fragmentation level before issuing the reorg command? reorg can actually log WAY more tlog data than the entire size of the table if...
October 21, 2010 at 10:15 am
GilaMonster (5/18/2010)
Might be time to contact CSS at this point. Those look nasty.
Past the time to be on the phone with Microsoft I think . . .
October 21, 2010 at 10:12 am
This is a classic "it depends" question, with many options - each with their own pros and cons. Replication, log shipping, mirroring, snapshots each could be the right answer,...
October 21, 2010 at 10:10 am
Here's my thought: if they are having unacceptable performance accessing a 13M row table then there is something seriously wrong here - and it isn't likely to be index related....
October 20, 2010 at 9:18 am
unless you have an infinite timeout set on this service (and other things hold true), YES you WILL need to stop this service. You can throw all you want...
October 20, 2010 at 9:11 am
1) HIRE A PROFESSIONAL TO GUIDE YOU OR YOU WILL BE DISAPPOINTED, as have so many others, when moving SQL Server to a virtualized world.
2) I have a client with...
October 19, 2010 at 9:15 am
Viewing 15 posts - 3,811 through 3,825 (of 5,843 total)