THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Execution plans   (RSS)
Showing page 2 of 3 (23 total posts)
  • 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 in Denali, we've added operators and columns to reflect these changes. For example, you will ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 25, 2011
  • 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, he states:  When a clustered index is present on the table & ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 15, 2011
  • 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 in response to customer demand for ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 13, 2011
  • How to find missing indexes quickly in SQL Sentry Plan Explorer

    This question came up on twitter, and I thought a quick blog post would be better than a series of 140-character snippets. Management Studio does not do the best job at highlighting missing indexes. If you have a simple query plan that represents a single statement, no problem; however, if you have a plan that represents a multi-batch statement, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 17, 2011
  • 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 the Help menu: Other new additions to the Help menu: Enable/disable the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 3, 2011
  • A couple of fixes for Plan Explorer

    This evening SQL Sentry has pushed out a new build of Plan Explorer 1.2 (build #6.1.32), fixing a couple of minor issues brought to our attention by users. Eric Humphrey (@lotsahelp) pointed out that our query timeout for generating an actual plan was set to 30 seconds. This was an oversight, but chances are you wouldn't see this in most ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 26, 2011
  • Connect Digest : 2011-03-12

    Background Last year, I came to a very tough decision that I would cease publicizing Connect items in an attempt to drive up votes and get important issues fixed. This was almost entirely due to a couple of MVPs criticizing me for raising awareness of certain Connect items instead of letting them be found ''naturally.'' I wasn't sure what world ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 12, 2011
  • SQL Sentry Plan Explorer : Version 1.1!

    Last week, Microsoft offered up an early Christmas present: SQL Server 2005 SP4.  This week, it's SQL Sentry's turn to play Santa Claus: several new features and fixes have been packaged up into SQL Sentry Plan Explorer 1.1 (build 6.0.67.0). So, what's new?  Several wish list items have been fulfilled (hey, it is Christmas, after ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 22, 2010
  • SQL Sentry's Plan Explorer : a closer look

    Today I was digging more into SQL Sentry's Plan Explorer, and I continue to discover little things I think you will find valuable in your performance tuning and troubleshooting efforts. Let's say I am analyzing a plan for a relatively simple batch: SELECT * FROM sys.objects;CREATE TABLE #foo([object_id] INT, def NVARCHAR(MAX));INSERT ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 27, 2010
  • A first glimpse of SQL Sentry's Plan Explorer

    Yesterday, Greg Gonzalez (blog | twitter) announced a beta project for SQL Sentry's latest offering: Plan Explorer.  I have been playing with the early versions of the beta, and I can tell you that DBAs should be very excited about having this tool in their arsenal.  This is a free companion to SQL Server Management Studio that greatly ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 21, 2010
Privacy Statement