"Due to the Holiday Season, and Frosty being a part of the season, an easy question was in order. "

It might be easy if you're American. Who's Frosty the Snowman?!?

:unsure:

Steve Jones - Editor (12/17/2009)

---

wow, you guys are really splitting hairs. A restart includes a shutdown and startup of the database instance. How could you argue it includes anything else?...

BOL says "a global temporary table is dropped at the completion of the last Transact-SQL statement that was actively referencing the table when the creating session ended".

I took this to...

Correct answer, but the explanation is completely wrong!

Easy for a VB6 programmer 🙂

If one of the options had been 1 or -1 or even 32767 I might have got it wrong though!

I guessed rigtht, but only because I knew it had to begin with 'Question' and there was only one answer that did that. If there'd been an option for 'Question...

"Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives."

I have no idea what this means, and the answer doesn't seem to mention it.

Can...

sknox (12/4/2009)

---

wrong,...

Ah, that old chestnut.

I've never been Prime Minister either, but I still get to say what I think...

Lynn Pettis (11/17/2009)

---

Yes, getdate() and getutcdate() return different values, just look at what they return when you run them. However both functions return values that are equivelent to each...

bitbucket-25253 (11/17/2009)

---

Lynn Pettis has explained in great detail the reason the times are the same, and as a matter of fact has explained the reasoning better than I could have....

If that is the reasoning then...

Thought about answering True, because for me (in the UK) they will return the same value, but figured that the author was probably in the US so the answer was...

Surely date formatting should normally be part of the presentation layer? I always return the whole datetime value and format it on the client, using their regional settings etc.

Thanks Hugo 🙂