i would say NO. let Sql server handle the CPU or...

Thats correct, you hit the nail at right spot. actually...

This chain of reply/comments is really informative and helpful..i seriously took printout of everything and had a thorough look while heading back to home in my office cab.

@steve-2...

as gail suggested in her prior post

this DB belongs to our new clients.So cant comment much on it . but it seems that this is a...

post the query

lallu_jaya (9/21/2010)

---

Though the recent data in my table is from 2005, For some reason In my execution plan under argument section it shows up as Index seek where datestamp>getdate()-'sep...

Craig Farrell (9/21/2010)

---

To do this, without screwing up workload any more then its going to, it takes a snapshot of the recordset, meaning it makes a copy of it in...

can you please brief it ?

Some more information about the concerned database :

1. Data file growth has been set to : 1 MB.

2. it contains 18000 tables,there are couple of heavy table...

thanks for quick response :-).15 GB space to work ?...

Have you google it ? i am not sure you can get any script which will work for both table and SP. but individual script will be there. So happy...

Thanks but as i mentioned that i have 64 bit machine and this resolution is for 32 bit machine.

Still using table variable for heavy volume of data. i would suggest...

Memory, CPU, IO usage.