Liked your article. How about this one...a logical DBA and a physical DBA. You may be scratching your head with these two job titles, but this is what...

Steve,

I use this a lot. I love DMV\DMF. Thanks for the question.

+1

Christian Buettner-167247 (1/13/2014)

---

For SQL Server 2008 R2 there is no valid answer, as sys.dm_exec_sessions does not contain the open tran count. But thanks to this, I have learned that this...

Gracias por la más fácil Steve

+1 🙂

Really good question. Had to think about that one for a second :-D. Of course, I was thinking more into your question like "what if there are relational...

Steve, I love these questions. Thanks:-D

Oh, here is an excerpt of a UDF I used to convert from int to binary (of course the other aspects of the UDF...

Steve, thanks for the question and Happy New Year to all.

I am really looking forward to memory optimized tables and indexes. I have been waiting for this for what seems like forever. 😉 Thanks for the question.

Steve

Yes ;-). Thanks Steve for the easy one. Good one for a Friday.

philip.cullingworth (11/3/2011)

---

When running this in SQL2005 I get the following response (after answering the question)

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg...

Thank you very much. More to come...

Thank you.

Good question. Thanks. I see some good conversation stemming from this question. 😉

Steve, your "humor" questions are pretty funny. I remembered 6 of the 8, so I had to ask my daughter about the remaining two :-D.

Merry Christmas and Happy Holidays...

Nice one. Thanks.