I was thinking that DDL triggers can be digitally signed so I have done the wrong choice.

After 10 minutes of search , I found this link :

which is explaing that...

As Tom Thomson wrote , it was easy to find the 2 good choices after the question of 02/23/2015.

Moreover , I was helped by 2 sessions about Columnstore indexes during...

The most important problem with security breaches is as too often , the companies in which personal data ( credit card , phone number , ...) have been stolen are...

Maybe the question has been understood badly by the previous posters.

I read "You had a problem with SQL Server and needed to restart the instance. After the restart, you want...

Mike C (7/29/2008)

---

MarkusB (7/29/2008)

---

Don't wanna be too picky but from the answer:

The “//*” XQuery path matches every element node in the XML document, so (b) is also incorrect.

And I thought...

nihie (3/10/2015)

---

b) and f) are correct answer, as records from child is removed before parent. It is not mentioned any where that logging is required, and in production environment...

I was sure that the two last choices were not existing.

I have never seen anything about the 2nd choice.

So , I have only one choice to be kept and it...

Mike C (5/21/2007)

---

<FONT color=#111111>Actually the question is <EM>"How can you get the <STRONG>number </STRONG>of columns involved in any constraint of any table in SQL Server 2005?"</EM> None of the answers...

Excellent question and the 3 links you provided to explain the "good answer" were ( maybe ) the best ones.

It was easy for me to answer as I am studying...

Short ( maybe too short ) editorial which has the advantage to question about the upgrade or refresh.

I gave only a good notation because of the lack of proposals...

Thanks for this good question.

I found the good choices only because I have "spied" a debate during the last Paris SQL Server Staturdays 2014 about this kind of topic.

When...

I would suggest you to have a look at this link

For the release of the CU5 for SQL Server 2012 SP2 , the release date ( according the same post...

Why the b) choice ( truncate BBB , delete AAA ) is not correct ?

It seems for me that as soon as there is no more rows in the...

Easy question . The choices 3 and 4 were rejected as too far and with the meaning of ceiling it was evident that the good answer was 54 ( not...

In https://msdn.microsoft.com/en-us/library/ms191154(v=sql.90).aspx , it seems that 1 minute is an acceptable value as it is explained in the BOL ( the in practice explanation is more useful than the...