tuseau (3/15/2011)

---

I'm wondering, why is batch delete faster than one statement? I'm assuming it is something to do with the transaction log...

Customers are not happy with truncate being used...

Run the delete in smaller batches (top 10 000)

Run as long as @@rowcount > 0.

That was my whole point about bcp, you can reimport if something goes wrong. Then...

Steve Jones - SSC Editor (3/15/2011)

---

We do not have a code or a deal with PASS this year.

The early bird rates have typically never included a discount because they are...

bcp the data out to file, or send to backup DB.

Script the table and all constraint, triggers, indexes.

Drop / create.

ProKelly (3/15/2011)

---

Thanks guys - both suggestions will work and from your advice, I think i'll stay away from the UNION approach and just plump with either a staging table or...

What about doing insert into where not exists?

That query should fly, even if there's 1 M rows in the big table.

Also I think his question was referring to the locking...

Just for further references, sql 7, 2000 forum is here...

http://www.sqlservercentral.com/Forums/Group406.aspx

Please do not post the same question twice.

Forward the discussion here :

http://www.sqlservercentral.com/Forums/Topic1077708-150-1.aspx

Might be easier to just redo the report in word directly...

LutzM (3/11/2011)

---

Easy fix: the line break < br > is part of the link. Remove it from the end of the link to see the secret...

Actually it doesn't :w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:

Indianrock (3/11/2011)

---

We're definitely not Amazon. Management seems to think we can get the maintenance done quickly no matter how large the system. And the reason we can't is...

Then write a service or another app that process the orders and sends the pdfs.

That should NOT be handled by SQL Server.

That goes way beyond the scope of sql server. & is a reserved character in the url to split between parameters.

Unless that rule changes, you won't be able to...

That link is not working atm.