Improvements with SSMS 2016

The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However, it's also been behind the development cycle of visual studio, and didn't have continual updates. That changed recently, as I've previously posted on. SSMS (Sql Server Management Studio) now being decoupled from the SQL Server database releases.I've been enjoying some of the improvements, especially as relatest to the built in execution plan viewer. I use SQL Sentry Pro, but for a quick review, any improvements to the default viewer is a welcome addition!

Live Statistics View

You can see the statistics update as it's running.

Live Statistics View

Side by Side Comparison of Plans

This is something that is fantastic. A good step in the right direction for helping compare plans quickly. This is a feature I'd love to see added to other tools like SQL Sentry Plan Explorer. When plans don't vary significantly in their structure, this type of view is great for quickly viewing variances.

Side by Side Comparison of Plans

Usability

You can actually drag your mouse to pan a plan... enough said. This should have been there a long time ago.

comparison of properties

The properties pane also has an overhaul with some really useful comparison information, helping you identify what is now different.

comparison of properties

overall

Really liking the improvements I've seen. There are a lot of things about SSMS I'd like to see improved, and with a regular release cycle the future for SSMS looks promising! I'll be really happy once the Visual Studio dark theme has made it's way over... I swear everything just runs faster with a dark theme ;-)