Can't really say anything positive about a question which relies on regional settings for correct answer, and which doesn't really promulgate any useful knowledge. Why would I want to do...

In Sweden, the legal minimum is 25 days of fully paid vacation, but many have 30 or more paid days off. All countries in the European Union have at least...

More tsk, tsk.

There, now I've got the two points.:hehe:

Tsk, tsk.

Mighty (1/7/2015)

---

In relation to this, I don't fully agree. For me...

Not fond of this question.

COUNT(*) counts NULL:s, but COUNT(<expression>) doesn't.

select count(*), count(a)

from (values (1), (NULL)) x(a)

And GROUPING most certainly considers NULL:s.

Since the...

Well, if you don't like any of the available clients API:s, or if you're implementing SQL Server support on a new platform, you're going to have to know this very...

Quite frankly: If you think you have to know this, you're very likely doing something wrong. Still, I've earned yet another very arcane bragging point.:hehe:

I'm currently hiring. I'd like to know which 9% selected the CHTM option:hehe:

I think the only thing I take away from this question is confirmation that dynamic SQL must be avoided, but if you need it you should at least name your...

Interesting question. Too bad none of the answers are correct. BI edition does not support buffer pool extension.

Oh, and your reference link doesn't work.

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

If SOUNDEX() as implemented in SQL Server was remotely useful outside of English-speaking countries I might care one way or the other. As it stands it's one of the quaint...

Ford Fairlane (11/7/2013)

---

Very good question - got caught out with as well. Should have realized that with out the where clause that each max() is evaluated individually... nice to learn...

Well, good question, but the correct alternative was a bit misleading. You don't get a zero back, you get an empty result set. That's a different answer.