Hi Lutzm,

Thanks for the tips on deletion.

Wishing you a Merry Christmas and a Spirit-filled Happy Prosperous New Year!

God bless you...

Antonio

Hi Lutz,

It works. It's fast. I tried it for two tables deleting 2 million records for each table. Below is my final stored procedure in which I wanted...

Thanks.. I will ty and test this scripts. Very much appreciated.

Thanks.. we set the min/max to 6083 Mb using the option 'used a fixed memory size'. Our server admin is concerned that if we used Dynamic allocation...

Wil try seting the min to 1024 Mb and leave the max to 7Gb.

Below is how our boot.ini is setup (where PAE is setup). Are there other place to...

Hi,

Thanks for the immediate response. Below is the info I got from our Server admin. Would it hurt in the long run if we just leave it to that...