David Day (3/18/2016)

---

Then (with all due respect) the questions either need to indicate the version, or have version-specific options. Given the mess the latter would become, the former would...

I was confused by the transaction logs being "from midnight on". What is that relative to? :angry:

david.dilworth (2/5/2016)

---

I had to look that function up as I hadn't seen it before.

Is anyone able to provide a real-world example demonstrating the usage? What I'm interested to know...

I spent way to long on this one looking for the data type precedence catch. :crazy:

Interesting, thanks for the question Andy!

Andy Warren (12/1/2015)

---

Shane, that question made my eyes hurt!

Hugo, that answer is why I love reading the QOTD, the follow on discussion is always worth reading. But I only see...

Dain Bramage (12/1/2015)

---

THANKS for an EXCELLENT QOD. This is one of the best I have seen on this site for 3 reasons.

1. The question was asked in such a...

Thank you for the very interesting background behind the square bracket delimiter in SQL Server, Hugo. I had always assumed it was a more arbitrary decision on Microsoft's part....

I like to add square brackets around my nested schemas. :-D:crazy::hehe:

CREATE SCHEMA [[a]].].[c]]]

Luis Cazares (11/18/2015)

---

Carlo Romagnano (11/18/2015)

---

I disagree, naming conventions should reflect the factory needs. So, it may be that [Sales.XXX] is good...

Huh, I wasn't expecting to learn something about sports today. :crazy::-D

Has anyone mentioned that the 'correct' answer is wrong yet? :hehe:

GeorgeCopeland (9/30/2015)

---

In this case, there's not much difference. If however you...

Transaction log...

Would this count as a third?

SELECT * FROM (SELECT...