Thats correct, I didnt state it clearly. Job removes old data, trigger just handles the changes.

Andy

I didnt have many packages but the ones I did were fine. The upgrade in general was painless. Remember to run sp_updatestats after the upgrade on each db to get...

Reason I asked was because you're maxing at 1.9g used. Without 3/GB SQL cannot use more than 2 (about 1.9 really). You have to add /3GB to your boot.ini. At...

A simple way in QA is to click query, server trace. That will give you both numbers.

Andy

xp_sendmail works in both versions.

Andy

It's normal for SQL to acquire the memory and it will release it back if the OS needs it. This lets it cache as much as possible, both data and...

You're back to profiling. Only way to see for sure it to see the query plan plus the io and cpu usage.

Andy

Plain VGA usually works on just about everything. Tried to terminal service to the box to see if you can change it there?

Andy

We pretty commonly have special purpose procs that might update only part of a row, or might update portions of several rows in different tables in a transaction.

The bitmap idea...

Not sure about max columns, I know there is a max row length with merge (around 6k) due to the overhead of the metadata.

Andy

Not quite a standard. For instance, one of our apps uses optimistic locking, so there is no need for a timestamp check. One reason not to just update the entire...

Syntax looks ok, though opening a recordset based on a table has to be one of my top 10 or so pet peeves. At least do a select * from...

SQLZip starts at about $500. A combination of zipping and Jonesing (FTP) will work if thats all you have. Second NIC is a good idea, can probably get that done...

On the first one, a shortcut method is have then add an entry to a table indicating they want the job to run, have a job that polls the table...

Run sp_updatestats. SQL keeps track of the data distribution to help it determine what the best query plan will be. If the statistics are out of date, you'll get query...