Thank you, Grant! As someone who feels he never knows enough about database administration, I really appreciate your editorial.  You experts on these forums show a tremendous amount of patience...

Thanks for the question! I'd be curious to know Gail Shaw's or Jeff Moden's take on this kind of query.

- webrunner

Thanks for this question. I got it wrong so need to study more.

- webrunner

Hello hurricaneDBA,

Whichever version you decide on, I highly recommend reviewing and adapting the checklist at the link below. I found it extremely helpful.

March 7, 2018 at 9:30 am

#1982243

Thanks for this instructive question.

- webrunner

Way late to the party, I know. But I just ran into this question while checking some data in the SQL Monitor repository. This page proved helpful:

Thanks for the instructive question.

By the way, for anyone out there interested in NFL passing data, this year's Super Bowl saw the continuation of a strange, 51-year QB...

Thanks for the article. My only suggestion would be to move the SQL injection warning into a prominent box at the top of the article. Many readers might jump right...

Thanks for this question! I recently re-learned this info, and the way I remembered it (I know it's probably a bad mnemonic but it works for me) is: "COUNT (ALL...

Thanks for this question. I find it odd that the feature would not have returned an error about conflicting rules. Especially since it apparently silently allowed additional rules to be...

Here is a slight edit with the complete table variable declaration, just for fun.
Thanks for the great question!

declare @TableAsc table
  ( [Value] varchar(30)

Thanks for this very instructive question!

Happy new year,
webrunner