This is a very good question, thank you. I answered it correctly, but only because I knew that neither option 1 nor 3 is correct. This only left option 2...

CirquedeSQLeil (5/14/2010)

---

john.arnott (5/14/2010)

---

This was a good way to point out the risk of using reserved words within brackets as a user-defined object. While I would suppose few people...

Nice question, thank you. It would be nice though if the database engine team would limit some of the square brackets allowances and throw sev 20 error. Something like:

Msg 8421,...

Yes, the old script you mention has...

This is a very good question, thank you Steve.

Fully qualified objects names is a must, not subjected to any second guessing. This is a very pathetic scenario when due to...

This is a very good question, thank you Tom. Today I am the lucky one to be first who answered it correctly. It was not too difficult to deduce correct...

Both the question and explanation are excellent, thank you Hugo.

I think that the options about logical/physical order will generate a very good discussion. This is because the Create Index page...

Very good question, thank you. I...

Very good question, thank you Paul.

It is interesting to see how perfectly sql_variant_property handles the literals. For example, 3 billion can be represented as bigint or as decimal(10, 0), and...

Cool question! Thank you. I think that nullif is one of the useful functions which is somewhat overlooked by many.

Oleg

skjoldtc (4/29/2010)

---

No. I don't know why that is.

I now recall that the AS400 has a max CCSID (coded character set ID) of 65533. That makes sense since the original...

skjoldtc (4/29/2010)

---

65533 is a valid unicode number but represents a special replacement character. It is the highest value in the character set. dbowlin makes a good point about what...

skjoldtc (4/28/2010)

---

Good question. The difference between DATE and DATETIME in SQL Server 2008 is important. Thanks.

The answer 40147 looked familiar to me. It is what I have known to...

Good question, thank you. I answered correctly because I already tried it some time ago when I first learned about the new data type just to check whether behavior of...

Jeff Moden (4/24/2010)

---

I'd like to know why we're using SQL SDerver to format anything. This stuff should be done in a GUI if you have one and most reporting...