THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Performance tun... » Best Practices » Batch Size   (RSS)
Sorry, but there are no more tags available to filter with.
  • Revisiting the transaction batch size

    It’s a well known good practice to control the batch size when you perform large data changes. For instance, you may need to purge a large amount of data monthly, and if you delete them all in one shot, you may blow up your transaction log. Therefore, it's wise that you chop up the total amount of data to be deleted into smaller chunks and delete ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 31, 2010
Privacy Statement