What’s new with SSMS Plan Comparison Tool?

Cross post with https://aka.ms/sqlserverteam With the SQL Server Management Studio February update, we released a new update for the Plan Comparison Tool. In case you missed it before, we introduced this tool inside SSMS back in October (CTP2.4), with which you can do offline comparison of execution plans, from SQL Server 2005 to the latest…


Comparison Tool released with latest SSMS

Cross post with aka.ms/sqlserverteam The ability to compare plans is something that a lot of people have to do for troubleshooting reasons. Maybe it’s to find why a query or batch suddenly slowed down; to understand the impact of a rewrite; or observe how a specific performance-enhancing change introduced to the design (like an index)…


SQL Swiss Army Knife #15 – Handling duplicate indexes

Hello all, Part of my job is to help customers find and fix performance issues, and this post comes after one such engagement. A customer was using another of the SQL Swiss Army Knife series scripts to find info on indexes on all the databases in a given instance – the one referenced in the…

0

About Maintenance Plans – grooming SQL Server

Latest update: 10/24/2016 (Check change log) Download scripts on GitHub. Hello all, I admit I’m not a big fan of Maintenance Plans (the feature that goes by that name) mainly because of its “do or die” approach. So, it was not by chance that I authored and keep updating the AdaptiveIndexDefrag procedure. Good maintenance (or lack…


SQL Swiss Army Knife #11.1 – Locking, blocking and active transactions

Latest update: 12/2/2016 (Check change log) Download on GitHub Hello all, Following the series “SQL Swiss Army Knife”, here is another version of this script that I’ve been using and tweaking for years now. This way I can get a quick overview of query execution on a given SQL Server instance, from SQL Server 2005…

3

SQL Server Tools – Extended Events Manager & Partition Management

There are two tools available on Codeplex that you may consider to use/test: SQL Server 2008 Extended Events Manager http://extendedeventmanager.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23813 and SQL Server Partition Management http://sqlpartitionmgmt.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23683 Cheers,


SQL Nexus 2.5.0.7 released

Hi, A new version of the tool – SQL Nexus (2.5.0.7) was released: http://sqlnexus.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23339 Release Notes Most fixes are related to silent or batch processing 1) Adjusted CurrentDB text box for auto-complete and copy and paste database name 2) Enhanced batch/silent import running from command prompt. example: sqlnexus.exe" -S"<serverName>" -d"<db Name>" -E -I"<Input file path>"…


RML Utilities, version 9.01 Released

A new version of the RML Utilities for SQL Server, version 9.01, was released (with support for SQL Server 2008): http://blogs.msdn.com/psssql/archive/2008/11/12/cumulative-update-1-to-the-rml-utilities-for-microsoft-sql-server-released.aspx Review, also, the last minute update regarding a small issue when trying to run the installation setup with non-Admin privileges enabled: http://blogs.msdn.com/psssql/archive/2008/11/12/prb-rml-utilities-setup-may-always-prompt-for-report-viewer-2008-redistributable.aspx Cheers,