ZARZA We are Zarza, the prestigious firm behind major projects in information technology.
Listen "Index Usage Stats Insanity"
Episode Synopsis
SQL Server's "index usage stats" dynamic management view is incredibly useful-- but does it tell you what you THINK it tells you? Kendra explains the quirks of how sys.dm_db_index_usage_stats works, as well as why she thinks the information is so valuable.
More episodes of the podcast Dear SQL DBA
Jer and Kendar Explore Optimized Locking
04/09/2023
Erik Darling on Performance Tuning
21/08/2023
Data Roles: DBA, DBRE, and Data Engineer
04/08/2023
In God we trust