Viewing 15 posts - 16 through 30 (of 218 total)
Jeff Moden (3/4/2013)
GregoryF (3/4/2013)
Evil Kraig F (3/4/2013)
GregoryF (3/4/2013)
Is it possible to pass a variable for MAXDop as a query hint?
As mentioned above... no.
However, why would you want to do...
March 4, 2013 at 4:45 pm
Evil Kraig F (3/4/2013)
GregoryF (3/4/2013)
Is it possible to pass a variable for MAXDop as a query hint?
As mentioned above... no.
However, why would you want to do this? MAXDOP...
March 4, 2013 at 1:47 pm
One word of caution: if you are using the GPU method (which does seem to be quicker) and you are running Vista/7 with window's aero enabled, you will have a...
March 4, 2013 at 11:19 am
TravisDBA (3/4/2013)
March 4, 2013 at 9:30 am
boris_shvartsman (12/17/2012)
December 17, 2012 at 7:20 am
I think you may have just solved my riddle of why it fails on SharePoint DB's that contain GUID's in their names. Thanks!
Just to confirm, I ran it against...
October 4, 2012 at 5:19 am
DBMonitor is just the name of our administrative database, it does not belong to a third party tool. You can put the SP in any databasse (master, msdb, etc)
September 21, 2012 at 8:05 am
Sailor (3/12/2012)
"NB:
@Fill_Factor, @PAD_Index will only be applied to index that are rebuilt (Fragmentation >= @ReBuildTheshold)
***There is a possible issue with database names containing GUID's***"
What's the possible issue? ...
March 12, 2012 at 2:41 pm
Soorya (1/15/2012)
January 16, 2012 at 5:01 am
Nice script; however, I fail to see where it gives me dynamic sql with 'alter table' for the uncompressed tables. When I ran it, it just showed the tables...
December 12, 2011 at 5:49 am
You could improve upon this script by using sys.partitions to only include rebuild statements for tables that are already uncompressed. This script will rebuild all tables, regardless of whether...
December 12, 2011 at 4:59 am
Interesting question, though entirely triva as in the real world this is *so* unlikely to ever be tested. It's kind of like what is the max size for a...
December 8, 2011 at 6:06 am
skraghava (8/24/2011)
I think it if page level locking is disabled then you have to rebuild and not reorganize.
Send me a private message and I will send you the latest version...
August 24, 2011 at 8:34 am
eelliott 75257 (8/23/2011)
Does SQL not provide for this within the Maint process?
I don't use maintanence plans, but last I remember (SQL 2000) they had the ability to remove files older...
August 23, 2011 at 11:05 am
Viewing 15 posts - 16 through 30 (of 218 total)