Yet Another DBA (8/23/2016)

---

Cool, so no down side in turning ansi_warnins off then? In fact by your suggestion it would even help the lazy developer who will not check for...

A datetime allows the time component to be 23:59:59.

Because the question asks for the maximum time stored by a datetime value and not a smalldatetime, I believe a change...

In India, we have a dedicated branch of engineering called "Information Technology" (IT), and I often ask the students what is the real meaning of IT. The unfortunate part is...

Thank-you! And again, it's a great question because it...

Here you go: "Writing Pages" - https://technet.microsoft.com/en-us/library/aa337560(v=sql.105).aspx

The...

Thank-you for the question! Made me revisit the documentation and refresh the concepts (Good!)

Really nice question!

Missed that we did not have a batch terminator after "BEGIN TRAN" and that we were dealing with nested transactions here.

Enjoyed the question thoroughly. Thank-you very much!

Our team did evaluate tSQLt framework for a data comparison project that we undertook a while ago. What we found was that tSQLt simply started to hang up for very...

Thank-you all very much for taking the time out to read my article and sharing your valuable views in the discussion!

Hugo Kornelis (6/24/2015)

---

The examples in this question are actually quite common. They...

I guess the explanation is quite simple:

Divide by 0 is not causing a problem in the SELECT clause because of the presence of EXISTS. You can have pretty much anything...

What am I missing here? The BOL page for CREATE INDEX [url=https://msdn.microsoft.com/en-us/library/ms188783.aspx]https://msdn.microsoft.com/en-us/library/ms188783.aspx[/url] clearly mentions that:

The answer should be yes.

Can the author come up with an example where the answer is actually "No"? Also, it would be great to clarify whether the output file is...

I see your point now. "Sport-100 Helmet" is actually > "Sport" and hence fails the check for <= "Sport".

Thank-you for the quick response!

Easy one.

What's interesting is that 32767 is the upper limit for SMALLINT (2-byte/16-bit integers). Yet, the database identifier has a data-type of INT, not SMALLINT. I guess that's it...