Browse by Tags

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...

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...

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...

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...