Got me. Just skimmed the code and chose the obvious answer (and was wrong!).

Not necessarily a trick question, more an object lesson in reading the code properly.

How about a site offering psychiatric assistance to overwrought Database Administrators... a nice comfy couch, perhaps even a photo of Kelsey Grammer (or even better Sideshow Bob), soothing sounds of...

Had a play around as well, and this runs on a Central Management Server across multiple SQL boxes with multiple builds (2000, 2005 & 2008).

USE MASTER

GO

BEGIN

IF LEFT(CAST(Serverproperty('ProductVersion') AS VARCHAR(1)),1) =...

Great question... I was another victim, but I learned something new here today, which hopefully I'll remember 🙂

Or did you... Perhaps we let you believe that, but still secretly maintain control... :alien:

Here you go...

http://www.worldwidewords.org/qa/qa-tea1.htm

It does look odd, but its meaning is clear enough: don’t give needless assistance or presume to offer advice to an expert. As that prolific author, Anon,...

Don't tell me you've never heard the phrase?

In the UK (maybe only in the North, I'm not sure) we have a saying when someone is telling you something you already...

i am not necessarily talking about technology, but about new enviroment, new DB, new people 🙂 etc.

What you have done on your first day, second day, third day .......

Never was a truer word spoken....

Then there is reality...You walk on the job that asked for Java, Oracle, SQL, Postgrest, ASP.NET ( Must have 5 years of the last technology that was recently released 6...

Just to throw a spanner in the works, from personal experience, a lot of this goes out of the window when working on something like a NetApp Filer, where shelves...

Made me smile, as where I am currently freelancing this would...

When I first started as a "programmer" we used to hand write COBOL onto coding sheets, and debug the code by the simple method of writing test data down on...

I'd go along with Jason's thoughts here. Look...

I thought this was not true for the mere point that a table does not have to have a clustered index - meaning that some nonclustered indexes only have the...