Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features, and also blogs at blogs.sentryone.com and SQLPerformance.com; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

Browse by Tags

All Tags » Query plans   (RSS)

• Add-in
• aggregates
• execution plans
• graphical plans
• management studio
• Missing indexes
• performance
• plan anaylsis
• Plan Explorer
• showplan
• SQL Sentry
• SQL Sentry Plan Explorer
• SSMS
• testing
• Windowing functions
• XML
• XSD

• Comparing multiple plans in SQL Sentry Plan Explorer

  I’ve seen the question a few times now: “How do I compare two plans side-by-side in Plan Explorer?” Management Studio allows you to view multiple graphical plans that are visible simultaneously, either by generating plans for every statement in a batch, Read More... Posted Friday, January 06, 2012 11:54 AM by AaronBertrand | 3 Comments Filed under: SSMS, management studio, SQL Sentry, execution plans, Plan Explorer, Query plans, graphical plans, showplan, SQL Sentry Plan Explorer

• Getting graphical ShowPlans back in SQL Server 2008 R2

  For those of you using the SQL Server 2008 R2 version of Management Studio, and have applied Service Pack 1, you have probably noticed that clicking on a ShowPlan in grid results no longer shows the graphical plan, but rather opens a new window with the Read More... Posted Friday, October 28, 2011 2:42 PM by AaronBertrand | 19 Comments Filed under: SSMS, management studio, SQL Sentry, execution plans, Plan Explorer, Query plans, XML, graphical plans, XSD, showplan

• SQL Sentry Plan Explorer v1.3

  On Friday, we published a new version of our free query plan analysis tool, SQL Sentry Plan Explorer . As noted in the change list , we've added a couple of important features. SQL Server 2012 support With a whole slew of changes to the showplan schema Read More... Posted Tuesday, October 25, 2011 1:43 PM by AaronBertrand | 9 Comments Filed under: SSMS, management studio, SQL Sentry, execution plans, Plan Explorer, Query plans

• Why generalizations are dangerous

  A couple of years ago, John Sansom wrote a blog post comparing the performance of two different ways to get the maximum value from a column: MAX() and TOP (1). http://www.johnsansom.com/performance-comparison-of-select-top-1-verses-max/ In the conclusion, Read More... Posted Thursday, September 15, 2011 8:19 PM by AaronBertrand | 4 Comments Filed under: Windowing functions, performance, execution plans, Plan Explorer, aggregates, Query plans, testing

• A demo kit for SQL Sentry Plan Explorer

  UPDATE 2016-10-07 - This demo kit has been overhauled: https://blogs.sentryone.com/aaronbertrand/plan-explorer-3-0-demo-kit/ Plan Explorer is a free application from SQL Sentry , designed to make execution plan analysis faster and easier. It was developed Read More... Posted Tuesday, September 13, 2011 1:31 PM by AaronBertrand | 11 Comments Filed under: SSMS, management studio, SQL Sentry, execution plans, Plan Explorer, Query plans, Missing indexes

• SQL Sentry Plan Explorer : New release and an SSMS add-in

  Today we released a new build of SQL Sentry Plan Explorer. The build # is 6.2.34 and you can download it from the usual location . Plan Explorer Changes The updates in this release include the following: A new "Check for Updates" feature accessible via Read More... Posted Wednesday, August 03, 2011 9:25 AM by AaronBertrand | 22 Comments Filed under: management studio, SQL Sentry, execution plans, Plan Explorer, Add-in, plan anaylsis, Query plans