Even though there are two newer, major releases of SQL Server available, there are still many organizations running SQL Server 2008, which was a good, solid release of the product, with many improvements over SQL Server 2005. SQL Server 2008 (and SQL Server 2008 R2) are scheduled to fall out of mainstream support on July 8, 2014<\/a>, which is still quite some time in the future. If you are running SQL Server 2008, you need to be on SQL Server 2008 Service Pack 3<\/a> (Build 10.0.5500) or newer, since all previous SQL Server 2008 Service Pack Levels have been retired and are considered \u201cunsupported service pack\u201d levels by Microsoft. SQL Server 2008 Service Pack 3 was released on October 6, 2011, which was quite some time ago.\u00a0 I made some arguments for staying current with Service Packs and Cumulative Updates here: Making the Case for Regular SQL Server Servicing<\/a><\/p>\n

Let\u2019s say you want some specific justification and ammunition for applying the latest SQL Server 2008 SP3 Cumulative Update, which is CU11 (Build 10.0.5840<\/a>), that was released on May 20, 2013. You could read the fix-lists for each cumulative update since SP3 RTM, available from this master CU list article from Microsoft:<\/p>\n

The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 3 was released<\/a><\/p><\/blockquote>\n

Or, you can start out with this filtered list (of Engine-related fixes) that I put together:<\/p>\n

SQL Server 2008 SP3 CU1<\/a> (10.0.5766) October 17, 2011<\/strong><\/p>\n

FIX: Recovery takes longer than expected for a database in a SQL Server 2008 or in a SQL Server 2008 R2 environment<\/a><\/p>\n

FIX: Assertion failure or other issues occur when you run a DML query against a table or view that has two indexes in SQL Server 2008 or in SQL Server 2008 R2<\/a><\/p>\n

FIX: Size of a data file that is committed by online page compression is larger than that is committed by offline page compression in SQL Server 2008 or in SQL Server 2008 R2<\/a><\/p>\n

FIX: High memory usage when you run Replication Snapshot Agent in SQL Server 2008 or in SQL Server 2008 R2<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU2<\/a> (10.0.5768) November 21, 2011<\/strong><\/p>\n

FIX: CLR stored procedure returns NULL after it is recompiled in SQL Server 2008 R2<\/a><\/p>\n

FIX: Access violation when you insert a record into a new empty partition in SQL Server 2008<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU3<\/a> (10.0.5770) January 16, 2012<\/strong><\/p>\n

FIX: Access violation when you run a DBCC CHECKDB command against a database that contains a table that has a spatial index in SQL Server 2008 or in SQL Server 2008 R2<\/a><\/p>\n

FIX: Access violation when a query is compiled or recompiled in SQL Server 2008 or in SQL Server 2008 R2<\/a><\/p>\n

FIX: It takes a long time to restore a database in SQL Server 2008 R2<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU4<\/a> (10.0.5775) March 19, 2012<\/strong><\/p>\n

FIX: “A time-out occurred while waiting for buffer latch” error when many transactions concurrently update a database in SQL Server 2008 R2 or in SQL Server 2008 if the database uses the snapshot isolation level<\/a><\/p>\n

FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2<\/a><\/p>\n

FIX: ghost_record_count values keep increasing in SQL Server 2008 R2 or in SQL Server 2008<\/a><\/p>\n

Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option<\/a><\/p>\n

FIX: Error message when you use DTA to tune one or more queries against a database that contains many objects in SQL Server 2008 R2 or in SQL Server 2008<\/a><\/p>\n

FIX: Backup operation fails on a SQL Server 2008 database after you enable change tracking<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU5<\/a> (10.0.5785) May 21, 2012<\/strong><\/p>\n

FIX: Slow performance when you restore a database in SQL Server 2008 R2 or in SQL Server 2008 if CDC is enabled<\/a><\/p>\n

FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU6<\/a> (10.0.5788) July 16, 2012<\/b><\/p>\n

FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2<\/a><\/p><\/blockquote>\n

FIX: SQL Server 2008 R2 or SQL Server 2008 stops responding and a \u201cNon-yielding Scheduler\u201d error is logged<\/a><\/p><\/blockquote>\n

FIX: Incorrect results are returned when you run a query that uses parallelism in the query execution plan in SQL Server 2008<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU7<\/a> (10.0.5794) September 17, 2012<\/b><\/p>\n

FIX: Error messages when you use dtexec to execute packages in SQL Server 2008 Integration Services<\/a><\/p><\/blockquote>\n

FIX: SQL Server Agent job fails if you set the job schedule type as \u201cStart automatically when SQL Server Agent starts\u201d in SQL Server 2008 SP2, SQL Server 2008 SP3 or SQL Server 2008 R2 SP2<\/a><\/p><\/blockquote>\n

FIX: Poor performance when you run a query that contains correlated AND predicates in SQL Server 2008 or in SQL Server 2008 R2 or in SQL Server 2012<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU8<\/a> (10.0.5828) November 19, 2012<\/b><\/p>\n

FIX: Memory leak if you enable the AUTO_UPDATE_STATISTICS_ASYNC statistics option in SQL Server 2008<\/a><\/p><\/blockquote>\n

FIX: Large queries that modify data run slower than expected when many locks accumulate in a SQL Server 2008 R2<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU9<\/a> (10.0.5829) January 21, 2013<\/strong><\/p>\n

FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU10<\/a> (10.0.5835) March 19, 2013<\/strong><\/p>\n

FIX: Access violation or incorrect result when you insert data into or update a new partition of a partitioned table in SQL Server 2008 R2 or SQL Server 2008<\/a><\/p>\n

FIX: Poor performance when table-valued functions use many table variables in SQL Server 2008 R2 or SQL Server 2008<\/a><\/p>\n

FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012<\/a><\/p>\n

FIX: Index size increases significantly after you rebuild the index online and RCSI is enabled in SQL Server 2008<\/a><\/p><\/blockquote>\n

SQL Server 2008 SP3 CU11<\/a> (10.0.5840) May 20, 2013<\/strong><\/p>\n

FIX: SQL Server may freeze when an instance of SQL Server 2012, SQL Server 2008 or SQL Server 2008 R2 is shut down<\/a><\/p>\n

FIX: Access Violation when you use a SQL profiler to trace an RPC event class in SQL Server 2008<\/a><\/p><\/blockquote>\n

Most of those hotfixes seem pretty significant to me (and this is just the Engine-related subset that I picked since Service Pack 3 RTM). I strongly encourage you to start reading the hotfix list when new cumulative updates are released, because there is a lot of good information there that may convince you and your organization to stay more current with your SQL Server Cumulative Updates. Keep in mind that SQL Server Cumulative Updates are actually cumulative, so if you install one, you will get all of the fixes for all of the previous Cumulative Updates for the Service Pack that you are on.<\/p>\n","protected":false},"excerpt":{"rendered":"

Even though there are two newer, major releases of SQL Server available, there are still many organizations running SQL Server 2008, which was a good, solid release of the product, with many improvements over SQL Server 2005. SQL Server 2008 (and SQL Server 2008 R2) are scheduled to fall out of mainstream support on July […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,26,29],"tags":[149],"class_list":["post-756","post","type-post","status-publish","format-standard","hentry","category-sql-server-cumulative-updates","category-sql-server-service-packs","category-sql-server-2008","tag-sql-server-2008-service-pack-3-cumulative-updates"],"yoast_head":"\n