My Top 5 SQL Server Indexing Best Practices
What are the top 5 indexing best practices? That’s pretty subjective, but here you go. I’m sure the list would be different tomorrow or even five minutes from now.
Blog Posts
A Line in the Sand
What are your practices when it comes to dealing with commercially developed database performance issues in your environment?
I Was In The Pool! Dealing With SQL Shrinkage.
Sure, we tell you not to do stupid things to your SQL instances: never turn on auto shrink, never turn on auto close, never NOT back up your databases, never use sa for anything – ever. Those things we still stand by. However, there are times you may need to shrink a database or not backup a database: the important thing is to know when it’s appropriate to do inappropriate things in SQL Server.