THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SSMS   (RSS)
Showing page 1 of 9 (88 total posts)
  • SSMS release 16.4 is now available

      The newest release of SQL Server Management Studio (SSMS) is now available. The details and download link can be found here. If you haven’t already downloaded or tried the new SSMS I highly recommend getting it and giving it a whirl. With the new release cycles we will see new features and bug fixes on a regular basis. Enjoy. Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on September 20, 2016
  • July SSMS 2016 changes transaction semantics

    This can be a very nasty one if you're not observant. The July update of SSMS now has the option to change XACT_ABORT setting for a query window usingToolsOptionsQuery ExecutionSQL ServerAdvancedSET XACT_ABORTNow, exposing one more SET option can't be bad, right? But Erland Sommarskog found out that this is checked by default. Now, using ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 5, 2016
  • Books Online for SQL Server 2016

    This one is for those of you who prefer to use a local SQL Server Documentation, a.k.a. Books Online (BOL), instead of using the web-based BOL. A local BOL is essential for me. Navigating the contents, switching between pages and searching is lightyears ahead and quicker in the local BOL. (Update: Added bits about the missing ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 30, 2016
  • Restoreability and SSMS

    I have written about this before, how SSMS generates restore commands that will fail. This post is about showing what it might look like using screenshots. If you always use T-SQL directly to do restore, then you won't be affected by this. But if you expect to be able to perform restore using the restore dialog, then read on. The problemThe issue ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 16, 2016
  • 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
1 2 3 4 5 Next > ... Last »
Privacy Statement