Jeff Moden (3/11/2014)
@ChrisM,I noticed that you've not written an article on this subject yet and thought I'd give you a nudge. I think the list you came up with is outstanding and I'd love to see it take to the wing in the form of an article. I think you'd do an awesome job at it.
Jeff, I haven't stopped thinking about it since you mentioned it last and I've added a couple of sections since - transactions, ACID and locking and blocking. However, I'm extremely busy both at work and at home and it could be a while before I can tackle it. Here's the thing though - an article of this style is right up your street - Dwain's too, I know you've seen his "Make it Pretty" blog post. If I can't get near it in the next fortnight, it's all yours ol' friend.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden