One resolution to “sys.sql_dependencies does not have a matching row”

This particular issue I’m about to describe should be pretty rare, but I’m posting this here in the event that someone else encounters it and then finds this post and then hopefully applies the “minimum required dose” required to fix the problem instead of using more sweeping methods such as restoring from database backup…  I […]

Exceptions – what sys.dm_db_index_usage_stats doesn’t tell you

I was thinking back to a conversation I had some time ago regarding cases when sys.dm_db_index_usage_stats does not get updated after an index is used for just the statistics associated with the indexed columns.  What makes this profession so interesting is that almost every tool we use has a "yes, but…" associated with it.  What […]

Observer overhead – the perils of too much tracing

While it’s good to keep an eye on your SQL Server instances – it’s a balancing act.  On one side you want to be sure that you are monitoring critical areas and pulling enough information to perform root cause analysis on anything out-of-the-norm. But on the other side, if you pull an excessive amount of […]