Category: SSMS
Recover SSMS Scripts
So you’ve been working on scripts in SSMS v17.x and suddenly it freezes and won’t let you interact with it at all.
No fear, when you close (kill) the SSMS process using Task Manager and reopen it you should be prompted to recover your files. The caveat being that you haven’t disabled Save AutoRecover in the Tools – Options menu item.
However, if you’d rather not take the risk of not being prompted and as per the previous screenshot, you should hopefully be able to find your scripts under your Documents\Visual Studio 2015 folder.
SSMS Drag/Drop Format Options
With the newly released SSMS v17.6 there has been a new Drag/Drop section added to Tools -> Options menu item as shown below:
When both are set to True you’ll get the existing functionality
When both are set to False you will now get:
Notice that the Database Version column will still have brackets as it has a space in the name even though Surround object names with brackets when dragged is set to False.
SQL Server Management Studio 17.2
SQL Server Diagnostics intro
The newly released SQL Server Diagnostics (Preview) can be found here.
Below are the install screenshots
Once installed it is accessible via SSMS
Dumps are usually located in your …MSSQLSERVER\MSSQL\Log folder.
Here I also selected to send an email just to see what it’ll look like.
The email received was
The other Diagnostics options were
Looks a bit of a cover all at the moment
Takes you to the below site (which no longer exists)
SSMS Include Client Statistics
Troubleshooting performance issues can be challenging and more so when 1 user has issues and another doesn’t for the same application and they both sit in the same room.
This is where SSMS Include Client Statistics may come in handy.
Enable the option and run the query causing issues on both users machines.
Possibly you the results will help point you in the correct direction i.e. network path issues etc..
Remember to unselect the option when finished as it adds extra overhead when used.
SSMS AutoRecover Location
By default, SSMS saves your queries every 5 minutes and keeps the info for 7 days.
I suspect this has saved many a DBA when unforeseen outages occur.
One quick way to get to this recovery location is shown below and is by right clicking on a Query tab:
As you may have noticed, this provides a quick access method to your hidden AppData folder.
SSMS incremental upgrades
You may have noticed that SSMS 17.1 now offers an upgrade package for existing SSMS 17.0 installs.
So what’s the difference? Roughly 400MB.