Martin Schoombee (5/4/2015)

---

Pretty far behind on service packs.

As Eirikur suggested and you've confirmed, AWE should be enabled. You should also ensure that the "Lock Pages In Memory" permission is assigned...

Eirikur Eiriksson (5/3/2015)

---

Quick questions, is the server running SQL Server? Is AWE enabled on the server? What are the memory (min/max) config of the SQL Server? What is the output...

Martin,

Thanks for the feedback. There are no other applications competing for memory. The server is our development server. There is only one other developer besides me.

I just don't...

R.P. - Good Points

I tried to give a simple set of data. Original data has over 300k rows.

I don't have the liberty to change the structure. This is...

R.P.Rozema, thanks for supplying the code to gen. the sample data. Noob mistake. Lesson learned.

Cadavre

Although not a requirement given, the NewID would always be higher than the OldID....

Burninator

This is good stuff! I never thought about just joining to the same table. 😛

Thanks for the idea!!

Burninator (3/6/2012)

---

I'm sure there are fancier and better ways, but here...