sjimmo (5/12/2010)

---

Hugo,

Mine has been more in the rowlock, nolock and tablock hints. I have had cases where the optimizer determined that the tablock was more effective than a rowlock and...

sjimmo (5/12/2010)

---

Unfortunately, many think that a hint is law, and have spent many hours debating hints, as well as showing hints that work and then not work because the optimizeer...

sjimmo (5/12/2010)

---

It slips me right this moment which hint it is, but for the scenario you describe, there is a hint that can be used in order to have the...

Parameter sniffing.

Basically, SQL Server has three ways to deal with constant values in a query:

a) If it's a constant...

rVadim (5/11/2010)

---

I'm a bit confused. Several of you suggested using "fully qualified names". But this usually refers to using all 4 parts: Server.Database.Schema.Object.

Is that what you suggest we should use...

Thanks, Steve. Nice question to remind of us one more reason (hah! as if we'd need one!) to always fully qualify our object names.

Small mistake in the explanation - is...

Hi Paul,

Good question!

Thinking about it made...

Paul White NZ (5/7/2010)

---

Me either 😉 However, I think there...

CirquedeSQLeil (5/7/2010)

---

Paul White NZ (5/7/2010)

---

CirquedeSQLeil (5/6/2010)

---

Though I got this correct, it appears there is a typo in the correct answer. My version had the last two flip-flopped based on...

dunnjoe (5/7/2010)

---

I believe this explanation is incorrect for the way the question was asked. Your question asked if the rows were physically or logically ordered, not if the pages were...

Tom Brown (5/7/2010)

---

I attach my test script, where I was attempting to confirm the validity of my 10-year-old slip of paper, by looking at actual execution plans, and matching...

What if it's only there to...

Jan Van der Eecken (5/7/2010)

---

Paul White NZ (5/6/2010)

---

On the physical ordering thing, I would just add that individual rows on the page may not be in physical clustered index either...

Toreador (5/7/2010)

---

If you never use the identity column in queries but only use it as a primary key then doesn't it actually make...

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