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 » SQL Server 2008 » trace flags   (RSS)
  • 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
  • Big News : Lock Pages in Memory for Standard Edition

    After much feedback from customers (and some loud feedback from MVPs, led primarily by Maciej Pilecki), Microsoft's Bob Ward just announced at the European PASS Conference that they are going to allow the 'lock pages in memory' privilege for all the lowly peons running Standard Edition.  Currently this has only been allowed on Enterprise ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 24, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement