Easy one for me. 🙂 Specially after going through all the options carefully and matching each one of them with the entries in the table. 🙂

If you are not getting anything in profiler for blocking during the invoice update process, then you might want to check execution plan of the underlying procedure doing the update...

Very good article and nicely explained analysis.

Easy but good question (had some harsh experience in the start of my career). 🙂

L' Eomot Inversé (10/28/2013)

---

Nice question.

Has one small problem though: the code leaves a transaction open - nothing is actually committed.

It's clearly stated in BOL:-

Although each COMMIT TRANSACTION statement has a...

Very good QOTD Tim. 🙂

Well i think it's...

Good one Koen and Carlo... 🙂

Great QOTD. Why ? because i've yet to work on SQL 2012 and these sorts of questions help me getting familiar with new useful functionalities. Keep it up John. 🙂

Koen Verbeeck (10/23/2013)

---

Easiest question ever. It doesn't even matter which feature is being asked.

Enterprise has every feature, and developer & evaluation have the same features as Enterprise.

Ergo, no thinking needed,...

T.Ashish (10/21/2013)

---

crussell-931424 (10/21/2013)

---

I can't win on these. If you read it exactly as it is written then people complain that we should have understood what the question was really asking...

Since I'm not much into ETL and going through learning curve, i had to check out for answer from web and in the meantime was glad to learn about SCD...

Nice tricky question. I was about to click wrong one but at last moment checked the other option which was correct. It was doubt enough for me to re-check the...

+1....

Good to see an easy question to end the week (specially after hard thursday QOTD) 🙂