Scarily, this reminds me of several job interviews I've had!

Thanks for this. I wouldn't have realised that ROLLBACK would roll back a comitted transaction - doesn't this have ACID implications?

No, this strip isn't racist - it's making fun of racism!

Perhaps if they offered a discount for SQL Server Central readers? 😀

So would it be fair to say that the third argument of ROUND, function, actually ensures you round down instead of up, if you set it to a non zero...

A very useful view - added to my list to check after upgrading.

Are these all things that will be removed in the very next version of SQL Server, or two...

Although you may not need a one-to-one match for TempDB files and CPU cores, if you do think TempDB is causing a bottleneck, I'd certainly recommend increasing the number of...

Yet another example of NULL causing unexpected results in a query!

(I would say we should stop using NULL but I know we're not supposed to suggest that ;-))

The lesson is,...

Can people please start posting these trick questions - SQL Server is a big enough topic that people can find plenty of real questions 😉

I agree - no more typos - this woudl have been a good question with correct syntax, becasue the presence of -1 as one of the insert values would still...

I think this is an example of why people don't like to use OVER, since it's so hard to work out what might/will be returned!

I'd like to see a simpler...

I think the only danger with having someone who is solely a DBA is that people think their job is to look after the SQL Server side of things only...

A quick search on Microsft's website:

http://msdn.microsoft.com/en-us/library/ms175049.aspx

This clearly gives 8, which wasbn't even an option!

Not my favourite question, although it did make me think a bit more about indexes...

I managed to work out what all the date functions were doing, but was caught out by the select @hourDiff = @min-2 / 60. Since @hourDiff was defined...

Thanks for the Q - I must admit I hadn't considxered this