Microsoft SQL Server 2012 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP1. This service pack contains SQL Server 2012 Cumulative Update 1 (CU1) and Cumulative Update 2 (CU2).
This download site contains the following packages and service patches for the Microsoft SQL Server 2012 SP1 release:
- Microsoft SQL Server 2012 SP1 Update – this package contains the Microsoft SQL Server 2012 Service Pack 1 update to be applied to existing SQL Server 2012 installations.
- Microsoft SQL Server 2012 SP1 Slipstream– This package provides the capability to perform new SQL Server 2012 instance installations (or SQL Server 2008/SQL Server 2008 R2 Upgrades) culminating with Service Pack 1 pre-installed. The slipstream installation package consists of a compressed self-extracting .exe and a ‘.box’ payload file that contains the original SQL Server 2012 release along with Service Pack 1. The .exe file can be directly executed, or utilized from the command prompt just as SQL Server 2012 Setup.exe would be (See Install SQL Server 2012 from the Command Prompt).
You can download the service pack here.
Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem that seems like something else that can make troubleshooting all the more difficult and frustrating. Other times, the answer you’re looking for is staring you right in the face. This is the case with SQL Server 2008 R2, which has a known locking issue you can resolve by simply applying the latest service pack or update.