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.

That should all be handled by that app that takes the order, not a job for sql server.

... and seriously, consider asking nicely for a 1 off test to solve a problem your manager is having. I've never had anyone say no to me to...

Bhuvnesh (3/11/2011)

---

Current db size is 900 gb and you are saying it could get flat raise in next year.you shud also think about following steps.

1 manage your DB on multiple...