I have to disagree with the comments so far. I do not consider this a very good question.

The processing order as described in the correct answer is the logical order...

Whoa! I returned to the computer after a few hours absence to find my mailbox almost overflowing with message notifications!

I won't respond to all comments individually. I read a lot...

satya11001-1013569 (5/5/2010)

---

I have a doubt regarding the logical order of rows for Clustered Index.

Main difference between Clustered and Non-Clustered is Clustered is physical arrangement of rows and Non-Clustered is logical...

Paul White NZ (5/4/2010)

---

Hugo Kornelis (5/4/2010)

---

Here is another repro that runs fine on all clients, to demonstrate that SQL Server itself actually does not have any issues with this code:

--...

Good observation, Christian. The format of the error message, which looks quite different...

Paul White NZ (5/3/2010)

---

:w00t: ...

Scott Duncan-251680 (5/2/2010)

---

Good question but just raises another for me - when would you use NULLIF? It may be useful, but I am struggling to see where you would...

A tail-log backup is a backup you make of the active transaction log before starting an emergency repair. Withouut it, you will lose all the...

No. A full backup does not break the log chain.

Great question, reminding people of an often-misunderstood and very important fact.

One minor letdown (hey! Other people moan about my questions, I get to moan back;-)) is the ambiguity in the...

Sure!

Using SET IDENTITY_INSERT ON:

CREATE TABLE Demo1

(Id int NOT NULL IDENTITY,

...

stewartc-708166 (4/29/2010)

---

Hugo Kornelis (4/29/2010)

---

I got it right, because of elimination, but I don't understand the entire scenario.

Since the destination column is NVARCHAR(26), how can a value be outside the codepage...

I got it right, because of elimination, but I don't understand the entire scenario.

Since the destination column is NVARCHAR(26), how can a value be outside the codepage range? I though...

Hi Steve!

SQL Server include a number of encryption technologies, TDE, SSL and more. And unlike Oracle, which charges for encryption features, these are included in the price of SQL...

I don't know much about US law. In...