SQL Server 2008 Service Pack 2 released

Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download.  The release notes are quite extensive, so check them out; there are so many that they have them segmented by topic.  I was perusing the list of Integration Services in particular (since that's what I've been working on the past year or so) and it includes eighteen or so fixes, but I couldn't find one that I consistently run into, so we may be good here. Interesting that it looks like about 1/2 of them are related to Script Task.

Be careful that you are on the current version and not the revision. How we can have two releases of the release notes out within a week of the service pack I have no idea, but it apparently has been done.

A couple of other things...

SQL Server Utility. After you apply SP2, an instance of the SQL Server 2008 Database Engine can be enrolled with a utility control point as a managed instance of SQL Server. For more information, see Overview of SQL Server Utility in SQL Server 2008 R2 Books Online.

This is a good one, so you can now use the SQL Server Utility on both SQL Server 2008 and SQL 2008 R2 - if you haven't geeked with this feature check it out. It's pretty cool.

15K partitioning Improvement. Introduced support for a maximum of 15,000 partitions in tables and indexes in Microsoft SQL Server 2008 Service Pack 2 in the Enterprise, Developer and Evaluation Editions. For details on how this support can be enabled and disabled, along with recommended operation paramaters, see the white paper Support for 15000 Partitions.

15K partitions?  Seriously someone needs this?  Wow, I have to get up-to-speed on partitioning if we're requesting this functionality these days...

Thanks for reading,

Lee Everest

-------------------------------

Halford's new release...dig it!

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17&displaylang=en