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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement