MS SQL Server is relational model database server developed by Microsoft for the purpose of database management. It is widely used database management system which allows users to store and manage huge amount of data in an effective manner. Recently, Microsoft has announced that SQL Server 2008 R2 Service Pack 2 is now available for download. It is latest service pack update which is endowed with much improved features and functionalities and can be easily downloaded from Microsoft Download Center. This improved service pack 2 comes with hot fix solutions for the maintenance and repair of database. It also permit users to incorporate reporting services integrated with SharePoint products.

SQL Server 2008 R2 Service Pack 2 can be used to upgrade different editions of SQL server including Developer, Enterprise, Enterprise Evaluation, Standard Workgroup etc. This improved update comes with various improved features and enhancements. Some of its key improvements are mentioned below:

• It supports Dynamic Management View which ensure improved supportabilities over long-run queries by extending additional columns
• It provides various tools and new add-in to support the reporting server of SQL Server 2008 R2 Service Pack 2 with SharePoint 2007 products
• It provides improved client tools like SQL Server Management Studio
• It supports Data Tier Application operations using which you can register, deploy, upgrade, extract and delete DAC objects

This service pack has been developed with lots of enhancements according to users requirements. So, you can upgrade any editions of SQL Server using it.

System requirements for SQL Server 2008 R2 Service Pack 2

• Operating system: Windows 2000 Service Pack 4, Windows 2003, Windows 2008, Windows XP, Windows Vista and Windows 7
• Processor: compatible Pentium III 600 MHz or higher processor
• Minimum 512 MB RAM
• 675 MB free hard disk space