Browse by Tags

• included columns
• indexes
• sort

• Geek City QUIZ: What happens when you change a column in an index from a key column to an included column?

  This quiz is not really a generic question about changing an index key column to be an included column; it's about a behavior noticed by a reader in one particular query. Dejan Nakarada-Kordic from New Zealand sent me a very interesting puzzle. He had Read More... Posted Monday, November 24, 2008 12:15 AM by Kalen Delaney | 4 Comments Filed under: sort, included columns, indexes, query tuning

• Did You Know: Can Query Tuning Become Unnecessary?

  I wrote a commentary for the SQL Server Magazine e-newsletter last week, and was expecting a to get a bit more feedback than I did.So I'm hoping my blog readers can help out. I was commenting on a message that one of my business partners had sent out Read More... Posted Sunday, September 07, 2008 7:49 PM by Kalen Delaney | 25 Comments Filed under: query tuning