Linchi Shea : tempdb

Temp table name resolution

Linchi Shea — Thu, 15 Jul 2010 21:33:00 GMT

I was reading Michael Coles' post on Dynamic SQL and Late Binding , and it reminded me of an issue I struggled with a while back. The issue started out as a local temp table name resolution issue. But it was also a compilation time vs. run time issue,...(read more)

SQL Server challenge: show me trace flag 1118 is significant -- a quick update

Linchi Shea — Fri, 02 Oct 2009 15:42:00 GMT

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...(read more)

SQL Server challenge: show me trace flag 1118 is significant

Linchi Shea — Thu, 01 Oct 2009 15:53:00 GMT

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...(read more)

Performance impact: tempdb and update statistics

Linchi Shea — Mon, 17 Aug 2009 01:10:00 GMT

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...(read more)