USE THIS: sp_helpindex

Since I’ve rewritten sp_helpindex a few times, I have a few blogs posts in this category. Each time I do an update I’ll make the NEW version titled USE THIS and I’ll change all others to (OLD). The point of this updated version of sp_helpindex is to add details for newer functionality (included columns and […]

Explicitly naming CL key columns in NC indexes – when and why

This morning, as I was prepping for my PASS Data Architecture Virtual Chapter presentation on “Why Physical Database Design Matters,” I went to tweet that folks could join the presentation. I stumbled on a discussion that led to Robert Davis (@SQLSoldier) asking this: I was searching to see if you had a blog post on missing […]

(OLD): A new and improved sp_helpindex (jokingly sp_helpindex8)

NOTE: I’ve released other versions of sp_helpindex since this post. Check out the category: sp_helpindex rewrites for all of the options! OK, I first blogged about re-writing sp_helpindex here as sp_helpindex2 (April 2008). Shortly thereafter (Aug 2008), a reader found a bug and when I went digging, so did I (a couple of others). I did […]

Favorite SSMS Options – and some gotchas

Whenever I setup a new machine, I like to set a few default options in SSMS. Here are my favorites: Tools, Options Environment Fonts and Colors Text Editor font: Lucida Console (a bit thicker and it's a fixed-width font) Text Editor: Selected Text (under display items) Item foreground: Black Item background: Yellow (looks like a […]