"The damned recruiter gave the candidates both the questions and the answers.  I know this because I added a "hairball" question with a totally made up answer and when I...

"My opinion, a better approach is to ask "discussion" questions, not questions that you can get an answer to right away. So rather than asking "what are the different types...

• This reply was modified 1 year, 3 months ago by  David Moutray.

Fair enough.  There are certainly enough worthless lists of interview questions on the internet.  After much labor, I came up with a list of screening questions that I felt met...

I would be happy to review any articles on any SQL Server topic.

Well, you could also load their database into a DB source control system like Redgate's SQL Source Control or MS Visual Studio SSDT.  Maintain this as a project, and then...

There is one additional fact about our environment that is significant, but I did not realize that it was significant.  We use aliases for our SQL Servers (via DNS CNames). ...

Additional note:
I enabled Kerberos Logging on SQL Server 1, and received KDC_ERR_BADOPTION errors when I tried to connect to the linked server, which indicates that it is definitely a...

You can do this using triggers.  As I mentioned in an earlier reply, I prefer to avoid triggers where possible for a number of reasons.  (See the previous reply.)

A transaction commit will not drop a temp table.  Technically, a rollback doesn't either.  It just "undoes" the create. 🙂
A temp table is only dropped when the database session...

I think you all are right - I need to change the design.  I really did not want a single table, since the tags are just free-form text and they...

Classic article, Jeff. I have loved it (and used it extensively) since it first came out five years ago (and the discussion is still going strong!)

With SQL 2016 just...