April 2006 - Posts

• Local-Global Aggregation

  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 Read More... Posted Tuesday, April 18, 2006 9:31 AM by QueryOptTeam | 3 Comments

• T-SQL Procedural Blog

  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 in Read More... Posted Wednesday, April 12, 2006 7:13 PM by QueryOptTeam | 0 Comments

• Sorted Seeks

  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 Read More... Posted Wednesday, April 12, 2006 1:28 PM by QueryOptTeam | 1 Comments Attachment(s): cluster.jpg

• Indexed Views in SQL Server 2005

  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 This Read More... Posted Tuesday, April 11, 2006 9:21 AM by QueryOptTeam | 3 Comments

• Optimizing Distributed Queries

  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/odp_tun_1a_6oxf.asp Read More... Posted Thursday, April 06, 2006 1:10 PM by QueryOptTeam | 5 Comments

• Why should I create an index?

  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 Read More... Posted Thursday, April 06, 2006 11:29 AM by QueryOptTeam | 4 Comments