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 » tempdb » UPDATE STATISTICS   (RSS)
Sorry, but there are no more tags available to filter with.
  • Performance impact: tempdb and update statistics

    In SQL Server, one of the most significant architectural legacies from Sybase is the use of a single globally shared tempdb database. Any time you have something globally shared in a highly concurrent system, the shared resource can become a huge impediment to the scalability of the whole system. Tempdb is no exception.   Consequently, ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on August 16, 2009
Privacy Statement