The answers should have been a little more varied; as soon as one recognizes that restrictions 1 and 2 are both true, then 3-5 do not matter because 'all true'...

Nope, lots of people hate XML. (raises hand)

I messed it up; didn't...

ZZartin (7/10/2015)

---

Xavon (7/10/2015)

---

It depends. We effectively have two systems, one for managing the business and the other for reporting. For the management system, downtime is more important. ...

It depends. We effectively have two systems, one for managing the business and the other for reporting. For the management system, downtime is more important. For the...

matthew.flower (7/1/2015)

---

I agree completely with Toreador on this - the query returns the two table names and the name of the foreign key constraint between them.

As the first two answers...

Agreed on the vagueness. I got it right for the wrong reason; I thought "the other four are for row identification (in some way, shape, or form) while DATEADD is...

Of course perfect availability is impossible. Even you have mirrored copies of your DB in six different data centers, and only do maintenance on one at a time, you...

I thought it was number three, but when I ran dbcc checkdb on SalesArchive (from the last two questions about disabled Clustered Indexes), I got back an error saying it...

Xavon: I never rename objects!

Chorus: What, never?

Xavon: No, never.

Chorus: What, never?

Xavon: Well... hardly ever!

But seriously, the most common reason I rename objects, is when a non-null...

Yeah, I did it. I figured out the author's intent instead of the proper literal interpretation of the question.

I guess it helps that this is a follow-up...

I somehow read the options 2 &3 three as sproc is/is not created, not sproc is/is not executed. So I picked 2 instead of 3. Got 3/4, can...

Interesting question.

But I am disappointed the QotD was not May the 4th related.

Situation where this would be used... A sproc that creates a global temporary table, calls other sprocs on separate threads to populate/update that table and uses CDC to monitor...

An interesting point on this; PCI PADSS (credit card industry rules) require that the system be under support. So if your 2005 database holds credit card information, even if...

Upgrade Treadmill, or Upgrade Hamster Wheel?

It could be worse. Despite being a software developer with a side of DBA, my company does not let me control when upgrades get...