That's odd. 800MHz sounds awfully fishy though, you probably want...

There should be text at the end of the Specification line that shows the spec speed; something...

What does CPU-Z show the speed should be,...

Any chance your new server has power saving CPUs installed?

http://www.brentozar.com/archive/2010/10/sql-server-on-powersaving-cpus-not-so-fast/

Here's some info on generating the actual execution plan when running a query from SSMS: http://msdn.microsoft.com/en-us/library/ms189562.aspx. Once the plan has been generated, you can right click in the plan window...

It's going to depend on a few factors, such as the depth of your hierarchies, your indexes, and so forth. Can you post the actual execution plan for the long...

I suspect SQLRNNR was hoping for the Actual Execution Plan rather than the Estimated Execution Plan. One shows what SQL Server "thinks" will happen when the query...

Well...possibly. But if the requirement is just to join aggregated data to rows in another table, I don't know that CROSS...

That might work ok, but be careful. Since the original field was NTEXT, it may contain Unicode characters that would be lost on conversion to VARCHAR; you're probably better off...

You're welcome! Glad it worked for you!

dan.k.williams (11/21/2011)

---

Yes I think that will work, I just had to insert the rest of the columns into your new subselect and group by statement for SRC, so that they...

Use a derived table to return the results of the aggregate, then join that to your secondary table:

SELECT *

FROM ( -- The results of the aggregation create the derived table...

Something like:

USING (

SELECT Xclaimflag_id, MIN(warehoused) AS warehoused

FROM X.dbo.tbl_Xclaimflag

GROUP BY Xclaimflag_id

)AS SRC ON (SRC.Xclaimflag_id = DST.Xclaimflag_id AND SRC.warehoused = DST.warehoused)

(Assuming that "warehoused" is the name of the...

dan.k.williams (11/21/2011)

---

One more bit of information, there are duplicate flagID's, with different warehoused dates. Where would I insert the where or having statement to pull the earliest warehoused date?

I think...

There is at least one situation where the criteria defined in your MERGE and MATCHED statements result in more than one row from SRC being used to update a single...