It’s not bundled with the other service packs but it still provides some great utilities. No longer supportedĪll in all, Microsoft® SQL Server® 2008 R2 Service Pack 1 can be considered an essential update if you still happen to have SQL Server 2008 R2 running in your system. However, while these are pretty handy, support for SQL Server 2008 R2 has stopped so any issues with SQL Server® 2008 R2 Service Pack 1 won’t be fixed easily. Plus, you can control your disk space for the PowerPivot feature. There are new Data-tier Application (DAC) Framework as well as DAC upgrade wizard. Querying performance has also been improved. While it can only apply its updates and not Service Pack 2 or 3’s own, these updates are a great addition to the database’s features.įor one, Dynamic Management Views has been extended to improve supportabilities over troubleshooting long-running queries. It has a total of three Service Packs and the first of these was released in 2011, containing a multitude of vast improvements to the database. SQL Server 2008 R2 added certain features to SQL Server 2008, such as a master data management system and the PowerPivot for Excel’s service.

Ms sql management studio 2008 download