20 – Index Usage DMVs are Lying Liars (26m)

You know how you’ve been putting all that faith in those DMV scripts that tell you whether an index is getting used or not, and whether it’s getting seeks or scans? We’ve got some really bad news about that: they’re simply and wildly incorrect, as we shall now demonstrate. Demo script: Transact-SQL /* THE INDEX...