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...

Koen Verbeeck (1/20/2015)

---

Maybe the test script should have created a table with an identity column of numeric(38,0), instead of numeric(17,0).

Hence, the "correct" answer is incorrect.

(I though I was losing my...

TomThomson (1/19/2015)

---

Nice question.

But I don't like the last sentence of the explanation

Transaction started by "BEGIN TRAN" may end prematurely and unexpected by some errors that may ROLLBACK transaction....

That's true!

The question is "select six TRUE answer". It's "implicit".

🙂

From BOL:

Implicit transactions may unexpectedly be...