Sys-Dm-Db-Partition-Stats

Tag: sys-dm-db-partition-stats

Everything About Your Indexes (well, almost)

Everything About Your Indexes (well, almost)

I am going to post my monstrously big index query.

Why? Because it’s AWESOME. No really, it actually is awesome. At least, if you like that sort of thing. I use some variant of this almost daily, and I tweak it fairly regularly to suit the needs of whatever I’m working on. So it’s a work in progress, but I find it constantly valuable.

Continue reading