Nice straghtforwards question.

I found this one easy to answer because years ago I wrote some code to detect undesirable blocking behaviours in a particular system that had a couple of...

That's the most sensible comment I've seen...

Mauve (6/17/2008)

---

I somewhat disagree that a TIMEOUT can be used to end a WAITFOR. It cannot be used independently and is only an optional modifier of the Service Broker...

Nah, not a cynic. Just sensibly limiting...

stewartc-708166 (12/23/2010)

---

Tom.Thomson (12/23/2010)

---

stewartc-708166 (12/23/2010)

---

Having investigated this further, I have found that the "correct" answer occurs on SQL2000 and SQL2005 RTM.

this was registered as a bug and repaired with CU2 of...

stewartc-708166 (12/23/2010)

---

Having investigated this further, I have found that the "correct" answer occurs on SQL2000 and SQL2005 RTM.

this was registered as a bug and repaired with CU2 of SQL2005 (also...

bitbucket-25253 (12/22/2010)

---

WayneS (12/22/2010)

---

I finally got around to creating a connect item dealing with SQL Server not honoring default data/log file locations for new databases until the service is restarted here.

I...

I can't see any reason it wouldn't be OK. But a couple of things look slightly eccentric (not wrong, just strange choices).

Not sure what is the reason for splitting...

It depends on who you are eating with. 😉

CirquedeSQLeil (12/22/2010)

---

Daniel Bowlin (12/22/2010)

---

bcsims 90437 (12/21/2010)

---

Kit G (12/21/2010)

---

Full Lunar Eclipse on the Winter Solstice

(in the wee hours of the morning)

Been about 460 years or so (round to an even 500...

Seth Kramer (12/18/2010)

---

I accept I got it wrong, but what do you mean the second transaction fails? Only the insert null into the primary key field statement fails. There are...

Nice clear question and answer (apart from the typo in the explanation).

BUT: the more I see of this stuff the more I think the way XML was introduced into SQL...

The somewhat contradictory MS documentation is a bit of a mess. Anyway, it seems clear that if you lose File 1 page 9 in a mirrored database you can't...

I don't like any of the answers offered. The one I think comes nearest to being sensible is to increase the test DB size (or actually to not make...

Mighty (9/22/2008)

---

The only thing that you could say is that it was not 100% clear if the question was related to all server side traces, because with c2 audit mode,...