Category Archives: SQL Server 2016

SQL Server 2016 – End of an Era – So long AdventureWorks..Welcome World Wide Importers

SQL Server 2016 April 14, 2017 Leave a comment

End of an era if I should say so. It all started with SQL Server 2005 with a database named AdventureWorks. A sample database to help learn different aspects of the product. Take a bow AdventureWorks.

Welcome [WideWorldImporters]!!! This is a new database developed by MS targeting SQL server 2016 and Azure. Links below for download. Loads of goodies to download.

https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

 

I hope this article was useful. Have a good day ahead.
Bodhisatya

Advertisement

SQL Server – How to compare execution plans

SQL Server 2012, SQL Server 2014, SQL Server 2016, SSMS April 11, 2017 Leave a comment

One of the challenges for DBAs and Developers was to compare execution plans effectively. In the latest SSMS released by MS we have an option of comparing execution plans in a better readable format. This short article will explain that.

Step 1: Download the latest SSMS from MS website or If you have installed SQL server 2016 then this feature will be available.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

Step 2: Install the downloaded package

Step 3: Execute a query and save the execution plan somewhere.

Step 4: Execute another query and wait till the plan is displayed.

Step 5: Right click on the displayed plan and choose the following option highlighted.

This will ask for the saved execution plan. Choose the saved plan.

Step 6: Click on open
The actions opens 2 windows which shows the difference between the 2 execution plans as depicted below. This is a very handy feature when we need to compare the execution plans for a SP or query pre and post change to gauge the effect in terms of performance.

 

 

 

I hope this article was useful. Have a good day ahead.
Bodhisatya

SQL Server 2012,2014,2016 – When a CU patch can break an existing functionality!!!

Cumulative update, SQL Server 2012, SQL Server 2014, SQL Server 2016 April 9, 2017 Leave a comment

Recently MS released the following patches for SQL Server. The product team has identified that the patches can be potential CDC functionality breaker. The link below for the note from the product team. Worth a read before applying them on production boxes specially if CDC is active.

  • SQL 2012 SP3 CU8
  • SQL 2014 SP1 CU10
  • SQL 2014 SP2 CU4
  • SQL 2016 RTM CU5
  • SQL 2016 SP1 CU2

https://blogs.msdn.microsoft.com/sql_server_team/cdc-functionality-may-break-after-upgrading-to-the-latest-cu-for-sql-server-2012-2014-and-2016/

 

I hope this article was useful. Have a good day ahead.
Bodhisatya

 

%d bloggers like this: