Stream Aggregate is a physical, but not a logical operator. Hence it is not the correct answer.

Okay, I am going to contest this one. I know that Books Online says that "Aggregate" can be "a logical operator or a physical operator". But who has ever seen...

I wondered about that myself, when I saw the two sets of three mutually exclusive options each.

Previously, I have submitted questions with...

No. It would change the meaning of the queries. As posted, they implement "give me the department ID for Human Resource...

Koen Verbeeck (5/21/2015)

---

Confusing. I use segment elimination to indicate that a segment of rows has been eliminated, not necessarily an entire column.

But I guess that if you eliminate all segments...

g.britton (5/20/2015)

---

Great question! It illustrates the benefits and dangers of using unaliased column names in queries. IIRC SQL looks in the current namespace for a match on the...

briankwartler (5/19/2015)

---

I note from Hugo's article that if a string (char, varchar, nchar, nvarchar) is part of the columnstore index, then filtering on that column does not result in segment...

It actually does (and I should have included it in my article).

Some references:

http://byobi.com/blog/2012/10/column%C2%AD-stores-for-wide-and-sparse-data/%5B/url%5D. (A blog I found when searching the internet for...

Hi Steve,

As the author of the article referenced in the explanation, I am very sure that the answer I ticked is correct, and that the answer you marked as correct...

No. This is abuse. You *****.

No, the default parameter of LAG and LEAD is...

dale_berta (5/14/2015)

---

Interestingly enough, the documentation on CREATE PROCEDURE don't say anywhere, that I could find, that it had to be the the only statement in the batch. The links provided...

Toreador (5/14/2015)

---

I guessed that it wouldn't execute the procedure ion the 2nd batch, as the parser would detect the recursion and stop it. This seemed to be confirmed when I...

Aaarggh! I apparently need more coffee.

I somehow managed to convince myself that the text said "choose 2". And then saw 4 correct answers, so I was very annoyed at the...

From head (no time to check the details now), I believe that the ANSI standard allows...