February 2013 - Posts

• Geek City: A Grammar Geek in the Cloud

  Those of you who know me well know that I am usually a stickler for spelling, grammar and proper word usage. I may have even lost a few friends because of what some people see as obsession. I am not infallible, and I do make typos, but I like to try to Read More... Posted Wednesday, February 27, 2013 11:25 PM by Kalen Delaney | 18 Comments Filed under: writing, SQL Azure

• Geek City: Join With Me!

  I remember one of the most surprising changes in SQL Server 2000 2005 was how the graphical plans showed the use of a nonclustered index to seek, and the plan included something that looked like a JOIN to find rows in the base table. Here’s an example. Read More... Posted Thursday, February 14, 2013 3:16 PM by Kalen Delaney | 38 Comments Filed under: nonclustered index, indexes, query plans