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...

Ah Okay, good call. Good luck with that surgery. My father in-law just had knee surgery and recovered fully in under 2 months. Pretty good at 65.

Thanks for the question. Happy Friday.

quackhandle1975 (1/10/2014)

---

KWymore (1/9/2014)

---

Train for a marathon and get a bunch of people to sponsor you for charity. Then run it about a week before you have to go back to...

Train for a marathon and get a bunch of people to sponsor you for charity. Then run it about a week before you have to go back to work. Blog...

Nice question Igor! I want to get into using data mining more but time seems to have a way of preventing this. Maybe this year I will get to it....

jay-h (1/8/2014)

---

The holidays are quiet as a tomb around here, so it's a good time to get stuff done. Especially the week from Christmas to New Year because it's a...

I have only ever used the reseed option in dev. However, I had used it recently enough to get this one right! 😀 Thanks for the question Uwe.

I answered this one incorrectly as well. I got stats back after restarting my SQL server. While there was little information, there was still something returned.

This question could now be updated to include MERGE in that list. A very handy clause.

I opted to look this one up and was glad that I did so. I wanted to say that Rollback Work was nonsense. I am surprised that the [Work]...

I almost picked the "correct" answer but then thought that there are a number of steps and commands that need to be executed on the mirror before replication could work....

Nice question, thanks.

Thanks for the fun question Steve. Haven't converted anything from binary since school. Happy 2014 all.

Nice question to end the year with. I have had to monkey around with dates this way before so it seemed quite familiar to me!