Nonclustered indexes require the “lookup” key in the b-tree when?

I received a great question in email and it’s something I cover in our IEPTO1 (Immersion Event on Performance Tuning, Part 1) so I thought I’d write a post about it… Question:  When you have a non-unique key value in a nonclustered index, SQL Server adds the RID / Row Identifier (if the NC is on a […]

SQLintersection Conference and SQLafterDark Evening Event – what a fantastic week in Vegas!

      It’s been a busy few weeks… and it all came together amazing well last week as we had our twice yearly SQLintersection conference (the Fall event is usually held in Las Vegas). It was only 2 years ago that we decided to move to a different format and really handle a conference […]

Building High Performance Stored Procedures

[NOTE: Update 12 Nov 2014. The most recent bug (KB article KB2965069) is THANKFULLY very unlikely for most environments (mentioned below). As a result, I’m glad to say that we can use OPTION (RECOMPILE) as a much easier (and safer) solution. So, while I’ll still leave solution 3 as an option if you run into troubles with […]

And so it (PASS 2014) begins…

Tonight is the opening evening event for PASS 2014 and we’re (SQLskills, as a team), really looking forward to seeing familiar faces and hearing your fantastic questions, problems, and DBA-stories. I’m putting the final touches on my session (and also going over feedback from last year’s session) and I stumbled on a bunch of photos that […]