Good question!  I have used collate in joins before.  It seems that this question isn't really about collation, but more about what the...

Thanks, Steve.  That makes more sense.

Thanks for the article.  I'm struggling to find a situation where I would actually choose CHOOSE. (See what I did there?)  I don't want to hard code values into CHOOSE....

They're not orphaned.  Orphaned users are in the database, but do not have a corresponding login associated with them.  You have the opposite.  These are server logins that have not...

My mistake. Sysusers actually represents logins, not users.  I haven't referenced that view in a long time.  Logins get created at the server level and users get created at the...

Yeah, you can't update system catalogs.  We haven't been able to do that since SQL 2000, I think.  Also, sys.sysusers is an old view that's only there for  backward compatibility. ...

I have to agree with edmil.  A hash bailout occurs when a hashing operation reaches its maximum recursion level and shifts to an alternative query plan to process the remaining...

From BOL:

Nested comments are supported. If the /* character pattern occurs anywhere within an existing comment, it is treated as the start of a nested comment and, therefore, requires a...

Archie,

You are correct. That was an over sight on my part. I didn't test it with SQL 2000. The question should have stated that this was for...

Hugo,

Thanks for the feedback. I agree that the explanation could be better, but through my research on the topic, I couldn't find an adequate explanation for this behavior. ...

Disregard my last post. I just realized that the SQL Server Express server is not in mixed mode, which probably accounts for the NULL.

Greg

I tried it on several of our servers, both 2005 and 2008, and received '1900-01-01 00:00:00.000'. All of these were enterprise edition. I also tried it on one...

Today is also the day that the Titanic sank and President Abraham Lincoln died.

Doh!! Someone beat me to it!

Great job, Craig! This is a great idea for a topic. One that isn't discussed often. I cannot count the number of horrendous job postings that I...

Yes, it was possible to move the resource database in SQL2005.

http://msdn.microsoft.com/en-us/library/ms345408%28v=SQL.90%29.aspx

Thanks,

Greg