Perhaps because you aren't qualified to get your just rewards...

john.arnott (1/2/2013)

---

Hugo,

Just testing to see if we're reading carefully? 😉

Looks as though your option 2 is screwed up somehow, returning dates years off.

SELECT dateadd(month, datediff(month, getdate(), '20110101'), '20101231');

........

Rather irritating question, as it stands.

It would be a good question if it specified that the queries were run using SSMS with a default install and no user changes to...

That's quite a mess, isn't it!

The only correct answer is "none of the above", for two reasons:

1) none of the select statements is syntactically valid.

2) even when the missing parentheses...

Bliadhna mhath ùr dhan a h-uile threadizen.

Or, for those of you who speak the green version of the language,

Ath-bhliain faoi mhaise is faoi shona dhuibh.

And for the benighted Gaill amongst...

SQL Kiwi (12/30/2012)

---

There is a 2006 active Connect suggestion by Adam Machanic for a hint. Though some duplicates of that item have been closed as Won't Fix (= perhaps for...

I quite like this question. It make me wonder rather a lot. And dither.

In fact I dithered almost hopelessly on on this one. Should I pick a...

Nice easy question.

Not sure I like the wikipedia link - in general, wikipedia suffers from cranks editors and edit wars so that some pages are quite awful (I see less...

Sean Pearce (12/28/2012)

---

L' Eomot Inversé (12/28/2012)

---

OK, there is something one can do when deleting to ensure that empty pages are deallocated. However the options (if one isn't deleting every...

Jeff Moden (12/28/2012)

---

If you look at the execution plan, it doesn't actually use the "same list". CTEs have some wonderful advantages but they also have a hidden fault. ...

Nice easy question.

The explanation is a bit sparse though, as Koen said.

wolfkillj (12/28/2012)

---

Sadly, the energy content of a...

Hugo Kornelis (12/21/2012)

---

Hi Tom,

I don't know what happened when you wrote that - I have never seen that kind of language from you before! "intransigence" (had to look that word...

Melville

hake