Toreador (5/15/2014)

---

Whatever the truth about the trace flags, I disagree with the answer.

In my opinion, the best way to test the behaviour of a particular database version is on a...

sknox (5/15/2014)

---

Setting aside the trace flag issue (I don't blame the question writer for Microsoft's inability to write proper documentation) the only problem I have with this question is the...

Interesting question.

Not sure whether the correct answer is actually correct. The following MS documents all state either that Trace Flag 9841 forces use of the old CE...

Interesting question. This is a feature I haven't yet used, so I had to do some reading, so it was useful for me.

At first I found myself wondering what...

Ed Wagner (5/12/2014)

---

Sean Lange (5/12/2014)

---

Lynn Pettis (5/12/2014)

---

Sean Lange (5/12/2014)

---

Ed Wagner (5/12/2014)

---

It sure is nice to hear that others remember the old "alt codes". I remember being able to change...

SQLRNNR (5/12/2014)

---

paul.knibbs (5/12/2014)

---

SQLRNNR (5/12/2014)

That would be nice, but using the unicode value or even searching in advanced mode (for both the unicode value and the symbol itself) in charmap shows...

Sean Lange (5/12/2014)

---

paul.knibbs (5/12/2014)

---

You can always use good ol' Character Map that ships with Windows to grab the symbol--bit of a pain, but it works well enough. Main issue is...

As the question specifically refers to...

Glass

Good straightforward question.

One minor niggle: using datetime instead of datetime2 (0 isn't a valid datetime2 value) and this is said to be in SQL Server 2012. I would hope that...

Nice fun question. 76% correct so far, which means people have found it easier than most QOTD. Perhaps it would have been even easier with a different code...

Martini

Carlo Romagnano (5/8/2014)

---

TomThomson (5/8/2014)

---

naas2005 (5/8/2014)

---

Just a note on the tinyint - to store negatives in one byte the rightmost bit of the byte (111111 0) would need to be used...

pestle

If you go for a single table, the coding of queries will be easier; but it may be slower rather than faster, depending on what the queries do and how...