Showplan is a feature in SQL Server to display and read query plans. While some of you may already be very familiar with Showplan, it is one of the most important diagnostic tools that we use in the query processing team to locate and identify problems...

I've helped a lot of people upgrade their SQL 2000 applications to SQL 2005. While many of these upgrades go well, occasionally some applications have issues and the overall workload may perform more poorly after the upgrade. One area where I've seen...

Since we’re starting a new blog for the whole query processing team, we think it’s appropriate to start with an introductory post about query processing as a whole and what we’ll be talking about in this blog. If you’re unfamiliar with the way SQL...

This blog will serve as the new spot for content from the SQL Server Query Processor team. The old blog is at http://blogs.msdn.com/queryoptteam , and it has a lot of good content you can reference. We'll update it on this blog as we need to do so...