2013 Edit: I’m a busy and/or lazy person, so I’m letting last year’s advice stand on its own two feet. Nearly all of it is still entirely relevant – except instead of playing with Denali, I suppose you should be looking at SQL Server 2014 news. Anyway, read this, and check out my actually updated […]
Category: sqlserverpedia-syndication
Find Duplicate (and covered) Indexes
A while back, I wrote a simple little query that lets you Get Index Included Column Info (because sp_help and sp_helpindex only show non-included index columns). More recently, I’ve been wanting not only a better way to look at index information, but a way to compare indexes…for example, to find duplicate or covered indexes. Here, friends and […]
Lose #5 Before #sqlpass
Win Valuable Prizes! Impress Your Friends! This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn, because it ends right before PASS Summit (no, you don’t have to attend PASS to participate). Tom LaRock (Twitter, blog) and I are hosting! Here’s what you do: Submit you PayPal payment of $21 […]