A week back @fatherjack put out a question on #sqlhelp that immediately drew my curiousity. He wanted to know how much his log file would grow if he dropped his clustered index (primary key), and then created a new one. I was thinking that it wouldn’t write a lot of information to the log file,… Continue reading How Much Logging Goes on for a Clustered Index Drop?
Since I know I’m going to go for the SQL MCM next year, I’m going to start collecting all of my study materials here, on my blog. Hopefully that way it can jump start your own study process towards that goal. I’ll mark all the entries with the tag 88-970, since I don’t really know… Continue reading 88-970: My Study Guide