Easy one comparatively to last day. 🙂

I selected correct answer but for wrong reasons. Thanks for the question. Nice to know about it. 🙂

Good one as wasn't aware of all of them. Thanks free mascot. 🙂

EZ for me. 🙂

Absolutely stunning question on filtered indexes. Thanks Carlo. 🙂

Good QOTD. Easy but good to know more about azure. 🙂

KWymore (1/13/2014)

---

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

Easy one to look out for. 🙂

Yeah, agreed Gail. After lots of efforts, i started getting frustate and tried too much in too little time. Glad that it worked and sad that couldn't found the solution....

Strangely it started working but still worst part is that I don't know what made it work. I tried lots of things but couldn't track what worked. I am sure...

Very good question from QOTD perspective. Thanks Dwain. 🙂

Sorry I wasn't clear. Here is the code:

while @a <= @b-2

begin

---

---

select @p = 'select col1 from '+@tabname -- this keep changing with each loop

insert into #temp

...

Worked nowhere near it but did some googling and go them correct. Nice to know though. 🙂

"Been there done that". Had spent some time on statistics related issue so never had to think twice. 🙂

EZ PZ. 🙂