Hugo Kornelis (10/8/2012)

---

However, much more important - your statement is incorrect. SSMS does not use the server defaults. If you run a profiler or XEvents trace while working in SSMS,...

kent_secher (10/8/2012)

---

I think the question is not very good, since the correct answer can be deduced without knowledge of indexed views. The successful creation of this unique index would depend...

Hugo Kornelis (10/8/2012)

---

I really liked the question. Unlike Tom, I even liked the inclusion of all the settings, and I don't think it's a red herring. This question is about...

It's a question with a correct answer, no scope for argument for that (as I have come to expect from Ron's questions, which seem to be always accurate - unlike...

Sean Lange (10/4/2012)

---

And something...

Hugo Kornelis (10/5/2012)

---

It wasn't intended as a lecture. It was just me letting off steam after seeing too many messages (not only in this topic, many topics have the same...

Which just demonstrates that most people don't understand how the...

Lokesh Vij (10/4/2012)

---

sam.dahl (10/4/2012)

---

I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that...

mental caries?

Abby

your notation is rather strange, I can't follow it, so I can't see what's giving an error.

However, your text seems to indicate what you are trying to do and it...

bitbucket-25253 (10/4/2012)

---

L' Eomot Inversé

Note in all of the following the bolding of parts of the explanation has been done by myself.

...

...

...

As for running my own tests, if I did do...

Eugene Elutin (10/4/2012)

---

Yes, you are right! There is no one-size-fits-all answer to that.

However...

I guess it was some long discussions between SQL Server (and back to old days Sybase) design engineers/architects...

Eugene Elutin (10/4/2012)

---

Yes, you are right! There is no one-size-fits-all answer to that.

However...

I guess it was some long discussions between SQL Server (and back to old days Sybase) design engineers/architects...

First, I assume Pais_iD is a typo, since in the foreign key declaration it appears to be called Country_iD.

Second, you can certainly create a nonclustered index on Country_iD in the...

PiMané (10/4/2012)

---

Regarding Dynamic SQL....

Instead of a SELECT suppose I have an UPDATE used on a SP.

The SP receives 6 parameters: @RecordId, @Col1Value, @Col2Update, @Col2Value, @Col3Update, @Col3Value...

Col1 is always updated but...