Tips, Tricks, and Advice from the SQL Server Query Optimization Team
After a few months, we're pretty happy with the content and readership we have created. This is a...
Date: 09/20/2006
I've been busy reading the SQL Customer Team's blog. Lots of good data on how to build a good...
Date: 09/14/2006
(2006-09-01 added a paragraph on parallel query plans) In SQL Server, “Statistics Profile” is a mode...
Date: 08/29/2006
A quick post for today. It's actually more of a storage engine concept, but you'd be surprised how...
Date: 08/01/2006
If you read the Books Online page describing the UPDATE STATISTICS command, you will see that there...
Date: 07/21/2006
Not everyone knows that query level hints (like loop join) will impact the entirety of a DML query...
Date: 07/14/2006
A question we are frequently asked is what happens when an update statement assigns a column to its...
Date: 07/07/2006
We've been hard at work up here on a little prototype for you guys to try. This attachment is a...
Date: 06/01/2006
A question came in about when to use the FAST hint. If you remember from the row goals post...
Date: 05/03/2006
SQL is a declarative language that returns multi-sets (sets allowing duplicates) of rows. The...
Date: 05/02/2006
Today's topic is a general primer on something that is called "local-global aggregation"....
Date: 04/18/2006
I ran into one of my colleagues in the hallway the other day from another part of the product, and...
Date: 04/12/2006
The Optimizer model makes several assumptions when making plan choice decisions. These decisions can...
Date: 04/12/2006
I'd like to point you to a white paper that Eric, one of our program managers, did on Indexed Views...
Date: 04/11/2006
I saw a post in one of the newsgroups today that referenced a piece of information Microsoft...
Date: 04/06/2006
There are many cases where the database administrator does not control the queries being submitted...
Date: 04/06/2006
Parameters are a useful way to improve overall system performance when there are many common queries...
Date: 03/31/2006
Today, we'll talk about row goals. The optimizer in SQL Server has a feature that can bias plan...
Date: 03/30/2006
Ian had a blog that contains a number of interestig tips/tricks, mostly about cardinality estimation...
Date: 03/27/2006
(Updated 2006-27-03 9:00am Pacfiic Time - at the bottom) SQL is a declarative language. That means...
Date: 03/24/2006
(Ok, let's try something a bit more involved now. Here's a tip on how you can use computed columns...
Date: 03/24/2006
SQL Server contains self-tuning functionality that will recompile your query as the source data...
Date: 03/24/2006
Statistics is one of the most challenging areas of our product. While we have automated a number of...
Date: 03/24/2006
On behalf of the Query Optimization Team for Microsoft's SQL Server product, welcome to our humble...
Date: 03/24/2006