Viewing 7 posts - 16 through 22 (of 22 total)
What advantages does this script have over Ola Hallengren's index maintenance solution?
July 25, 2014 at 5:14 am
Why is a char(32) being added to the table name? I noticed that this script is missing references, I wonder if this could be why?
I'm also curious, why is there...
April 25, 2014 at 5:25 am
Why not use sp_helprevlogin to script the logins/users instead? http://support.microsoft.com/kb/918992
Also, any reason why you decided to not include all permissions and only script roles?
November 14, 2013 at 5:39 am
tabinsc (6/6/2013)
2008R1 tells me:Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '='.
IIF isn't supported in 2008,...
June 6, 2013 at 6:13 am
Terrible question! Why?? Because it reminded me that I still am stuck with 2008R2.
Just kidding -- but anyway, good question.
June 6, 2013 at 5:57 am
Nevertheless, I understood the concept you were trying to convey.
The programmer inside of me had to point out a very specific detail.
I thought that was a very good question...
March 5, 2013 at 8:23 am
edit: misread the question.
But, how can (iv) be true?
How can the index rebuild remove the fragmentation from the index? The table is empty at that step so it should already...
March 5, 2013 at 5:39 am
Viewing 7 posts - 16 through 22 (of 22 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy