A nice question. I was lucky enough to see it after the wording was changed to reduce the number of correct answers to one.

But I do feel that...

It would have been useful also to alter the question to make it clear it was talking about...

brdudley (3/19/2010)

---

I'm sensing a loophole if we all just cooperate. Since, by the answer, we have been granted responsibility for the correctness of the answer, we ought to all agree...

Don't be sorry, I imagine most who see it will be gald to see that someone provided the deserved...

gamcall (3/17/2010)

---

"So if the insert transaction completes after the full backup is complete, how many rows where inserted till the backup gets completed will be included in the backup."

Shocking use...

vk-kirov (3/16/2010)

---

Hugo Kornelis (3/16/2010)

---

the backup first copies all the data pages, then adds all the log pages starting from the start of the oldest uncommitted transaction right up until the...

Good question.

But my head hurts from thinking about it, trying to work out which would be crazy. And I still got it wrong - so I've learned something too.

Shaun McGuile (3/4/2008)

---

Kas:

although I agree with you in principle a function will cover bad design - if you mean zero then zero should be what is in the column; 😀

I...

Andy Warren (3/11/2010)

---

Not knowing but guessing, my thought is that auto-shrink makes a lot of sense for businesses (like cheap web hosting) that want to conserve disk space and ...

Writing code to generate code is something that can save a lot of time. I've been doing it in many different languages for a very long time, and wouldn't want...

david.murden (3/15/2010)

---

I am surprised at how many of you are saying "I ran this and..." or similar. To me the questions are about YOUR knowledge of sql not your servers...

Lynn Pettis (3/10/2010)

---

Personally, I think every table should have a surrogate key as either a Primary Key (PK) or Alternate Key (AK). Especially when using a natural key for...

That's a very interesting redult, and quite remarkable. Congratulations on finding this method.

Yes, I hear it loud and clear. Pitiful :crying:, ain't it?:-D ;-). And just...

marvin.elder (3/8/2010)

---

Tom,

So you're "down" on Chris Date? Don't you give him credit for authoring the most widely used textbook on relational database structure and SQL?

Or is it that you...