Firstly, you're on 32 bit. Unless you have AWE enabled and the /pae switch in boot.ini, SQL can only use 2 GB max. that would explain why so little memory...

I'd probably scale...

I very nearly put the pizza I...

I think it was a posting on these forums. Stick...

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic529875-338-1.aspx

I don't think you can create new DTS packages. If you have the DTS designer components you can modify existing packages

Why do you have to use a stored proc? bcp is about the best solution to this kind of problem. DTS packages work too.

How many rows are we talking about?...

Plase post table structure, sample data (as insert statements) and desired output.

See - http://www.sqlservercentral.com/articles/Best+Practices/61537/

Can you run profiler against the server and look at exactly what reporting servces is doing and how long the queries take?

If you've already deleted the table, the transaction's useless as your delete has already committed. For next time, look up BEGIN TRANSACTION in books online.

As for the 3rd party tools,...

Hav you checked your disks? Check the physical disk counter in perfmon.

Avg sec/read, avg sec/write % idle time.

Run profiler for a bit, catch the slow runnig queries. See if the...

The database you are restoring to must have nobody using it. All users reading it will have to disconnect (or their connections be killed) before you can restore the log.

Depends. If you explicitly started a transaction before runningthe command, you can just run ROLLBACK. My guess however is that you didn't start a transaction. In that case there's no...

The OS can swap SQL's memory allocations out to disk.

I don't blame you.

My worst (and it wasn't all that bad) was the previous bank I worked at. We went through three IT Dept heads in 10...