MicrosoftSQL Server
Microsoft has announced the availability of SQL Server 2016 Service Pack 2 (SP2) recently.
Service Pack 2 includes all the patches sinceSQL Server 2016 SP1plus performance improvements, diagnostic additions.
SP1 was released back in 2016 so you will see a lot of improvement in this release.
How to get SQL Server 2016 SP2?
Its always recommended to backup configuration and databases of the server before applying the new changes.
I thought I should compile them into an FAQ section for your ease.
Q: When was SQL Server 2016 Service Pack 2 released?
Answer:SQL Server 2016 SP2 was released on 1st May 2018.
Q: Is SQL Server 2016 a cumulative update?
There is no need to install any other update.
Q: What about SQL Server 2016 Service Pack 3?
Answer:There is no news about SQL Server 2016 SP3.
It may be released after one year or so.
From SQL Server 2017, Microsoft has discontinued the Service Pack model.
Q:What is the difference between Hotfix, Cumulative Update and Service Pack?
Answer:Hotfixis released to fix a specific issue.
A single hotfix can be used to resolve multiple issues related to a single scenario.
ACumulative Update (CU)is a pack of all the previous hotfixes since the last cumulative update.
AService packis a tested cumulative update of all the hotfixes and cumulative updates since the last service pack.
Normally, service pack also contains new features and enhancements in addition to security fixes.
Talk to us straight and get your questions answered right away
source: www.itechtics.com
