Yes please attach both versions. It's much easier that way.

Always hth!

Wait!, that looks odd. Usually all the coming articles are listed, but not clickable.

I've pinged in Steve to tell you what's going on with this one.

All the stairways will be completed at some point. It's just that not all articles have been published (or even submitted) yet.

HTH & thanks for the feedback.

Please post the actual execution plan for both versions.

Those settings have been tested multiple times (read the whole thread).

Let me know if you still need more help after this.

http://www.sqlservercentral.com/Forums/Topic982618-391-1.aspx

So you need a detached database for a vendor on the road or something like that?

If not, you can always do an access data project (adp). That connects directly...

1 lack = 100K.

So 1M here.

Is this theorical only?

Or do you have a task that you need to accomplish?

Loops in sql are very very rarely used outside of server administration work.

SQLRNNR (11/11/2011)

---

Very odd. When you updated stats, did you do it with fullscan? (Saw recently that a stat update with fullscan caused a query to run slower - just...

Please upload the actual execution plan.

Dev (11/12/2011)

---

It's time to pay money 😉

667 -- Trial...

Tx for the consumable data!

BEGIN TRAN

IF OBJECT_ID('TempDB..#MyTempTable','U') IS NOT NULL

DROP TABLE #MyTempTable

create table #MyTempTable

(

SetID int

, SubSetID int

, TextMessage varchar(100)

--Please note how...

HTH 😉