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 » Best Practices » Performance tuning   (RSS)
  • Performance impact: The cost of doing small lookups in a large batch update

    Lookup tables are widely used in database applications for good reasons. Usually, a lookup table has a small number of rows and looking it up with a join is fast, especially when the table is already cached. Recently, I needed to update every row in many relatively large tables, each of which was identically structured, had ~25 million ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on April 4, 2011
  • 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