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 2 of 9 (88 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
  • A demo kit for SQL Sentry Plan Explorer

    UPDATE 2016-10-07 - This demo kit has been overhauled:           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
  • 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
  • Connect Digest : 2011-08-08

    This week I reported a few bugs - one with sp_helptext, one with Activity Monitor in Management Studio, and one in the new sys.dm_server_services DMV.#683234 : sp_helptext treats non-system objects as system objects For this one there is at least one weird case where running sp_helptext against on object prefixed with dbo ignores the dbo and tries ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 8, 2011
  • SQL Server v.Next (Denali) : Getting Ctrl+R to work again

    Ctrl+R is a good friend of mine - we go way back. It is very handy to use this command not only to hide the results pane away and focus on the query at hand, but to also be able to bring the results back just as quickly - without having to run the query again, or mess with click + drag nonsense. In Denali, we get a new version of SSMS, tightly ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 14, 2011
  • Thoughts on Nexus in SQL Server PDW

    I have been on a SQL Server Parallel Data Warehouse (aka PDW) training course this week and was interested to learn that you can't (yet) use SQL Server Management Studio (SSMS) against PDW, instead they ship a 3rd party tool called Nexus Chameleon. This was a bit of a disappointment at the beginning of the week (I'd prefer parity across SQL Server ...
    Posted to Jamie Thomson (Weblog) by jamiet on June 17, 2011
  • Connect Digest : 2011-05-23

    Next week I'll be up in Alaska for SQL Cruise, so I'll be skipping at least one digest. This week I gathered a few engine-related issues, two involving what the engine does while an index is being created. The most important one, though, at least IMHO, is the first one listed, involving a hashing algorithm fix that is in SQL Server 2008 R2 - but ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 23, 2011
  • Connect Digest : 2011-05-16

    This week we're going to take a look at issues with filtered indexes. This feature was a very welcome addition in SQL Server 2008 and has enjoyed widespread usage if conversations on twitter and forums are any indication. But their implementation is not perfect - bugs in SSMS and numerous restrictions on their use have certainly reduced their ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 16, 2011
  • Connect Digest : 2011-04-11

    This week I decided to focus on some of the long-outstanding issues with IntelliSense in Management Studio. While I know many of you are using 3rd party tools like RedGate's SQL Prompt, not everybody has that luxury - in my case, I can't justify a license for every single server I touch, since I can't connect to every environment using SSMS ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 11, 2011
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement