If possible, one thing that may help is to do the sorting in the application.

Creating an index on the view sounds like it will probably be your best bet, but...

Except of course for Democrat primary voters in MI and FL. :hehe:

Shaun McGuile (4/4/2008)

---

Aleksandr Furman:

How is that funny?

Is that not the truth? 😉

Like the one told to me by an accountant;

"There are three types of accountant in this world, those...

Ridiculously late addendum, but Cute-PDF is free and has worked wonderfully for me so far, at least with things that are properly formatted for printing, it chokes a bit on...

Jeff Moden (3/31/2008)

---

On the "Persists" disadvantage, I kinda of agree if the sproc is big and the Temp table is used only at the beginning. I just want everyone...

If only the fact that my hands weren't on the keyboard wouldn't give me away...

Daniel Wilson (5/22/2007)

---

thanks for the intro to CTE's! I know I've written the same SELECT statement into 2 parts of a query before. No more ... ah ......

I'm having a hard time grasping the significance and nature of cost. Would it be accurate to say that the cost is representative of the extent to which it...

I did three runs in one order, and two runs with...

69.5% of the total batch cost for the derived table method according to the execution plan, but only 31.8% of the runtime (according to the getdate() queries I inserted at...

Jeff Moden (3/18/2008)

---

If the underlying tables are correctly indexed, the CTE or Derived Table will use it... creation of the index on the temp table may take longer than...

I'll stick to indexed temp tables for self-links then. (The base table used in this process has around 300k rows)

Is it possible to put an index on the CTE? I ask because we're moving to SQL Server 2005 in 4Q 08, and I have more than a few...

Are you saying that...

sjsubscribe (3/10/2008)

---

Well, good advice if you're dealing with one server and single schemas or need to optimize for in specific instances. But if you're writing procedures that need to run...