Engine Watch

database engine technology and SQL Server

September, 2005

Posts
  • Engine Watch

    [SQL Server 2005] TEMPDB optimization

    • 3 Comments
    In SQL 2005 we have done quite a bit of internal improvements in tempdb scalability. These include: Caching of IAM and first data page for temp table and table variables. Improved allocation page latching protocol so that we use UP latch less...
  • Engine Watch

    [SQL 7.0] capacity planning tips

    • 0 Comments
    This is really old, but some tips are still potentially useful: http://www.microsoft.com/technet/prodtechnol/sql/70/tips/storagen.mspx
  • Engine Watch

    SQL 2000: stored proc recompile

    • 0 Comments
    Old article but still very useful: http://support.microsoft.com/default.aspx?scid=kb;en-us;243586
  • Engine Watch

    SQL 2000: what to do if tempdb grows to be very big

    • 1 Comments
    Unless your workload changed significantly, shrink file is not going to help you because tempdb will just grow back if a query needs that amount of free space. So a better way is to identify the query and try to optimize that, maybe by adding an index...
  • Engine Watch

    SQL 2005: TSQL enhancements

    • 1 Comments
    Click the following link to learn things like: TOP, RANK, ROW_NUMBER, PIVOT, Recursion... http://www.awprofessional.com/articles/article.asp?p=327394&seqNum=7&rl=1
Page 1 of 1 (5 items)