SQL Server 2008 SP2 has new SharePoint integrations

SQL Server 2008 SP2 also updates for reporting and management tools, supporting up to 15,000 database (partition) partitions.

SQL Server 2008 SP2 has new SharePoint integrations Picture 1
SQL Server 2008 SP2 has new SharePoint integrations. (Internet photo).

Last week, Microsoft released the second Service Pack (SP2) for SQL Server 2008, supporting up to 15,000 database partitions, updating reporting tools and managing and integrating with SharePoint 2010.

SQL Server 2008 SP2 is available on Microsoft Download Center, ' launched ' 18 months after the release of Service Pack 1. SP1 will continue to be supported by Microsoft in 12 months.

SP2 supports up to 15,000 partitions in tables and indexes. Partitioning makes large tables more manageable and scalable, first introduced with SQL Server 2005. According to technical documentation released by Microsoft, the original version of SQL Server 2008 only supports 1,000 partitions. . SP2 also updates the integration of reporting services with Microsoft SharePoint.

While SP2 includes updates from SP1, SP1 is not a prerequisite for installing SP2. SP2 can be used to upgrade any edition of SQL Server 2008. However, it cannot be used to upgrade SQL Server 2008 Release 2, which was launched a few months ago.