Browse by Tags

• execution plan
• indexes
• nonclustered index
• plan guides
• seminars
• sort
• training
• user groups

• Geek City: Clustered or Nonclustered? Why not both?

  I had been thinking of this post all day, and then noticed that Denis wrote a post with almost the same name . I was worried he might have written about something similar, but it turns out not to be the case. A group of colleagues have been having a discussion Read More... Posted Thursday, April 24, 2008 3:51 PM by Kalen Delaney | 4 Comments Filed under: index hints, indexes

• Did You Know? Everything's Up to Date in Kansas City!

  They are so up-to-date, I have chosen it as one of the handful of cities on my user group tour... I'll be presenting a full day seminar on Controlling and Reusing Query Plans in SQL Server 2005. You can get more information from my schedule page at schedule.KalenDelaney.com Read More... Posted Friday, February 01, 2008 11:54 AM by Kalen Delaney | 1 Comments Filed under: training, index hints, execution plan, plan guides, user groups, seminars

• Did You Know? Forcing a nonclustered index scan to avoid sorting

  Hopefully, if you know enough about SQL Server to understand most of my posts here, you're aware of the fact that using a nonclustered index is not always an optimal choice for accessing data, particularly if there are thousands (or more) rows of data Read More... Posted Sunday, July 22, 2007 11:13 AM by Kalen Delaney | 4 Comments Filed under: index hints, nonclustered index, sort