Lol! We can get our databases down to just one "Thing" table with two columns. Awesome.

Of course, come to think of it, we may laugh at today, but...

Really enjoyed the article. I think however, we all know the best way to name table aliases and variables: After ex girlfriends and cartoon characters. 😉

You've stopped and restarted the SQL Server?

It's funny and everything to use the phrase "baaad developer", but the problem is, I have to edit the article to show it to the developers.  I'm not sure this...

A schema is just the structure of the database or database object;  that is, the T-SQL.  It's been discussed here as if it's some ethereal notion or pie in the...

And note that it it still gets truncated if you increase QA's results limit to 8192 (instead of 256).

I kept waiting for the COASLESCE function in this article!  Where is it, lol?

"Bad" commenting is the least of my worries.  Holy cow..  I'm trying to get these people to comment at all!  I'm darned sure not going to complain about how they...

You know, it's not world hunger or anything, but why can't you have 3 wrong answers, and 1 right answer on the questions, instead of 2 wrong answers, 1 that...

There's no such word as "virii". It's "viruses".

Why have a primary key on every table? Because Dr. Codd said so. I just have my developers read some Codd or Date and they don't bug me...

Though I "got this question right", I completely agree that clearer wording would be nice, eg, "Above what memory point..."

The answer appears to be incorrect.

In one connection, do this:

----------------------------------------

alter database northwind

set single_user

with rollback after 30 seconds

----------------------------------------

In another...

How about a SELEDELETUPSERTIFCASEDBCCBAKRESTORE statement that does everything at once? You can just run a SELEDELETUPSERTIFCASEDBCCBAKRESTORE and be out of the office by 9:30.