I originally posted this on 11/16/09. I repost here for the joy of TSQL Tuesday, and to add a very important change to the original solution. Here's the accompanying video – same material, different format. The video doesn't include the change, by the way. A solution is ever so much more elegant if you know the […]
Author: Jen McCown
Highly Amusing Index Frag Anecdote
I can't believe I haven't told this story from SQLPASS yet… and by the way, here's Paul Randal's blog on this same event/topic. One of the few sessions I managed to attend was a really cool Grant Fritchey (blog, twitter) session on DMVs. He was talking about the DMV that includes index fragmentation data (sys.dm_db_index_usage_stats) […]
Proving Views Can Hurt Performance
Content rating: Beginner to experienced For some of you, this will be a "no duh" blog. But I've had this argument with people, so here we go. Views can hurt performance. Not by their very existence, no. Not by rule, no. But in certain situations, yes. The situation is: If you're querying off of a […]