http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspxIn 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 frequently.en-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx#465002Tue, 13 Sep 2005 22:43:33 GMT91d46819-8472-40ad-a661-2c78acb4018c:465002John Gallardo's Weblog<a rel="nofollow" target="_new" href="http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx">http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx</a> <br>Wei mentions a couple of optimizations that...http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx#466129Wed, 14 Sep 2005 18:42:03 GMT91d46819-8472-40ad-a661-2c78acb4018c:466129John Gallardo's Weblog<a rel="nofollow" target="_new" href="http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx">http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx</a> <br>Wei mentions a couple of optimizations that...http://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx#4276244Tue, 07 Aug 2007 14:41:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:4276244Linchi Shea<p>A recently published KB article Q936185 seems to contradict the recommendation of using trace flag 1118</p>