THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices » tempdb   (RSS)
  • Connect Digest : 2011-05-09

    This week we're going to look at some issues involving tempdb... Provide a tempdb per database #176241 : Eliminating TempDb By Adding Temp Filegroup to Each Database#281202 : multiple tempdb For these two requests, I am hoping that the Contained Databases feature (which I've talked about multiple times) will get to this capability in the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 9, 2011
  • SQL Server challenge: show me trace flag 1118 is significant -- a quick update

    I posted the following SQL Server challenge yesterday:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   In response, Konstantin Korobkov wanted to know whether the number of data files in tempdb would make a difference.   I did test that scenario and did ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 2, 2009
  • SQL Server challenge: show me trace flag 1118 is significant

    Here is a SQL Server challenge as I have failed so far:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   I have seen a lot of chatters, anecdotes, and stories on the impact of trace flag 1118 on reducing tempdb contentions. But I have not seen ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 1, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement