here's a nice overview ...

http://www.sqlservercentral.com/articles/63472/

http://www.codeproject.com/KB/database/SQP_performance.aspx

http://www.mssqltips.com/tip.asp?tip=1556

http://blogs.msdn.com/sqlserverstorageengine/archive/2008/03/30/sql-server-table-variable-vs-local-temporary-table.aspx

Written by yours truly :w00t:

I guess I lost track of this forum thread I'd launched myself.

Thanks for adding the link.

hth

This is not a challenge.

The point always is to find a thingy that works, alligned with what's reasonable, and...

Yuckon (7/25/2008)

---

Thanks for your suggestion,

DB Mirroring is not an option as I dont want the overhead on Server A - the load must be totally offline.

The reason I want to...

- Wouldn't you be better off setting up db-mirroring ?

(maybe even using db-snapshots to use the data you want)

It will keep up with the updates if...

I'm in Toronto this week spending some quality time with the family :w00t:

I'll see if I can get the info you requested.

Johan

BTW the new drivers are:

HP DL380G5

ComponentFirmwareDriver

Bios P56-01/24/2008-

ILO1.431.13.0.0

Networkcards2.1.2.04.4.21.0

Raidcontroller1.786.12.4.32

Videocard-6.14.10.6744

GilaMonster (7/21/2008)

---

The best part was that a few months...

just a ping back http://www.sqlservercentral.com/Forums/Topic510666-1291-1.aspx

Oh indeed, sqlserver will try to make its work as easy as possible by grabbing all the ram it actualy needs.

Probably it decided to grab some more because of the...

Thank you for providing the extra parameters Jeffrey.

Apparently those weren't in BOL sep. 2007

I don't have sql2005 on win2003 right now, but according to BOL

you can check it using:

LOGINPROPERTY ( 'login_name' ,

...

till today that driver-fixed server has been running fine after the upgrade.

We're planning on doing the same operation on the other 3 servers next tuesday.

No dump, no eventlog, no nothing...

And sweet is the odor of victory 😎

But sometimes...