May 7 2009
Yesterday I was in full crisis mode dealing with a production server that was not showing love to the users; I call that Wednesday. Phone rings; number I’m not familiar with, and harmless according to the caller id. I answer it and get a full press sales pitch from <REDACTED> barely after I can get [...]
Mar 6 2009
What are your practices when it comes to dealing with commercially developed database performance issues in your environment?
Feb 26 2009
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.
Feb 20 2009
Overview of the statistical indexing DMVs and DMFs for SQL Server. sys.dm_db_index_operational_stats, sys.dm_db_index_usage_stats, and sys.dm_db_index_phyisical_stats.
