I tried just a little. The answer is as usual "depends".

If you query...

Now, I want to try!

😀

DataTherapist (2/23/2015)

---

I don't understand why the 'physically stored' options is not considered one of the right answers.

What's the fine details here that I'm missing?

A clustered columnstore index is regulating how...

Interesting, I just learned about them last two weeks.

😀

Koen Verbeeck (2/20/2015)

---

Carlo Romagnano (2/20/2015)

---

ADD [ COUNTER ] SIGNATURE TO module_class::module_name

BY <crypto_list> [ ,...n ]

<crypto_list> ::=

CERTIFICATE cert_name

|...

ADD [ COUNTER ] SIGNATURE TO module_class::module_name

BY <crypto_list> [ ,...n ]

<crypto_list> ::=

CERTIFICATE cert_name

| CERTIFICATE cert_name [ WITH...

Very nice!

😀

pmadhavapeddi22 (2/11/2015)

---

I have checked the rows in sys.syscacheobjects before/after running the selects, found 5 new rows with all the selects mentioned in QOD.

select * from sys.syscacheobjects where objtype ='adhoc' and...

Sean Lange (1/27/2015)

---

Carlo Romagnano (1/27/2015)

---

Strange, but the version with PIVOT is a bit slower than that with GROUP BY. See execution plan!

with c

as(

SELECT * FROM (VALUES

(1,2013,1,100)

,(1,2013,1,200)

,(1,2014,0,500)

,(1,2014,1,200)

,(2,2013,1,200)

,(2,2013,1,200)

,(2,2014,1,100)

,(2,2014,1,100)

) AS V([Customer],[Salesyear],[Complete],[Amount])

)

SELECT

...

Raghavendra Mudugal (1/27/2015)

---

actually I was doing the same thing on...

Strange, but the version with PIVOT is a bit slower than that with GROUP BY. See execution plan!

with c

as(

SELECT * FROM (VALUES

(1,2013,1,100)

,(1,2013,1,200)

,(1,2014,0,500)

,(1,2014,1,200)

,(2,2013,1,200)

,(2,2013,1,200)

,(2,2014,1,100)

,(2,2014,1,100)

) AS V([Customer],[Salesyear],[Complete],[Amount])

)

SELECT

*

FROM...

Extremely easy!

Why do people get it wrong?

I expected 100% of correct answers!

😀

Hugo Kornelis (1/22/2015)

---

Carlo Romagnano (1/22/2015)

---

Hugo Kornelis (1/22/2015)

---

Not too thrilled with this question. Lots of work and thinking for a feature that should have been deprecated and removed twenty years ago....

Hugo Kornelis (1/22/2015)

---

Not too thrilled with this question. Lots of work and thinking for a feature that should have been deprecated and removed twenty years ago. Or failing that, should...

rmechaber (1/21/2015)

---

Nice question, thank you.

Some additional explanation from BOL (https://msdn.microsoft.com/en-us/library/ms175523%28v=sql.105%29.aspx):

If a run-time statement error (such as a constraint violation) occurs in a batch, the default behavior in the...