Two months ago I blogged about a procedure I wrote that, if you are using Ola Hallengren’s index maintenance routine, can look for indexes that are being repeatedly defragged. This usually indicates that the fill factor can be adjusted downward so that the index doesn’t need to be defragged every time your maintenance routine runs. […]
You are an awesome DBA. You have complete control over your dominion. You have all your backups automated and the testing of those backups is automated. You have alerts properly configured on all your servers. You have your index maintenance plans running regularly. You ride a unicorn to the office and George Hamilton asks you […]
I submitted a script to SQLServerCentral.com and it’s been published today. The script automatically re-trusts foreign keys or constraints. It will also report any that could not be re-trusted. Discussion about the script can be found here. I have post here about how your foreign keys and constraints might become untrusted and why it is […]
Pop Quiz, hotshot. A vendor installed a maintenance plan on one of your SQL Servers. It looks like this: What do you do?
I’ve been playing around some more with SQL 2012 and I discovered another nice little improvement. This isn’t anything huge, but rather a nice little touch that makes my life as a DBA a little bit easier. If you have your SQL Agent jobs configured to send you email when they fail (or succeed or […]