Indexing

Category: indexing

My SQLPASS 2015 Session Evaluations

My SQLPASS 2015 Session Evaluations

on November 24, 2015

Category: indexing

I recently gave a day long session at the SQLPASS Summit called “SQL Server Index Therapy Session”. 61 people attended, and let me tell you I was thrilled with that number. I’ve co-presented lots of day and week long sessions, but this was the first day long session that I’d ever done solo at a conference and 61 people was a terrific number.

Continue reading

The 9th Day of SQL: Things Are Not as Simple as They Seem

The 9th Day of SQL: Things Are Not as Simple as They Seem

on December 21, 2010

Category: indexing

The 12 days of SQL

Brent Ozar (blogtwitter) had an idea: a group of people should blog about writing which they’ve loved this year by people in the SQL community. For each “day of SQL,” someone picks a blog which they thought was great and writes about it.

Continue reading

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