+ 1. I don't see how an ORDER BY clause can possibly...

I've never heard of such a thing, but am incredibly curious to see it. Please post the DDL and query you're using.

Jeff Moden (10/2/2014)

---

Heh... have you done an actual test to see which is better? You have to remember that even supposed "actual" excution plans are estimates in many ways.

Execution...

I'd like to see annual SP releases as well, but that has not been the case. Call me old-fashioned, but I always get nervous when applying patches of any...

Bass

Muscle

Thanks for a a good question. I also use instead of print to avoid the delay associated with print, especially when debugging. I find the core functionality to...

Saw

Eirikur Eiriksson (10/1/2014)

---

Nothing much, QoDs been controversial, SQL Server will become Hadoop only,...

crookj (10/1/2014)

---

Ed Wagner (10/1/2014)

---

Revenant (10/1/2014)

---

Ed Wagner (10/1/2014)

---

djj (10/1/2014)

---

Ed Wagner (10/1/2014)

---

crookj (10/1/2014)

---

Ed Wagner (10/1/2014)

---

TomThomson (10/1/2014)

---

Ed Wagner (10/1/2014)

---

SQLRNNR (9/30/2014)

---

crookj (9/30/2014)

---

Ed Wagner (9/30/2014)

---

djj (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Ed Wagner (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Revenant (9/30/2014)

---

Ed Wagner (9/30/2014)

---

crookj (9/30/2014)

---

Stuart Davies...

Congratulations, Jason. Good work.

Revenant (10/1/2014)

---

Ed Wagner (10/1/2014)

---

djj (10/1/2014)

---

Ed Wagner (10/1/2014)

---

crookj (10/1/2014)

---

Ed Wagner (10/1/2014)

---

TomThomson (10/1/2014)

---

Ed Wagner (10/1/2014)

---

SQLRNNR (9/30/2014)

---

crookj (9/30/2014)

---

Ed Wagner (9/30/2014)

---

djj (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Ed Wagner (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Revenant (9/30/2014)

---

Ed Wagner (9/30/2014)

---

crookj (9/30/2014)

---

Stuart Davies (9/30/2014)

---

crookj (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Ed...

djj (10/1/2014)

---

Ed Wagner (10/1/2014)

---

crookj (10/1/2014)

---

Ed Wagner (10/1/2014)

---

TomThomson (10/1/2014)

---

Ed Wagner (10/1/2014)

---

SQLRNNR (9/30/2014)

---

crookj (9/30/2014)

---

Ed Wagner (9/30/2014)

---

djj (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Ed Wagner (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Revenant (9/30/2014)

---

Ed Wagner (9/30/2014)

---

crookj (9/30/2014)

---

Stuart Davies (9/30/2014)

---

crookj (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Ed Wagner (9/30/2014)

---

Stuart Davies...

crookj (10/1/2014)

---

Ed Wagner (10/1/2014)

---

TomThomson (10/1/2014)

---

Ed Wagner (10/1/2014)

---

SQLRNNR (9/30/2014)

---

crookj (9/30/2014)

---

Ed Wagner (9/30/2014)

---

djj (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Ed Wagner (9/30/2014)

---

SQLRNNR (9/30/2014)

---

Revenant (9/30/2014)

---

Ed Wagner (9/30/2014)

---

crookj (9/30/2014)

---

Stuart Davies (9/30/2014)

---

Rin Tin...

TomThomson (10/1/2014)

---

Ed Wagner (10/1/2014)

---

SQLRNNR (9/30/2014)

---

crookj (9/30/2014)

---

Fickle Finger...