SQL Server Cumulative Update

SQL Server Cumulative Update

Cumulative Update işlemini yapmadan önce bilinmesi gereken birkaç terim vardır.

1. Hotfix: Belirli bir konu üzerine yapılan iyileştirme ve değişiklik paketleridir.
2. Cumulative Update: Daha önce yayınlanmış olan hotfix paketlerinin roll mantığı ile derlenmiş halidir. Yani bir update'ler bütünüdür.

Cumulative Update'ler Microsoft tarafından belirli tarihlerde yayınlanmaktadır. Örnek olarak SQL Server 2014 SP 2 Cumulative Update 4 yayınlanmıştır.

https://support.microsoft.com/en-us/help/4010394/cumulative-update-4-for-sql-server-2014-sp2

Update İçerik Listesi:

9237344	3205935	FIX: Error 2809 when you execute a stored procedure that takes a table-valued parameter from RPC calls in SQL Server 2014	SQL performance
9237310	3067968	FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014	SQL service
9290829	4010162	FIX: A system assert occurs when a Transact-SQL stored procedure with a TVP argument is called from a SQLCLR procedure	SQL service
9097478	3212318	Cannot set database to partial containment if the database was ever a part of change tracking	SQL service
9237297	3030352	FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database	SQL service
9222228	4010344	FIX: The sp_msx_enlist stored procedure fails to enlist a target server into a master server in SQL Server 2014 if the server name is too long	Management Tools
9237320	3208244	FIX: Access Violation when you execute queries on a readable secondary replica of a SQL Server 2014 AlwaysOn Availability Group	SQL performance
9367820	3045321	MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 GDR: July 14, 2015	Reporting Services
9367851	3206912	FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks	Analysis Services
9368260	3211304	FIX: Error 5262 when you execute DBCC CHECKDB on the primary replica that contains repaired data pages in SQL Server 2012 or 2014	High Availability
9288607	3213703	FIX: An Always On secondary replica goes into a disconnecting state	High Availability
9237360	3208179	FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server 2014 Analysis Services	Analysis Services
8850850	3159748	FIX: Cannot connect to a named instance after failover on a mirror server in SQL Server 2016 or 2014	SQL connectivity
9295434	3212214	FIX: Fails to execute the DBCC CLONEDATABASE command on an in-place upgrade instance of SQL Server	SQL service
9237315	3196877	FIX: Incremental statistics runs with higher sample rate than regular statistics when statistics are created or updated in SQL Server 2014	SQL performance
9237338	3208245	FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014	SQL performance
9006268	4010500	FIX: Sys.dm_tran_commit_table DMV and CHANGETABLE function return incorrect results if SQL Server shuts down unexpectedly	SQL service
9227284	4010159	FIX: "Invoke-sqlcmd" cmdlet executes a query statement multiple times if an error occurs in SQL Server 2014	Management Tools
9367816	3212193	FIX: Cannot save the SSRS report after you change a parameter in Report Builder or the SQL Server Data Tool	Reporting Services
9367860	3025408	FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS	Analysis Services
9367825	3213240	FIX: Changing the data type and then updating the table with more than 4,000 records causes database corruption	SQL service
8981327	4009839	FIX: An MDX query returns incorrect results in SSAS 2014 Tabular mode	Analysis Services
9237349	3209442	FIX: "No Data Available" in the SQL Server Memory Usage page in the SQL Server 2014 MDM report	Management Tools
9316686	4010710	FIX: Memory leak occurs when you run a query that you don't have enough permissions in SQL Server 2014	SQL security
9325579	4010990	FIX: SQL Server is stopped when you install patches on an instance of SQL Server 2014 that contains many databases	Setup & Install