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?
I recently had a epic failure on my workstation. It was bad. My machine simply stopped working, and when I rebooted everything looked fine, until I saw it blue screen during boot. So here I go with lessons learned during a critical failure. RAID 1 is great …so long as your controller can still function… Continue reading Lessons Learned
It all started Thursday afternoon, about 1500. I was walking back from Starbucks with my afternoon pick-me-up, when a co-worker mentioned we have this process or person who shrinks the log file, apparently every week. “Is there some way I can find out who, or what is shrinking the log files?” And with that, I… Continue reading Who Shrank Roger Rabbit