Paul Randal (6/8/2010)

---

Hugo Kornelis (6/8/2010)

---

Good question, Paul!

In your explanation, you write that log backups are about the same size as when full recovery had been uses. This matches my expectation,...

Good question, Paul!

In your explanation, you write that log backups are about the same size as when full recovery had been uses. This matches my expectation, but in Books Online,...

I just checked back on the discussion to see if there are any questions that I need to answer, but I see you guys are doing a great job of...

dbowlin (6/7/2010)

---

I am not sure I understand the logic behind this one.

This query will result in a single unnamed column with a value of 5

SELECT COUNT(*)

FROM QotD

WHERE col2 <> 4

How...

MG-148046 (6/7/2010)

---

I thought it would be an empty result but wasn't positive decided to "test" and created the table. I got this message on executing the query:

Msg 8121, Level 16,...

Thanks, UMG!

And you are right, that would have been a better distractor. I'm not sure why I included the "one row, value 2" option. It's a while back I made...

Good question, Ron.

I seriously hope that nobody ever uses the ODBC date functions in real code, since (as tommyh mentions) they all have T-SQL counterparts.

James Goodwin (6/3/2010)

---

I think there are...

Good question. (Although I hate the ALL CAPS in the code).

The QUOTED_IDENTIFIER option is a rather odd one. Frankly, I am surprised that it's not deprecated, as its only use...

Webrunner, what you ask for is already available:

Above the percentages for the individual options is this:

With hindsight, I could have and should have worked it out by hand. But as you said - the horizontal...

I agree with others that the second sentence of the question: "Please guess error message for those stements which are wrong. (select all that apply)" gave the impression that we...

What you are missing is...

da-zero (5/27/2010)

---

I do not fully understand.

The batch begins with:

SET IMPLICIT_TRANSACTIONS OFF

According to BOL, this means the following:

... SET IMPLICIT_TRANSACTIONS OFF statement, which returns the connection to autocommit mode. In autocommit...

That is entirely correct. Of course,...