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 » SSMS   (RSS)
Showing page 1 of 9 (84 total posts)
  • Ctrl-R Not Working in SSMS After a Patch?

    I whined about this recently on Facebook. After that, I did something practical: I searched for a solution. I found a workaround at Connect: Open SSMS Select "Tools", "Customize..." - Click "Keyboard..." - In the list window, scroll down and select "Window.ShowResultsPane" - Under "Use ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 7, 2013
  • Connect Digest : 2012-07-06

    I've filed a few Connect items recently that I think are important. In #752210, I complain that the documentation for DDL triggers suggests that they can prevent certain DDL from being run, which is not the case at all.      ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 6, 2012
  • 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, or by generating plans in separate query windows and then splitting the panes. However, at ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 6, 2012
  • T-SQL Tuesday #25 : T-SQL Tips 'n' Tricks

    This month's T-SQL Tuesday is being hosted by Allen White (@SQLRunr) and is about sharing your T-SQL tips and tricks. Since I know many people will share their T-SQL magic and wizardry, I thought I would share a couple of productivity tips - so still T-SQL related, but more how to take advantage of some features in SSMS. Drag column list onto ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 13, 2011
  • Connect Digest : 2011-12-01

    Where is my graphical ShowPlan? Many of you on SQL Server 2008 R2 are experiencing a major annoyance with SSMS since installing service pack 1 - when clicking a plan from grid results, you get raw XML instead of the graphical plan. I wrote about this symptom and a workaround in a previous post. In the original Connect item, they state that it ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 1, 2011
  • 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 raw XML. For example, running the following query: SELECT TOP (5) ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 28, 2011
  • 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
  • A demo kit for SQL Sentry Plan Explorer

    UPDATE - This demo kit has been overhauled: http://sqlperformance.com/2014/03/t-sql-queries/updated-plan-explorer-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 deeper query analysis, but was ...
    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
  • Query window custom colouring now works properly [SSMS]

    SQL Server 2008 introduced a new feature that had the potential to be very useful, the ability to color colour-code a query window in SSMS to represent the server that was being connected to. This was configured using the properties of a server in the Registered Servers pane: Unfortunately this feature was made less than useful, dangerous ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 11, 2011
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement