Ah yes, a SQL Server veteran. Burned by experience, conditioned to expect the...

bitbucket-25253 (4/24/2012)

---

I am some what confused and perplexed for when I run

(in Denalli CTP3)

SELECT name, start_value FROM sys.sequences;

the return values are:

name ...

Excellent question. On a new feature, minimum code to make your point, clear cut answer, and several issues demonstrated at once. Bravo! (and Thanks!)

I think if you give it some...

Nice question. Missed it as I mistakenly used the BOL entry for 2012. Went straight for HTTP SOAP as the incorrect answer. Doh! At least I learned something, which is...

As soon as I saw the question, I realized it must be Wednesday. No easy Monday question that. Koen, thanks for the question. Keep them coming.

Great question. Simple (with a single look at BOL), clear cut, a bit surprising, and on a new version. Thanks!

Thank you for the question. I thought the question was straightforward, but then it's Monday.

Sean Lange (4/13/2012)

---

Of course.

;with TopTest (SomeValue)

as (

select null union all

select null union all

select null union all

select 4 union all

select 4 union all

select 6 union all

select 7

)

select Top 2 with ties...

Nice question. As others have said, I don't use the with ties much, but it was good to have to study it a bit. Thanks for the effort! At least...

Thanks for giving me a reason to do some digging this morning. Learned a lot.

But, it's hard to concentrate, as I'm waiting for Steve to hit 30,000 points -...

Thanks for a straight-forward question. Although, in mid-week, I kind of miss the arguments, er discussion. 😉

bitbucket-25253 (4/10/2012)

---

Not as easy as I thought it would be:

Since one of the major objectives of the QOD is...

Thanks for the question. Always good to learn a little something new, even on what is now a Monday. Keep it coming.

Igor, thanks for the question. Made me think. Maybe it was easier for me, as I answered the question in my head, before being presented with the three possible answers....

Thanks Steve! We currently code for locations in one time zone, so we don't use these types of things much. However, we recently became part of a global enterprise and...