Viewing 15 posts - 3,586 through 3,600 (of 5,843 total)
It is amazing that 9GB of disk space is a problem these days. You can fit that on a USB key now! 😀 Hopefully the batching process works...
February 22, 2011 at 6:43 am
My advice is to stop using maintenance plans. Get the free and awesome maintenance suite from ola.hallengren.com.
February 22, 2011 at 6:39 am
sickpup (2/21/2011)
February 22, 2011 at 6:38 am
There is no direct way that I know of to do what you wish.
You could try creating a MASSIVELY complicated pile of dynamic sql to do it. ...
February 21, 2011 at 7:38 am
Nicely done.
"...for correcting grammar errors, illogical sentences and an appalling dearth of punctuation."
Those things are vastly overrated in technical articles anyway Gail! 😀
February 21, 2011 at 7:35 am
d@mmit! I had a nice response typed in and submitted and it isn't showing up! 🙁
Anyway, let me try to recreat.
One thing I didn't see mentioned is if the WHERE...
February 18, 2011 at 9:48 am
One potentially HUGE performance item I didn't see touched on is if the column(s) in the WHERE clause are indexed you should do some initial testing to adjust batch size...
February 18, 2011 at 8:25 am
Are you perchance doing statement level completed tracing (RPC or TSQL)?? Those can be DEVASTATINGLY HARD on the server if you have UDFs in plan, or cursors, triggers, etc.
February 18, 2011 at 8:16 am
You can check the fragmentation and 'page fullness' using the index physical stats DMV. You might want to do that on the other file groups just to be thorough....
February 17, 2011 at 7:29 pm
There are MANY reasons to not use autogrowth to manage your file sizes. quickie list (NOT inclusive at all!!): delays for initialization if you aren't on instant file initialization...
February 17, 2011 at 2:48 pm
sickpup (2/17/2011)
So, looking back through the settings on the index rebuild maintenance task, I see that "Change free space per page percentage to:" is set...
February 17, 2011 at 10:41 am
There are numerous places where cursors are acceptable if not preferred, IMNSHO. What we REALLY need is faster-performing cursors from the Microsoft engine team!!
February 17, 2011 at 6:14 am
The missing indexes engine is a good place to check for candidate NC indexes. Make sure to check for similar indexes already existing though - that subsystem doesn't know...
February 17, 2011 at 6:11 am
1) That's an interesting script for dupe index checking Jason. Haven't seen one like that before. I need to give it a try.
2) Duplicate indexes can indeed cause...
February 17, 2011 at 5:40 am
Viewing 15 posts - 3,586 through 3,600 (of 5,843 total)