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 for this month’s T-SQL Tuesday, hosted by … Continue reading The power of T-SQL’s APPLY operator

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 really not something to be put off by. … Continue reading SELECT and WHERE, but no FROM clause

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 here), so I’m not going to tag anyone else. I’m not … Continue reading A SQL story in 11 words or less