If the team becomes dependent on her, that is a problem with the team, not her. Motivated individuals can ask to be taught or can learn on their own to...

Great QOTD and discussion, especially on batch boundaries and ROLLBACK of nested transactions. I was unsure whether BEGIN TRAN was part of the batch, as well as the effect of...

Thanks for the article! Often we're in a hurry to "make it work", and when we don't get the anticipated results, we just "try something else". It's almost always...

Thanks for the article, Steve. Very cool that these files can be manipulated either from Windows or from SQL Server and they remain in sync.

It may be my...

Very good article. The behavior of LAST_VALUE() would seem unintuitive without considering the frame. Thanks for highlighting this potential "gotcha".

I tried to apply the ROWS/RANGE clause...

"REBUILD enables a disabled index."

D'oh!

Very nice question, and excellent explanation.

The question did say "the relational model or XML". I guessed that a relational database model would most likely be appropriate, applying XML as needed. I'm not going...

Thanks for this question. I remembered that there was inconsistent behavior surrounding the RESEED but forgot the specifics until I read up.