April 2011 - Posts

• The power of T-SQL's APPLY operator

  I could go on all day about APPLY – it really is an incredible part of T-SQL. It helps solves problems were frustratingly painful to solve otherwise. It empowers the query writer in a way that is matched by few other features. This makes it a worthy topic Read More... Posted Wednesday, April 13, 2011 11:30 AM by Rob Farley | 13 Comments Filed under: sql, t-sql tuesday

• SELECT and WHERE, but no FROM clause

  SQL Books Online is wrong (or at least, on that page). I say that because it lists the FROM clause without brackets, suggesting that it’s not optional. This post is going to look at a few situations where we leave out the FROM clause, showing that it’s Read More... Posted Tuesday, April 12, 2011 12:05 PM by Rob Farley | 6 Comments Filed under: sql, t-sql tuesday

• A SQL story in 11 words or less

  Success Quietly Looms. Not quite 11 words, I know. I’ll put more at the end. Definitely SQL related though, right? (And it’s even an acrostic!) Tom LaRock started this, and Stacia Misner tagged me. Monday is over now though (heck, it’s well into Tuesday Read More... Posted Tuesday, April 05, 2011 1:29 PM by Rob Farley | 5 Comments Filed under: sql, community, lobsterpot, meme monday