Lynn Pettis (3/17/2010)

---

john.arnott (3/17/2010)

---

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

Oh great... Now I have to learn about more updates to SQL Server 2008 R2... just when I almost had a grip on the current version features 😀

OK, now I know one more thing about working with identity columns. Thanks!!!

I just picked the longest answer. I have to go back and learn how to do this right, I guess :w00t:

I thought it was reasonable to assume that there would be at least one record in the table that would be returned with CategoryID = 7, so that left only...

I got lucky...

I saw IN, clicked operator, hit submit and immediately hit stop on the browser as I saw the Predicate answer.

You may deduct a point if necessary for changing...

Since the question only wanted to know whether the 10,000 rows would be included in the backup, I would concur that the explanation is correct. We do not need a...

Yay! Thanks BOL! I taught that last week... but with the wrong information that I learned from BOL... lol ... I guess I need to pay more attention to the...

john.arnott (1/13/2010)

---

The 2008 BOL (link provided by Cliff) is moderately ambiguous, don't you think?

The following table lists and describes the severity levels of the errors raised by the...

Tom.Thomson (2/12/2010)

---

A very useful question. I've learned something new. Policy-based management begins to look more useful.

But I guess MS must have changed their mind at some point but forgot...

I guess it is lucky that I usually get around to QOTD weeks after if comes out and is fixed 😀

I think I will make a point of staying about...

I like to think of the right answer as being the one "closest" to being right, which was the right answer which I chose despite knowing that the output did...

Not sure where all of these 3mb/1mb numbers are coming from but when I do fresh installs of SQL 2005 or 2008 (which I do a couple of times a...

Nicely worded question as a DENY is used to override any non-explicit permission. Another excellent example for my class! 🙂

Wow, I thought 2 points was generous. Nice, clear question that just made me read the T-SQL carefully. This is a good exercise for my students. Thanks!