Thanks, not sure why my original ones work too. the one not using boolen, and with '' around True, false.

It must do some implicit conversions behind.

But I changed according to...

[No - switching the recovery models does not reduce the amount of logging on deletes. The amount of data logged will be exactly the same whether in simple, bulk_logged...

Steve Jones - SSC Editor (11/28/2011)

---

I'm confused. What space are you trying to save? You started posting as though you were having log space issues with this delete. Then you...

Steve Jones - SSC Editor (11/28/2011)

---

If you aren't overly worried about recovery, then switch to simple, and delete in batches, which will limit log file size. Then switch back to...

Thank you, this is a test environment, but it mimics the production server, so we still want to keep the backups, although we keep only two weeks backup on disk...

I realize I should have said I don't have enough space on the backup drive, for Log drive it is fine now.

So how can I reduce the log backup file...

I don't use replication on this server.

Can I use change recovery mode to simple, then after the delete batch processed, change it back to full recovery mode?

Thanks

Thanks all.

I will try all the options.

Thanks, it helps a lot

Thanks, actually I'm using SQL 2008, for I did't see there is a forum about ssis in 2008 , other than this one and the one about data warehouse.

For merge...

Licensing for virtuals is now a hell of a lot easier. Before, say I have a virtual server with 6 virtual CPUs. How many socket licenses do I need (assuming...

Thanks all.

I am currently buying 2008 standard SQL server license.

Is there a way buy logging to the SQL server and found out how many sockets it has?

Thanks

Thanks all.

Thanks, good to know