Tips, Tricks, and Advice from the SQL Server Query Optimization Team

There are many cases where the database administrator does not control the queries being submitted of the system. As a result, the physical database design is often not tuned as well as it could be. In a number of actual customer cases where we investigated...

I saw a post in one of the newsgroups today that referenced a piece of information Microsoft published on how the Optimizer makes decisions about remoting certain operations. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql...

I'd like to point you to a white paper that Eric, one of our program managers, did on Indexed Views in SQL 2005. This logic mostly applies to the Enterprise Edition of our product. http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx...

The Optimizer model makes several assumptions when making plan choice decisions. These decisions can be false for particular queries and data sets, and sometimes this can cause plan issues. One such problem is called “The Sorted Seek Problem” by the Optimizer...

I ran into one of my colleagues in the hallway the other day from another part of the product, and he told me about the blog that the Programmability team has been doing. http://blogs.msdn.com/sqlprogrammability/ Effectively this is the compliment...

Today's topic is a general primer on something that is called "local-global aggregation". Effectively, this is a technique to allow you to take a query containing joins and group bys and perform the group by partially "before" the joins. This can dramatically...