With apologies for my ignorance on the subject, I'm not sure what's going on because I don't actually use index maintenance plans, mostly because of the many reported horrors about...

Just to add fuel to the fire, what do you want done if something overlaps the shift boundaries?  Or is that simply not possible because you're truly only using a...

That still won't be accurate for the reasons I...

The problem with using "Reserved_Page_Count" is that it actually has little to do with row size.  For example, if you have an index that has suffered a large number of...

My first question would be... how did you determine that all those indexes were rebuilt just because they had a frag level > 0?

Also, a screen shot of your "Rebuild...

It would appear that you forgot to attach the code but, based on the narrative above, it sounds like you're on the right track to a fix.

I'm one of those DBAs that will allow the use of CLR.  I'm just not one to allow the use of CLR that doesn't make sense.  I had one guy...

Also, on the other thread for this subject, I posted a question...

Please, just so we know, why does this has to be a While loop? For example, will you be...

It would seem that the inputs are a wee bit important as to figuring out if the proc will be...

@ Steve Collins,

Great try/good thinking.  I'm thinking, though, that just about anything you add to it is going to slow it way down... especially since, if you read the article,...

Technically, not.  You can format with VARCHAR() but you have to use the correct "style" code rather than...

You might want to look up how the old Sybase money data types work. They round too soon and give the wrong answers. Google it. This is why competent...

I am curious why, given that RAND() is supposed to return random numbers, it always returns the same "random" numbers for the same query?. Is that by design for...

@jeff how do you do parallelism in SQL driven by an Agent job?   Note that I don't mean parallelism in execution plans; I mean actual parallel operations as in...

Hi all

I've come across a weird issue when creating folders using xp_create_subdir.

The folder properties don't appear to be propogating correctly.

I've just tried to access one of the folder to be...