Viewing 10 posts - 1 through 10 (of 10 total)
Sean,
attached is an old script I came up with a few years back (I'm sure somebody else thought of this before me).
It checks what the existing advanced options and xp_cmdshell...
August 15, 2013 at 1:30 pm
This is a great script, thanks for sharing it. I made a few little tweaks that others might find useful.
---I made @vRecipients a parameter that can be passed at the...
August 15, 2013 at 9:11 am
After some digging I found one I had done quite time ago. In my opinion, it has a little nicer output. Also, I didn't realize about the every...
August 14, 2012 at 2:24 pm
Lynn Pettis (6/22/2009)
Sorry, but according to BOL (Books Online) that information is not stored in metadata.
Yeah, I saw that in BOL also. But it HAS to be stored somewhere....
June 22, 2009 at 11:43 am
Thanks for your help, good information! Hopefully I can return the favor sometime.
June 14, 2009 at 6:28 pm
Paul White (6/13/2009)
rob.patterson (6/12/2009)
When page_count is less than 15, sometimes the avg_fragmentation_in_percent stays the same, sometimes it goes up.
The first eight pages for a structure are allocated from mixed extents...
June 13, 2009 at 8:18 am
Paul White (6/12/2009)
Can you post the results that show you that fragmentation is increasing together with the query that generated the results please?
I want to make sure that you...
June 12, 2009 at 9:00 am
Viewing 10 posts - 1 through 10 (of 10 total)