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 Tuning   (RSS)
  • 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
  • Would you optimize SQL for less performance?

    What do you mean? Okay, that does sound like an oxymoron, doesn't it? Let's say you are trying to optimize a stored procedure, and your proposed change results in the stored procedure running not faster, but perhaps a bit slower than it currently does. Can you then declare your optimization effort a success? Just some food (well a question) ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 8, 2010
  • Performance impact: UNION ALL views, ANSI_PADDING, and bad query plans

    Whether or not you specify it explicitly, ANSI_PADDING setting is there when you create a table, and can have an impact on the performance of some queries. If you are not careful, it can even hurt performance big time!   Let’s demonstrate that with an extremely simple example.   Assume that you have this simple view with a UNION ALL ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 4, 2009
  • Interview With Kalen Delaney About Inside Microsoft SQL Server 2005 Query Tuning and Optimization

    I am a big fan of Inside Microsoft SQL Server 2005 The Storage Engine so when I saw that yet another book got published in this series I just had to check it out. Inside Microsoft SQL Server 2005: Query Tuning and Optimization is very well written gets to the point and give you the answers that you need. I decided to contact Kalen to see if she ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on October 15, 2007
Privacy Statement