April 2009 - Posts

• Sometimes you just have to break it up

  I will be the 1st to admit that I am no Itzik Ben-Gan when it comes to writing complex SQL statements and I wonder at times how people come up with some of the Selects that I see.  Sometimes they are so complex or convoluted that I simply have a Read More... Posted Tuesday, April 14, 2009 8:19 PM by Andrew Kelly | 6 Comments Filed under: DBA, Developer, Performance, Tips & Tricks

• Speaking in Raleigh NC

  Just an FYI for anyone in the Raleigh NC area that I will be speaking at this location for the first time on April 21st.  This is a fairly new SQL Server User Group and PASS chapter so I am sure they won’t mind any free marketing they can get :). Read More... Posted Saturday, April 11, 2009 3:14 PM by Andrew Kelly | 0 Comments Filed under: User Groups

• How Dirty are your Reads?

  As a SQL Server consultant I get to see a lot of different sets of code written by all sorts of database developers from all over the world. And I have to say that one thing that is clear is most developers make abundant use of the NOLOCK query hint or Read More... Posted Friday, April 10, 2009 8:08 PM by Andrew Kelly | 20 Comments Filed under: Best Paractices, Developer, Humor, Trivia