...
Bug Id | Summary | Last Updated | Read more |
---|---|---|---|
Bug Id | Summary | Last Updated | Read more |
---|---|---|---|
2830668 | Fixes a latch time-out issue that you encounter when fetching the next value for sequence objects, which is due to self-deadlock during lock escalation. | 2024-04-11 00:00:00 | Read more |
2877235 | Adds the following fields to the sqlserver.fulltext_filter_usage Extended Event (XEvent) to improve the telemetry reporting for the XEvent: - min_input_size - max_input_size - min_... | 2024-04-11 00:00:00 | Read more |
2884531 | Fixes an issue in which using the INSERT statement with the CAST or CONVERT function from a string representing negative zero to a decimal or numeric datatype succeeds, but you see... | 2024-04-11 00:00:00 | Read more |
2893029 | Fixes an issue in which the global primary or forwarder in a distributed availability group can't connect to the listener of the other availability group for a while after the loca... | 2024-04-11 00:00:00 | Read more |
2907885 | Fixes an issue that causes the SQL Server Agent to terminate with the following error message: Exception 5 caught at line <LineNumber> of file <FileName>. SQLServerAgent initiating... | 2024-04-11 00:00:00 | Read more |
2916485 | Adds a new advanced option 'max RPC request params (KB)' configured by using sp_configure to limit the maximum memory allocated for handling remote procedure call (RPC) request par... | 2024-04-11 00:00:00 | Read more |
2920065 | Fixes an issue in which an unreliable network connection causes an unsuccessful status during backup to a network share, which causes the SQL Server instance to stop responding. | 2024-04-11 00:00:00 | Read more |
2937228 | Fixes an issue in which error 18482 is caused when using sp_adddistributor to add a remote distributor if the Publisher server name contains lowercase characters and the Distributo... | 2024-04-11 00:00:00 | Read more |
2937599 | Fixes an issue in which the sp_server_diagnostics stored procedure doesn't respond to the Always On availability group (AG) resource DLL within the HealthCheckTimeout when the I/O ... | 2024-04-11 00:00:00 | Read more |
2945166 | Fixes an access violation caused by a race between a database and a parallel redo shutdown. | 2024-04-11 00:00:00 | Read more |
2950261 | Fixes the following SQL Server assertion failure: Error: 17065, Severity: 16, State: 1. Server Assertion: File: <FileName>, line = <LineNumber> Failed Assertion = 'false' Invalid c... | 2024-04-11 00:00:00 | Read more |
2958811 | Fixes an overflow issue of the word occurrence that you encounter during the full-text merging process. | 2024-04-11 00:00:00 | Read more |
2963638 | Fixes an assertion failure (Location: setypes.cpp:1274; Expression: !IsInRowDiff()) that you might encounter at FAILED_ASSERTION_42ac_sqlmin.dll!VersionRecPtr::IsNull when you have... | 2024-04-11 00:00:00 | Read more |
2963641 | Fixes an assertion failure (Location: setypes.cpp:1274; Expression: !IsInRowDiff()) that you might encounter at FAILED_ASSERTION_42ac_sqlmin.dll!VersionRecPtr::IsNull when you have... | 2024-04-11 00:00:00 | Read more |
2984804 | Fixes an issue in the lock manager that might cause random access violations and dumps on secondary replicas when the primary replica has 16 or more processors, and the secondary r... | 2024-04-11 00:00:00 | Read more |
3014264 | Limits the extra number of user tokens created by sys.sysprocesses or sys.dm_exec_requests by using trace flag 4673. | 2024-04-11 00:00:00 | Read more |
2936214 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-04-11 00:00:00 | Read more |
2936218 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-04-11 00:00:00 | Read more |
3004867 | KB4458880 - FIX: "9003 error, sev 20, state 1" error when a backup operation fails on a secondary replica that is running in asynchronous-commit mode - Microsoft Support | 2024-04-11 00:00:00 | Read more |
2950263 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-04-11 00:00:00 | Read more |
2941530 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-04-11 00:00:00 | Read more |
2347022 | Fixes an issue in which the automatic seeding operation for a database remains in LIMIT_CONCURRENT_BACKUPS after adding the database to a new availability group or an existing one ... | 2024-04-11 00:00:00 | Read more |
2693196 | Fixes the following errors that you encounter when using sp_addsubscription to create the Subscriber on secondary replicas if the distribution database is in an availability group:... | 2024-04-11 00:00:00 | Read more |
2290374 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2280423 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2369109 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2043012 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2292769 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2280420 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2042998 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
14654659 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
14066089 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
13643332 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
13590483 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
13526183 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
13441894 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
13345912 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
13303147 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2936186 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2938811 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2941532 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2936204 | KB4538581 - FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 - Microsoft Support | 2024-03-15 00:00:00 | Read more |
2153698 | Adds a link to error 824 to improve the troubleshooting experience. For more information, see MSSQLSERVER_824. Error Message: SQL Server detected a logical consistency-based I/O er... | 2024-03-14 00:00:00 | Read more |
2347023 | Fixes an issue in which the automatic seeding operation for a database remains in LIMIT_CONCURRENT_BACKUPS after adding the database to a new availability group or an existing one ... | 2024-03-14 00:00:00 | Read more |
2612953 | Fixes the following error that you encounter in conflict detection and in the Replication Merge Agent when converting the generation to int: Error converting data type bigint to in... | 2024-03-14 00:00:00 | Read more |
2693175 | Fixes the following errors that you encounter when using sp_addsubscription to create the Subscriber on secondary replicas if the distribution database is in an availability group:... | 2024-03-14 00:00:00 | Read more |
2695507 | Fixes inconsistent results that are caused by the parallel spool in the plan for the INSERT, UPDATE, or DELETE query. | 2024-03-14 00:00:00 | Read more |
2766481 | Fixes an access violation dump issue that you might encounter when resuming an index rebuild that includes partitions (for example, ALTER INDEX [index_name] ON [schema].[TableName]... | 2024-03-14 00:00:00 | Read more |
2768282 | Fixes an assertion failure (Location: "sql\\ntdbms\\storeng\\dfs\\trans\\PageFlush.cpp":1840; Expression: IS_OFF (BUF_LOG_BUFWRITE, buf->bstat) || IS_ON (BUF_DIRTY, buf->bstat) || ... | 2024-03-14 00:00:00 | Read more |
2804318 | Fixes an issue that might cause the database file to be associated with an incorrect filegroup in the clone database created by using DBCC CLONEDATABASE. | 2024-03-14 00:00:00 | Read more |
2820084 | Fixes a non-yielding scheduler issue due to spinlock contention on the Redo Manager on secondary replicas of an availability group. | 2024-03-14 00:00:00 | Read more |
2824982 | Prevents the creation of read-scale availability groups that have a large number of databases to avoid the subsequent assertion failure (Location: ucsconnectionsend.cpp:103; Expres... | 2024-03-14 00:00:00 | Read more |
2830811 | Adds trace flag 2616 to enable the stack signature feature when a dump occurs on a SQL Server instance, which avoids multiple dumps for the same exception. | 2024-03-14 00:00:00 | Read more |
2833605 | Adds mitigation to avoid an assertion failure (Location: lobss.cpp:707; Expression: 'FALSE' Lob not found for read) that you might encounter when you run a complex query that uses ... | 2024-03-14 00:00:00 | Read more |
2837848 | Fixes a deadlock issue that you encounter when creating or updating statistics by turning off the blocking Auto Stats feature. The blocking Auto Stats feature is turned on when you... | 2024-03-14 00:00:00 | Read more |
2845380 | Removes the following incorrect error that's related to ca-certificates when starting SQL Server on Linux: Error searching first file in /var/opt/mssql/security/ca-certificates | 2024-03-14 00:00:00 | Read more |
2846022 | Fixes an issue in which a Volume Shadow Copy Service (VSS) restore process with the Restore with Move feature might restore an incorrect file or fail if the file path for the .mdf ... | 2024-03-14 00:00:00 | Read more |
2850899 | Fixes a potential process termination issue that you might encounter when an adhoc query that uses the binary large object (BLOB) encounters an error and tries to clean up during t... | 2024-03-14 00:00:00 | Read more |
2850915 | Fixes race conditions in which certain variables aren't initialized correctly when a batch mode sort query is aborted, which causes an access violation and INVALID_POINTER_READ_c00... | 2024-03-14 00:00:00 | Read more |
2850932 | Fixes an access violation exception that you encounter at sqlmin!CBpXteHashJoin::FSeparateHash when you try to run a query that involves an Adaptive Join (CONCAT) operator in the q... | 2024-03-14 00:00:00 | Read more |
2859818 | Fixes an issue that might cause a recursive hierarchy to fail to load all levels. | 2024-03-14 00:00:00 | Read more |
2860396 | Fixes an access violation that you might encounter when adding or deleting an empty partition with row-level security (RLS) on a table. | 2024-03-14 00:00:00 | Read more |
2864330 | Fixes an issue in which overriding the MakeGenerationInterval parameter that uses a custom value doesn't work properly when you run replmerg.exe. | 2024-03-14 00:00:00 | Read more |
2864688 | Fixes an issue in which running Data Analysis Expressions (DAX) queries failed with error "Memory Allocation failure" even though the SQL Server Analysis Services instance still ha... | 2024-03-14 00:00:00 | Read more |
2868247 | Fixes an issue in which an upgrade process in Master Data Services models might fail if you set an inappropriate entity name such as "Entity". | 2024-03-14 00:00:00 | Read more |
2870454 | Fixes an issue in which the sp_helpsubscription stored procedure doesn't return any results after an in-place upgrade of the Publisher instance to SQL Server 2022, which causes you... | 2024-03-14 00:00:00 | Read more |
2870518 | Fixes an issue in which the size of the _$update_bitmap column of dbo.conflict_<owner>_<table> doesn't get updated with changes in the number of columns of the original conflicting... | 2024-03-14 00:00:00 | Read more |
2870726 | Fixes an issue in which the exported delimited text file created by using CREATE EXTERNAL TABLE AS SELECT (CETAS) is incorrect if the FIELD_TERMINATOR character is '\t'. | 2024-03-14 00:00:00 | Read more |
2877337 | Adds the following fields to the sqlserver.fulltext_filter_usage Extended Event (XEvent) to improve the telemetry reporting for the XEvent: - min_input_size - max_input_size - min_... | 2024-03-14 00:00:00 | Read more |
2888483 | Fixes a performance degradation that might be encountered during the execution of the ProcessAdd command, which causes an increase in CPU usage and execution time. | 2024-03-14 00:00:00 | Read more |
2890724 | Fixes an issue that you encounter when references to plan cache entries become dereferenced in memory without allowing the plans to be properly removed from memory. This issue migh... | 2024-03-14 00:00:00 | Read more |
2893030 | Fixes an issue in which the global primary or forwarder in a distributed availability group can't connect to the listener of the other availability group for a while after the loca... | 2024-03-14 00:00:00 | Read more |
2899892 | Makes the following improvements to the compressed memory dump feature: - Adds the use of the FILE_FLAG_NO_BUFFERING flag to improve I/O performance and prevent excessive growth of... | 2024-03-14 00:00:00 | Read more |
2907888 | Fixes an issue that causes the SQL Server Agent to terminate with the following error message: Exception 5 caught at line <LineNumber> of file <FileName>.SQLServerAgent initiating ... | 2024-03-14 00:00:00 | Read more |
2914479 | Fixes a contention issue that you encounter when using sys.dm_exec_query_statistics_xml from multiple concurrent connections. | 2024-03-14 00:00:00 | Read more |
2916821 | Fixes an access violation that you encounter when a Plan Cache object type differs from what Cardinality Estimation (CE) feedback expects. In this scenario, CE feedback casts the o... | 2024-03-14 00:00:00 | Read more |
2920073 | Fixes an issue in which an unreliable network connection causes an unsuccessful status during backup to a network share, which causes the SQL Server instance to stop responding. | 2024-03-14 00:00:00 | Read more |
2920697 | Fixes an issue in which the SQLdiag tool doesn't start when trying to read the default XML configuration file. Additionally, you receive the following error message: <DateTime> SQL... | 2024-03-14 00:00:00 | Read more |
2923126 | Fixes an issue that you encounter in sys.dm_hadr_database_replica_cluster_states for read-scale availability groups after you install SQL Server 2022 CU10 or later versions, which ... | 2024-03-14 00:00:00 | Read more |
2929215 | Fixes an issue in which error 18482 is caused when using sp_adddistributor to add a remote distributor if the Publisher server name contains lowercase characters and the Distributo... | 2024-03-14 00:00:00 | Read more |
2937200 | Fixes an issue in which running Delta table queries requires the sysadmin server role. For more information, see Delta table query may fail with errors 2571 and 16513. | 2024-03-14 00:00:00 | Read more |
2937584 | Fixes an issue in which the sp_server_diagnostics stored procedure doesn't respond to the Always On availability group (AG) resource DLL within the HealthCheckTimeout when the I/O ... | 2024-03-14 00:00:00 | Read more |
2956541 | Before the improvement, a generic error message (configuration error during initialization) is reported when creating an event_file target for an Extended Events session if the Azu... | 2024-03-14 00:00:00 | Read more |
2961007 | Fixes an out-of-memory (OOM) issue that's caused by spikes in CACHESTORE_PHDR usage. | 2024-03-14 00:00:00 | Read more |
2969541 | Adds the support of the Extensible Key Management (EKM) feature for SQL Server on Linux. | 2024-03-14 00:00:00 | Read more |
2955111 | Improvement: Add new collations that comply with the GB18030-2022 standard | 2024-03-14 00:00:00 | Read more |
2918853 | Improvement: Add new collations that comply with the GB18030-2022 standard | 2024-03-14 00:00:00 | Read more |
2153707 | Adds a link to error 824 to improve the troubleshooting experience. For more information, see MSSQLSERVER_824. Error Message: SQL Server detected a logical consistency-based I/O er... | 2024-02-15 00:00:00 | Read more |
2165090 | Fixes an issue in which the size of the _$update_bitmap column of dbo.conflict_<owner>_<table> doesn't get updated with changes in the number of columns of the original conflicting... | 2024-02-15 00:00:00 | Read more |
2343632 | Fixes an assertion failure (Location: ucsconnectionsend.cpp:103; Expression: 'm_pcscBoxcar->GetMessageCount () > 0') that you might encounter when a clusterless Always On availabil... | 2024-02-15 00:00:00 | Read more |
2612943 | Fixes the following error that you encounter in conflict detection and in the Replication Merge Agent when converting the generation to int: Error converting data type bigint to in... | 2024-02-15 00:00:00 | Read more |
2686243 | Fixes an issue in which the sp_helpsubscription stored procedure doesn't return any results after an in-place upgrade of the Publisher instance to SQL Server 2019, which causes you... | 2024-02-15 00:00:00 | Read more |
2820559 | Fixes an issue in which a Volume Shadow Copy Service (VSS) restore process with the Restore with Move feature might restore an incorrect file or fail if the file path for the .mdf ... | 2024-02-15 00:00:00 | Read more |
2833604 | Adds mitigation to avoid an assertion failure (Location: lobss.cpp:707; Expression: 'FALSE' Lob not found for read) that you might encounter when you run a complex query that uses ... | 2024-02-15 00:00:00 | Read more |
2842754 | Fixes an issue that might cause a recursive hierarchy to fail to load all levels. | 2024-02-15 00:00:00 | Read more |
2842801 | Fixes an issue in which an upgrade process in Master Data Services models might fail if you set an inappropriate entity name such as "Entity". | 2024-02-15 00:00:00 | Read more |
2843374 | Fixes a deadlock issue that you encounter when creating or updating statistics by turning off the blocking Auto Stats feature. The blocking Auto Stats feature is turned on when you... | 2024-02-15 00:00:00 | Read more |
2888485 | Fixes a performance degradation that might be encountered during the execution of the ProcessAdd command, which causes an increase in CPU usage and execution time. | 2024-02-15 00:00:00 | Read more |
2922937 | Makes the following improvements to the compressed memory dump feature: - Adds the use of the FILE_FLAG_NO_BUFFERING flag to improve I/O performance and prevent excessive growth of... | 2024-02-15 00:00:00 | Read more |
2926845 | Fixes an issue that you encounter in sys.dm_hadr_database_replica_cluster_states for read-scale availability groups after you install SQL Server 2019 CU24 or later versions, which ... | 2024-02-15 00:00:00 | Read more |
2932327 | Fixes an issue that might cause the database file to be associated with an incorrect filegroup in the clone database created by using DBCC CLONEDATABASE. | 2024-02-15 00:00:00 | Read more |
1982808 | Fixes an issue in which the distribution agent fails when you set up transactional replication with memory-optimized tables at the Subscriber that has the "replication support only... | 2024-01-11 00:00:00 | Read more |
2702535 | Fixes an access violation at InitCollationSensitiveLookupHash that you encounter when running a string column point search on an In-Memory OLTP columnstore table. | 2024-01-11 00:00:00 | Read more |
2710571 | Fixes an issue in which the creation of a contained availability group fails with a dump generated if a login has the sysadmin role and some other server-level roles that only exis... | 2024-01-11 00:00:00 | Read more |
2724957 | Fixes an issue in which the setup might fail to add the SQL_SNAC_SDK feature when you install SQL Server if the machine has a later version of the SQL_SNAC_CORE feature in msoledbs... | 2024-01-11 00:00:00 | Read more |
2744933 | Fixes a non-yielding scheduler dump issue with sqldk!SOS_Node::SpreadMultipleTasksAcrossNodes that you encounter when running an instance on hardware that has more than 64 logical ... | 2024-01-11 00:00:00 | Read more |
2765109 | Fixes a performance issue in query execution time that you encounter after you run the OPTIMIZE operation for a delta table in S3-compatible object storage. After applying the fix,... | 2024-01-11 00:00:00 | Read more |
2766490 | Fixes an intra-query deadlock that you might encounter when running some query plans that involve nested loop joins in batch mode. | 2024-01-11 00:00:00 | Read more |
2766491 | Fixes an access violation dump issue that you encounter when dropping a distributed availability group (AG) that has a suspect AG database on a forwarder. | 2024-01-11 00:00:00 | Read more |
2767578 | Fixes an issue in which the Find Parent feature fails if the target of the feature is a node that is searched. | 2024-01-11 00:00:00 | Read more |
2770546 | Fixes an assertion failure (Location: IntSafeWrapperRetail.cpp:31; Expression: !"Arithmetic operation failed") that you encounter while using the LIKE predicate. | 2024-01-11 00:00:00 | Read more |
2773751 | Fixes an issue in which downloading an attachment fails if an entity newly created uses a code value existing in a deletion record. | 2024-01-11 00:00:00 | Read more |
2782283 | Consider the following scenario: - You create a table that has a full-text index. - The full-text index fragment is partitioned because it's too large. - You clone the database and... | 2024-01-11 00:00:00 | Read more |
2782340 | Fixes a "Stalled Resource Monitor" dump issue that you might encounter after out-of-memory (OOM) exceptions are raised, such as error 701. | 2024-01-11 00:00:00 | Read more |
2787964 | Fixes an issue in which the Cardinality Estimation (CE) feedback generates an empty USE HINT clause as the query hint. | 2024-01-11 00:00:00 | Read more |
2789527 | Fixes the following error 9833 that you encounter when running the sp_helplogins stored procedure against a database with UTF-8 character encoding: Msg 9833, Level 16, State 2, Pro... | 2024-01-11 00:00:00 | Read more |
2807414 | Fixes a dump issue and INVALID_POINTER_WRITE_c0000005_sqllang.dll!CBatch::PTaskGetWithAddRef exception that you might encounter when the reference on a connection object that's obt... | 2024-01-11 00:00:00 | Read more |
2606385 | Updates the errors 1101 and 1105 to explicitly reflect the fact that even UNLIMITED database files are limited to 16 TB. Error message: 1101: Could not allocate a new page for data... | 2023-12-14 00:00:00 | Read more |
2672219 | Fixes an issue in which overriding the MakeGenerationInterval parameter that uses a custom value doesn't work properly when you run replmerg.exe. | 2023-12-14 00:00:00 | Read more |
2714260 | Fixes unexpected characters that you encounter in the name column of the sys.availability_groups_cluster dynamic management view (DMV) when you use the read-scale availability grou... | 2023-12-14 00:00:00 | Read more |
2724959 | Fixes an issue in which the setup might fail to add the SQL_SNAC_SDK feature when you install SQL Server if the machine has a later version of the SQL_SNAC_CORE feature in msoledbs... | 2023-12-14 00:00:00 | Read more |
2726326 | Fixes an assertion failure (Location: "cxrowset.cpp":2006; Expression: cstePrefix >= 1) that you encounter when updating statistics fails with the following error: Msg 3624, Level ... | 2023-12-14 00:00:00 | Read more |
2736124 | Adds additional telemetry to the security caches to improve the debuggability. | 2023-12-14 00:00:00 | Read more |
2763676 | Fixes an issue in which running sys.dm_db_xtp_transactions might fail with the following error if a large number of transactions are in the In-Memory OLTP database engine: Msg 701,... | 2023-12-14 00:00:00 | Read more |
2783439 | Consider the following scenario: - You create a table that has a full-text index. - The full-text index fragment is partitioned because it's too large. - You clone the database and... | 2023-12-14 00:00:00 | Read more |
2789529 | Fixes the following error 9833 that you encounter when running the sp_helplogins stored procedure against a database with UTF-8 character encoding: Msg 9833, Level 16, State 2, Pro... | 2023-12-14 00:00:00 | Read more |
2795899 | Fixes an issue in which the Find Parent feature fails if the target of the feature is a node that is searched. | 2023-12-14 00:00:00 | Read more |
2802020 | Fixes an issue in which downloading an attachment fails if an entity newly created uses a code value existing in a deletion record. | 2023-12-14 00:00:00 | Read more |
2814458 | Fixes an issue in which the distribution agent fails when you set up transactional replication with memory-optimized tables at the Subscriber that has the "replication support only... | 2023-12-14 00:00:00 | Read more |
2606378 | Updates the errors 1101 and 1105 to explicitly reflect the fact that even UNLIMITED database files are limited to 16 TB. Error message: 1101: Could not allocate a new page for data... | 2023-11-16 00:00:00 | Read more |
2645943 | Fixes an issue in which running sys.dm_db_xtp_transactions might fail with the following error if a large number of transactions are in the In-Memory OLTP database engine: Msg 701,... | 2023-11-16 00:00:00 | Read more |
2695485 | Fixes the following error that you encounter on the target instance when configuring a Service Broker communication with transport security and the certificate serial number length... | 2023-11-16 00:00:00 | Read more |
2698036 | The Log Reader Agent creates a dynamic linked server for the listener to verify the metadata when you configure a transactional publication on an Always On availability group (AG).... | 2023-11-16 00:00:00 | Read more |
2712771 | Fixes an issue in which the exported delimited text file always uses a comma (',') as the field terminator when you use CREATE EXTERNAL TABLE AS SELECT (CETAS) to export data to a ... | 2023-11-16 00:00:00 | Read more |
2714261 | Fixes unexpected characters that you encounter in the name column of the sys.availability_groups_cluster dynamic management view (DMV) when you use the read-scale availability grou... | 2023-11-16 00:00:00 | Read more |
2726328 | Fixes an assertion failure (Location: "cxrowset.cpp":2006; Expression: cstePrefix >= 1) that you encounter when updating statistics fails with the following error: Msg 3624, Level ... | 2023-11-16 00:00:00 | Read more |
2732520 | Before this update, in some rare cases, if IDENTITY_INSERT is set to ON, the identity value for the target table is set to the highest value in the source table when joining tables... | 2023-11-16 00:00:00 | Read more |
2751378 | Fixes an access violation dump issue that you encounter when you run a query on the clustered columnstore table that uses the READPAST hint. | 2023-11-16 00:00:00 | Read more |
12519856 | KB4470057 - FIX: Error 41168 occurs when you try to alter DAG SEEDING_MODE in SQL Server 2016 and 2017 - Microsoft Support | 2023-11-10 00:00:00 | Read more |
12129434 | KB4134601 - FIX: "Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClientUI'" error when a "Process Full" operation is run in SQL Server - Microsoft Support | 2023-10-20 00:00:00 | Read more |
11853504 | KB4134601 - FIX: "Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClientUI'" error when a "Process Full" operation is run in SQL Server - Microsoft Support | 2023-10-20 00:00:00 | Read more |
2450865 | Fixes an issue in which the following assertion failure occurs while you try to restore a database to a disk with insufficient storage, which causes the SQL Server instance to stop... | 2023-10-12 00:00:00 | Read more |
2499342 | Fixes an issue in which the plan cache entry is evicted when the Cardinality Estimation (CE) feedback tries to get the associated profile, which causes a memory corruption. | 2023-10-12 00:00:00 | Read more |
2499352 | Updates the SQDSFeedbackEEFunctors constructor to prevent race conditions, which can cause double deletion during the construction. | 2023-10-12 00:00:00 | Read more |
2518729 | Fixes an issue in which an INSERT (or any Data Manipulation Language (DML)) statement is blocked if you run the statement before a clustered columnstore index (CCI) online rebuild ... | 2023-10-12 00:00:00 | Read more |
2557526 | Fixes an access violation issue that occurs when removing the database snapshot files on the readable secondary replica of an Always On availability group that has the buffer pool ... | 2023-10-12 00:00:00 | Read more |
2557571 | This improvement adds Extended Events functionality to enhance the periodic primary replica to secondary replica notification investigation in availability groups for an in-memory ... | 2023-10-12 00:00:00 | Read more |
2602744 | Fixes an issue that you encounter in the following scenario: - Configure the "Replication: agent custom shutdown" alert to respond to error 20578. - Run sp_publication_validation w... | 2023-10-12 00:00:00 | Read more |
2614104 | Fixes an issue in which the Snapshot Agent incorrectly generates the script of the XXX_msrepl_ccs stored procedure if @sync_method is concurrent, and replication stored procedures ... | 2023-10-12 00:00:00 | Read more |
2627571 | Enables the JSON_ARRAY and JSON_OBJECT functions by default in SQL Server 2022. | 2023-10-12 00:00:00 | Read more |
2630696 | Fixes an issue in which restoring a transaction log backup to the specific point in time fails with the following error: Msg 9003, Level 20, State 9, Line <LineNumber> The log scan... | 2023-10-12 00:00:00 | Read more |
2636294 | Fixes an issue in which the cardinality estimation (CE) uniformly increases after each LEFT JOIN or RIGHT JOIN combines, which causes overestimation. This fix adds a limitation to ... | 2023-10-12 00:00:00 | Read more |
2636302 | Fixes an access violation that may be encountered when querying the sys.dm_os_memory_objects dynamic management view (DMV). | 2023-10-12 00:00:00 | Read more |
2641756 | The RemoveDiscontinuedFeatures command that has the EnsureProperEncryption option is extended to support multidimensional model databases. For more information, see Multidimensiona... | 2023-10-12 00:00:00 | Read more |
2644031 | Improves Data Definition Language (DDL) performance to create a large number of tables and partitions when the number of databases on a SQL Server instance exceeds 100. | 2023-10-12 00:00:00 | Read more |
2654343 | Fixes an issue in which you search for a specific node and then fail to expand the node on the hierarchy page. | 2023-10-12 00:00:00 | Read more |
2659494 | An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. | 2023-10-12 00:00:00 | Read more |
2659495 | Updates the version of the Microsoft ODBC driver to 17.10.5.1. For more information, see Release Notes for Microsoft ODBC Driver for SQL Server on Windows. | 2023-10-12 00:00:00 | Read more |
2659497 | Updates the version of the Microsoft OLE DB driver to 18.6.7. For more information, see Release notes for the Microsoft OLE DB Driver for SQL Server. | 2023-10-12 00:00:00 | Read more |
2668476 | Fixes an assertion failure (Location: setypes.cpp:1274; Expression: !IsInRowDiff()) that you might encounter at FAILED_ASSERTION_42ac_sqlmin.dll!VersionRecPtr::IsNull when you have... | 2023-10-12 00:00:00 | Read more |
2668765 | Reduces the overall size of Ubuntu-based SQL Server container images. | 2023-10-12 00:00:00 | Read more |
2670876 | Updates the Pacemaker agent code to support Red Hat Enterprise Linux (RHEL) 9 and Ubuntu 22. | 2023-10-12 00:00:00 | Read more |
2674316 | Fixes error 207 (Invalid column name '<ColumnName>') that you encounter when you run a user-defined function (UDF), which references a dropped column that uses data classification. | 2023-10-12 00:00:00 | Read more |
2675548 | Fixes an error that you encounter when reading some .XEL files by using sys.fn_MSxe_read_event_stream. | 2023-10-12 00:00:00 | Read more |
2681462 | Fixes the incorrect results that you encounter when you use JSON_ARRAY or JSON_OBJECT as a default column during the table creation. | 2023-10-12 00:00:00 | Read more |
2683132 | Fixes an assertion failure (Location: setypes.cpp:1274; Expression: !IsInRowDiff()) that you might encounter at FAILED_ASSERTION_42ac_sqlmin.dll!VersionRecPtr::IsNull when you have... | 2023-10-12 00:00:00 | Read more |
2690500 | Fixes an issue in Cardinality Estimation (CE) feedback involving uninitialized variables in PStmtGetSafe. | 2023-10-12 00:00:00 | Read more |
1992459 | Fixes an issue in which restoring a transaction log backup to the specific point in time fails with the following error: Msg 9003, Level 20, State 9, Line <LineNumber> The log scan... | 2023-10-12 00:00:00 | Read more |
2374314 | Fixes an issue in which an INSERT (or any Data Manipulation Language (DML)) statement is blocked if you run the statement before a clustered columnstore index (CCI) online rebuild ... | 2023-10-12 00:00:00 | Read more |
2529767 | Improves Data Definition Language (DDL) performance to create a large number of tables and partitions when the number of databases on a SQL Server instance exceeds 100. | 2023-10-12 00:00:00 | Read more |
2567537 | Fixes an issue in which an availability group that has database level health detection enabled triggers needless failover for the following error 1105 when data files reach the lim... | 2023-10-12 00:00:00 | Read more |
2584049 | Enables IO error mode history in retail builds by using trace flag 3139 to allow the investigation of the assertion failure (Location: readEncoded.cpp:2988; Expression: m_pDecodeSp... | 2023-10-12 00:00:00 | Read more |
2590045 | Fixes an issue in which the dynamic snapshot fails with the error "Arithmetic overflow error converting expression to data type int" in the partition_id_eval_proc column when you t... | 2023-10-12 00:00:00 | Read more |
2593704 | Fixes an issue that you encounter when selecting other non-entity nodes after selecting an entity node in Master Data Services models. | 2023-10-12 00:00:00 | Read more |
2602743 | Fixes an issue that you encounter in the following scenario: - Configure the "Replication: agent custom shutdown" alert to respond to error 20578. - Run sp_publication_validation w... | 2023-10-12 00:00:00 | Read more |
2614095 | Fixes an issue in which the Snapshot Agent incorrectly generates the script of the XXX_msrepl_ccs stored procedure if @sync_method is concurrent, and replication stored procedures ... | 2023-10-12 00:00:00 | Read more |
2614132 | Fixes a potential process termination issue that you might encounter when an adhoc query that uses the binary large object (BLOB) encounters an error and tries to clean up during t... | 2023-10-12 00:00:00 | Read more |
2621966 | Fixes the following error 2570 that you encounter when you run DBCC CHECKDB against a database, which is caused by using negative parameters in the RANDOM function against a column... | 2023-10-12 00:00:00 | Read more |
2633609 | An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. | 2023-10-12 00:00:00 | Read more |
2633976 | Updates the version of the Microsoft ODBC driver to 17.10.5.1. For more information, see Release Notes for Microsoft ODBC Driver for SQL Server on Windows. | 2023-10-12 00:00:00 | Read more |
2633979 | Updates the version of the Microsoft OLE DB driver to 18.6.7. For more information, see Release notes for the Microsoft OLE DB Driver for SQL Server. | 2023-10-12 00:00:00 | Read more |
2639915 | Adds a compressed memory dump feature that helps create a compressed memory stream to replace the conventional memory stream to speed up the dump process and reduce the size of the... | 2023-10-12 00:00:00 | Read more |
2640296 | Fixes an issue in which SQL Server continues to generate new dump files when the dump file size is larger than 2 gigabytes (GB). | 2023-10-12 00:00:00 | Read more |
2646148 | Fixes inconsistent results that you encounter when you use Read Committed Snapshot Isolation (RCSI) and the full-text index doesn't pick up the updated data in an incremental crawl... | 2023-10-12 00:00:00 | Read more |
2647396 | Fixes race conditions in which certain variables aren't initialized correctly when a batch mode sort query is aborted, which causes an access violation and INVALID_POINTER_READ_c00... | 2023-10-12 00:00:00 | Read more |
2651628 | Starting in SQL Server 2019 CU23, Azul Java is no longer available, and the Microsoft Build of OpenJDK 11 is provided instead. | 2023-10-12 00:00:00 | Read more |
2654352 | Fixes an issue in which you search for a specific node and then fail to expand the node on the hierarchy page. | 2023-10-12 00:00:00 | Read more |
2674865 | Fixes error 207 (Invalid column name '<ColumnName>') that you encounter when you run a user-defined function (UDF), which references a dropped column that uses data classification. | 2023-10-12 00:00:00 | Read more |
2690338 | Before this update, in some rare cases, if IDENTITY_INSERT is set to ON, the identity value for the target table is set to the highest value in the source table when joining tables... | 2023-10-12 00:00:00 | Read more |
2693198 | Fixes an access violation exception that you encounter at sqlmin!CBpXteHashJoin::FSeparateHash when you try to run a query that involves an Adaptive Join (CONCAT) operator in the q... | 2023-10-12 00:00:00 | Read more |
2746708 | Starting in SQL Server 2019 CU23, Azul Java is no longer available, and the Microsoft Build of OpenJDK 11 is provided instead. | 2023-10-12 00:00:00 | Read more |
2655660 | An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. | 2023-10-10 00:00:00 | Read more |
2555349 | An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. | 2023-10-10 00:00:00 | Read more |
2562145 | An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. | 2023-10-10 00:00:00 | Read more |
2555117 | An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. | 2023-10-10 00:00:00 | Read more |
2555112 | An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. | 2023-10-10 00:00:00 | Read more |
2555109 | An attacker can send a malformed TDS (Tabular Data Stream) packet that causes a login failure, unavailability, or other undefined behavior. | 2023-10-10 00:00:00 | Read more |
2464304 | Fixes an issue in which the Query Store (QDS) cleanup task doesn't clean up statistics. Before applying the fix, the QDS size keeps growing when you keep running more workloads unt... | 2023-09-14 00:00:00 | Read more |
2519092 | Fixes an issue in which the dynamic snapshot fails with the error "Arithmetic overflow error converting expression to data type int" in the partition_id_eval_proc column when you t... | 2023-09-14 00:00:00 | Read more |
2557552 | Fixes error 692 that occurs when you create a non-clustered index under the following scenario: - A clustered index already exists in the table. - You create a non-clustered index ... | 2023-09-14 00:00:00 | Read more |
2567536 | Fixes an issue in which an availability group that has database level health detection enabled triggers needless failover for the following error 1105 when data files reach the lim... | 2023-09-14 00:00:00 | Read more |
2583619 | Provides the details of the corrupt checkpoint file that's associated with the in-memory database when you try to restore a database but it fails with the following error: [ERROR] ... | 2023-09-14 00:00:00 | Read more |
2584051 | Enables IO error mode history in retail builds by using trace flag 3139 to allow the investigation of the assertion failure (Location: readEncoded.cpp:2988; Expression: m_pDecodeSp... | 2023-09-14 00:00:00 | Read more |
2587977 | Fixes the error "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it" that you encounter when performing an in-plac... | 2023-09-14 00:00:00 | Read more |
2591508 | Adds a compressed memory dump feature that helps create a compressed memory stream to replace the conventional memory stream to speed up the dump process and reduce the size of the... | 2023-09-14 00:00:00 | Read more |
2595013 | Fixes an issue in which the log shipping backup fails with the error "Could not retrieve backup settings for primary ID" when you upgrade a SQL Server instance that has a log shipp... | 2023-09-14 00:00:00 | Read more |
2603906 | Fixes an issue that you encounter when selecting other non-entity nodes after selecting an entity node in Master Data Services models. | 2023-09-14 00:00:00 | Read more |
2606680 | Fixes the following error 2570 that you encounter when you run DBCC CHECKDB against a database, which is caused by using negative parameters in the RANDOM function against a column... | 2023-09-14 00:00:00 | Read more |
11008401 | KB4035062 - FIX: Memory use with many databases in SQL Server 2017 or 2016 is greater than in earlier versions - Microsoft Support | 2023-08-29 00:00:00 | Read more |
11057322 | KB4052134 - FIX: Errors 33111 and 3013 when backing up TDE-encrypted database in SQL Server - Microsoft Support | 2023-08-28 00:00:00 | Read more |
1999783 | Fixes an access violation in sqllang!FReadDataDirect that you encounter during network exchanges between an instance of SQL Server and a client. | 2023-08-14 00:00:00 | Read more |
2111946 | Increases the threshold for the number of OR clauses that can be converted to Index Union plans. | 2023-08-14 00:00:00 | Read more |
2126481 | Fixes a dump issue that you may encounter when resuming an index rebuild that includes partitions. | 2023-08-14 00:00:00 | Read more |
2330261 | Fixes an assertion dump issue (Location: sebind.h:1206; Expression: bufferLen >= colLen) that you encounter when running an INSERT statement against the table that has the nvarchar... | 2023-08-14 00:00:00 | Read more |
2332831 | Fixes an issue in which running DBCC CHECKTABLE may create snapshot files, even if a user fails the table-level permission check. | 2023-08-14 00:00:00 | Read more |
2355421 | Fixes an intra-query deadlock that you might encounter when running some query plans that involve nested loop joins in batch mode. | 2023-08-14 00:00:00 | Read more |
2387353 | Fixes an access violation dump issue that you encounter when dropping a distributed availability group (AG) that has a suspect AG database on a forwarder. | 2023-08-14 00:00:00 | Read more |
2434847 | Fixes an issue in which a thread deadlock between Query Store (QDS) background tasks blocks the database shutdown. | 2023-08-14 00:00:00 | Read more |
2445012 | Fixes an issue in which an alias error occurs during a database upgrade if you apply the name "en" to an attribute. | 2023-08-14 00:00:00 | Read more |
2460204 | Fixes an issue caused by a change introduced in SQL Server 2019 CU20 for the Managed Instance link feature. For more information, see Issue three. | 2023-08-14 00:00:00 | Read more |
2469366 | Fixes an issue in which the validation of a custom input mask fails. After applying this fix, you can use a custom input mask with the time part. | 2023-08-14 00:00:00 | Read more |
2472432 | Enables trace flag 9135 (TRCFLG_QP_DONT_USE_INDEXED_VIEWS) in retail builds to allow the EXPAND VIEWS behavior without the per-query hint. | 2023-08-14 00:00:00 | Read more |
2491017 | Fixes an issue in which running sp_change_users_login reports the following error if the database collation is Chinese_PRC_CI_AS: Msg 9833, Level 16, State 3, Line <LineNumber> Inv... | 2023-08-14 00:00:00 | Read more |
2491768 | Fixes an issue in which the number of the Log Writer threads is inconsistent when the SQL Server instance is affinitized to a subset of NUMA nodes. | 2023-08-14 00:00:00 | Read more |
2497934 | Fixes a latch time-out issue that you might encounter in the ghost cleanup process or version cleaner when there's a long chain of Index Allocation Map (IAM) pages for a table. | 2023-08-14 00:00:00 | Read more |
2504040 | Fixes a stack overflow in HaDrUndoMgr::InitSystemPages that's caused by a loop getting all the Page Free Space (PFS) pages from the primary availability group. | 2023-08-14 00:00:00 | Read more |
2506723 | Improves sp_addpublication_snapshot by exposing additional parameters (@distributor_security_mode, @distributor_login, and @distributor_password). With these parameters, you can co... | 2023-08-14 00:00:00 | Read more |
2517054 | Fixes an issue in which you can't see the Created By and Updated By fields in the View History window when you use the Master Data Services (MDS) Add-in for Excel. | 2023-08-14 00:00:00 | Read more |
2518620 | Fixes an issue in which an error may occur when you download an attachment uploaded previously in a Master Data Services model. | 2023-08-14 00:00:00 | Read more |
2555121 | Fixes an issue in which a pointer is outside the empty result buffer when the output of CONCAT_WS is empty. This fix adds a check for the empty result before doing the pointer arit... | 2023-08-14 00:00:00 | Read more |
1550865 | Fixes an issue in which the BACKUP or RESTORE statement doesn't time out even after a long time when the S3 server is unreachable or the hostname/IP address/port number that's give... | 2023-08-10 00:00:00 | Read more |
2337613 | Fixes an issue in which running DBCC CHECKTABLE may create snapshot files, even if a user fails the table-level permission check. | 2023-08-10 00:00:00 | Read more |
2423760 | Fixes the following SQL Server assertion failure: Error: 17065, Severity: 16, State: 1. Server Assertion: File: <typinfo.cpp>, line = 1153 Failed Assertion = 'false' Invalid compar... | 2023-08-10 00:00:00 | Read more |
2458680 | Fixes a manual cleanup issue in which the repeated lock escalations on the tables cause contention and slowness in cleaning up the expired change tracking metadata. Note: You need ... | 2023-08-10 00:00:00 | Read more |
2469661 | Fixes an issue in which the validation of a custom input mask fails. After applying this fix, you can use a custom input mask with the time part. | 2023-08-10 00:00:00 | Read more |
2491020 | Fixes an issue in which running sp_change_users_login reports the following error if the database collation is Chinese_PRC_CI_AS: Msg 9833, Level 16, State 3, Line <LineNumber> Inv... | 2023-08-10 00:00:00 | Read more |
2491363 | Fixes an issue in which a checkpoint process on an In-Memory OLTP database may get stuck, and the log size keeps increasing. | 2023-08-10 00:00:00 | Read more |
2491770 | Fixes an issue in which the number of the Log Writer threads is inconsistent when the SQL Server instance is affinitized to a subset of NUMA nodes. | 2023-08-10 00:00:00 | Read more |
2494984 | Fixes a memory leak issue that you encounter on MEMOBJ_STORAGEMANAGEMENT when you try to use Backup TO URL for AWS S3-compatible object storage. | 2023-08-10 00:00:00 | Read more |
2500053 | Fixes an access violation in sqllang!FReadDataDirect that you encounter during network exchanges between an instance of SQL Server and a client. | 2023-08-10 00:00:00 | Read more |
2506726 | Improves sp_addpublication_snapshot by exposing additional parameters (@distributor_security_mode, @distributor_login, and @distributor_password). With these parameters, you can co... | 2023-08-10 00:00:00 | Read more |
2512016 | Fixes an access violation that you encounter during the initialization of Query Store if a parameter sensitive plan (PSP) optimization query variant has inconsistent data within th... | 2023-08-10 00:00:00 | Read more |
2516796 | Fixes an issue in which you can't see the Created By and Updated By fields in the View History window when you use the Master Data Services (MDS) Add-in for Excel. | 2023-08-10 00:00:00 | Read more |
2518605 | Fixes an issue in which an error may occur when you download an attachment uploaded previously in a Master Data Services model. | 2023-08-10 00:00:00 | Read more |
2522765 | Fixes the incorrect masking behavior that you encounter when you use an INSTEAD OF trigger that's defined on a table, which contains columns that use dynamic data masking (DDM). | 2023-08-10 00:00:00 | Read more |
2526528 | Fixes error 207 (Invalid column name '<ColumnName>') that you encounter when you run a user-defined function (UDF), which references a dropped column that uses dynamic data masking... | 2023-08-10 00:00:00 | Read more |
2528280 | Fixes a dump issue that you encounter when you run the APPROX_COUNT_DISTINCT query, which affects the query that has at least two approximate count aggregates where at least one ag... | 2023-08-10 00:00:00 | Read more |
2475019 | Improvement: Make several enhancements to the SQLIOSim utility | 2023-08-10 00:00:00 | Read more |
2568409 | Improvement: Make several enhancements to the SQLIOSim utility | 2023-08-10 00:00:00 | Read more |
14899781 | KB5016729 - Improvement: Enable distributed availability groups on SQL Server Standard editions with Azure services - Microsoft Support | 2023-08-07 00:00:00 | Read more |
12768690 | KB4502532 - FIX: Query takes a long time if you enable Batch Mode Adaptive Join in SQL Server 2017 - Microsoft Support | 2023-08-02 00:00:00 | Read more |
12489781 | KB4092997 - FIX: VC++ 2015 Redistributable installation returns error 1638 when a newer version is already installed - Microsoft Support | 2023-08-02 00:00:00 | Read more |
11990858 | KB4338296 - FIX: Memory leak after dropping a LOB or off-row column from a memory-optimized table in SQL Server on Linux - Microsoft Support | 2023-08-02 00:00:00 | Read more |
11281540 | KB4052572 - FIX: SSAS 2016 and 2017 crash intermittently when you rename a multidimensional database by using script - Microsoft Support | 2023-08-02 00:00:00 | Read more |
11455807 | KB4056955 - FIX: Queries that cast string or binary data to XML take a long time to compile in SQL Server 2016 and 2017 - Microsoft Support | 2023-08-02 00:00:00 | Read more |
10965958 | KB4034789 - FIX: An unexpected exception error occurs when an XIRR measure processes too many records in SSAS 2016 or 2017 - Microsoft Support | 2023-08-02 00:00:00 | Read more |
11080104 | KB4052938 - FIX: DST changes of Sao Paulo time zone are not determined by SQL Server 2017 on Linux - Microsoft Support | 2023-07-24 00:00:00 | Read more |
11008122 | KB4046638 - Add the ability to disable or enable a few new DMVs and DMFs introduced in SQL Server 2017 - Microsoft Support | 2023-07-24 00:00:00 | Read more |
10998915 | KB4046744 - FIX: DML statements that use cascading operations fail in SQL Server 2017 - Microsoft Support | 2023-07-24 00:00:00 | Read more |
10982548 | KB4046918 - FIX: Execution fails when a SQL CLR function invokes Transact-SQL statements through impersonation calls in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-24 00:00:00 | Read more |
9704947 | KB4039284 - Enhancement: New keyword is added to CREATE and UPDATE STATISTICS statements to persist sampling rate for future statistics updates in SQL Server - Microsoft Support | 2023-07-24 00:00:00 | Read more |
10270905 | KB4040108 - FIX: Backup of availability database via VSS-based application may fail in SQL Server - Microsoft Support | 2023-07-24 00:00:00 | Read more |
10868754 | KB4033789 - FIX: A memory leak may occur when you perform Process Update operations in SSAS - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10965991 | KB4040085 - FIX: "Ambiguous paths" error when deploying tabular model database to Analysis Services in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10965994 | KB4043478 - FIX: Error when you export an SSRS report on an iOS device in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10965999 | KB4039125 - FIX: "The folder ... does not exist" error when deleting a folder in web portal of SQL Server 2016 or 2017 Reporting Service - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10965982 | KB4039124 - FIX: Memory spike in LSASS.EXE when you enable Basic Authentication mode in SSRS 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10965998 | KB4039126 - FIX: Horizontal scroll bar missing from Subscription page in SSRS 2016 or 2017 web portal - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10966008 | KB4039058 - FIX: Report Viewer Web Part does not allow a full vertical scrollbar after you set a specific web part height - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10998673 | KB4046044 - FIX: Unable to install SQL Server 2017 when instance name/ID/installation path contains multi-byte characters - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10867556 | KB4022895 - FIX: Excel crashes when you save a workbook as a PDF file by using the Adobe Acrobat PDFMaker add-in if the MDS add-in for Excel in SQL Server is also installed - Micro... | 2023-07-21 00:00:00 | Read more |
10868726 | KB4039511 - FIX: Managed Backup fails intermittently because of SQLVDI error in SQL Server - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10868723 | KB4038882 - FIX: SQL Server Managed Backup does not delete old backups that are beyond the retention period in SQL Server - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10966001 | KB4040531 - FIX: Constraint violation error returned by the managed_backup.fn_available_backups function after you install the Cumulative Update 2 for SQL Server 2016 SP1 - Microso... | 2023-07-21 00:00:00 | Read more |
10966019 | KB4040535 - FIX: SQL Server Managed Backups do not run a scheduled log backup in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10868733 | KB4040376 - FIX: Managed Backup to Microsoft Azure stops after large database backup in SQL Server - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10867553 | KB4025020 - FIX: SUSER_SNAME function returns different results between SQL Server 2014 and SQL Server 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
11000432 | KB4046099 - FIX: Assertion error after creating snapshot backup for database with memory-optimized tables in SQL Server 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10936097 | KB4046066 - All transactions reported as completed even though some fail while trying to commit in SQL Server 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10921835 | KB4046065 - FIX: Memory corruption occurs during Availability Group failovers for DTC transactions in SQL Server 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10936099 | KB4045687 - Update to enable SQL Server 2017 Express edition to act as a witness role in a database mirroring session - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10966010 | KB4040530 - FIX: Log chain break in the "managed_backup.fn_available_backups" table in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10938809 | KB4044009 - FIX: A deadlock condition occurs when you create a new database in SQL Server 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10966009 | KB4038113 - FIX: EXCEPTION_ACCESS_VIOLATION for query using sys.dm_os_memory_objects statement in SQL Server - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10870647 | KB4024622 - FIX: Couldn't truncate a partition of the partitioned table if it contains an extended or XML index in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10691456 | KB4023926 - FIX: Unable to drop stored procedure execution article from P2P publication in SQL Server - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10936411 | KB4040276 - FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
11003299 | KB4046055 - FIX: FORCE_LAST_GOOD_PLAN recommendation stuck at "Verifying" at first verification in SQL Server 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
11003402 | KB4046022 - FIX: Automatic Tuning settings cannot be configured on ModelDB in SQL Server 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10868755 | KB4040512 - FIX: Error when exporting a Reporting Services report to PDF in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10868768 | KB4039510 - FIX: Access violation occurs when you use sp_xml_preparedocument to open XML documents in SQL Server - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10978904 | KB4043624 - FIX: Change tracking manual cleanup fails with table non-existence error in SQL Server - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10965952 | KB4024860 - Update to improve the performance for columnstore dynamic management views "column_store_row_groups" and "dm_db_column_store_row_group_physical_stats" in SQL Server 201... | 2023-07-21 00:00:00 | Read more |
10965988 | KB4040519 - FIX: Automatic seeding in Availability Groups randomly causes error 41169 in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10965968 | KB4040533 - FIX: Returns incorrect results when computed column is queried after installing hotfix that's described in KB 3213683 and enabling TF 176 in SQL Server 2016 or 2017 - M... | 2023-07-21 00:00:00 | Read more |
10936563 | KB4039089 - FIX: EXCEPTION_ACCESS_VIOLATION error when you execute the sys.sp_MScdc_capture_job stored procedure in SQL Server - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10687745 | KB4018908 - FIX: Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services (Multidimensional model) - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10070694 | KB4019840 - FIX: Queries against PolyBase external tables return duplicate rows in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10986691 | KB4045678 - FIX: Unexpected error when you use the DReplay feature to replay a captured trace in SQL Server 2017 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10687757 | KB4022753 - FIX: SSAS crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10687780 | KB4023995 - FIX: A data mask on a floating points column is not applied in SQL Server 2017 and SQL Server 2016 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10687776 | KB4023865 - FIX: Expanding the Entities folder on the Manage Groups page takes a long time in SQL Server MDS - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10682349 | KB4024023 - FIX: SSAS crashes when you access .vmp files in SQL Server 2017 and SQL Server 2016 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10682367 | KB4032543 - FIX: SSAS crashes when you run a DAX or MDX query in SSAS in Tabular mode - Microsoft Support | 2023-07-21 00:00:00 | Read more |
10687784 | KB4025402 - FIX: Security Bulletin MS16-136 breaks the SSRS data source type in PowerPivot in SQL Server 2017 and SQL Server 2016 - Microsoft Support | 2023-07-21 00:00:00 | Read more |
13636909 | KB4034376 - FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature in SQL Server - Microsoft Support | 2023-07-20 00:00:00 | Read more |
11919582 | KB4090004 - Improvement: Configure SESSION_TIMEOUT value for a Distributed Availability Group replica in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
11919583 | KB4099919 - Transparent Data Encryption added for Log Shipping in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10868777 | KB3208545 - FIX: SQL Server 2016 or 2017 Analysis Services may crash in a specific situation - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10868739 | KB4039509 - FIX: SSAS crashes when you process an SSAS database or cube in SQL Server - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10868736 | KB4022483 - FIX: Error when you export a DQS knowledge base that contains domains in the DQS client in SQL Server - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10966015 | KB4038590 - FIX: SSIS package that contains German umlauts fails on execution after Incremental Package Deployment in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10936183 | KB4039868 - FIX: Performance drop when using In-Memory OLTP with Always On availability groups in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10936185 | KB4039776 - FIX: Incorrect behavior when you use memory-optimized tables with "where exists" statement in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10749795 | KB4043455 - FIX: Portability and performance differ between Windows and Linux scheduler mappings in SQL Server 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10965984 | KB4039966 - FIX: Access violation occurs when a DDL trigger is raised by the CREATE EXTERNAL TABLE command in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10965980 | KB4042251 - FIX: Database mirroring failover fails with error 3456 in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10966016 | KB4039736 - FIX: SSIS package does not start when it's run by a CLR stored procedure whose user does not have SYSADMIN permissions - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10889338 | KB4042885 - FIX: Divide-by-zero error when a parallel query is forced to run in serial mode in SQL Server 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10691460 | KB4034376 - FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature in SQL Server - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10868749 | KB4040401 - FIX: Access violation for spatial datatypes query via linked server in SQL Server - Microsoft Support | 2023-07-20 00:00:00 | Read more |
10865727 | KB4024393 - FIX: Assertion error occurs on the secondary replica when you resume a suspended availability database in SQL Server 2016 or 2017 - Microsoft Support | 2023-07-20 00:00:00 | Read more |
12248752 | KB4100582 - FIX: Sensitive data may be exposed when you enable DDM function in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-19 00:00:00 | Read more |
11922902 | KB4316858 - FIX: "Corrupted index" message and server disconnection when an update statistics query uses hash aggregate on SQL Server - Microsoft Support | 2023-07-19 00:00:00 | Read more |
11983933 | KB4164562 - FIX: Wrong user name appears when two users log on to MDS at different times in SQL Server - Microsoft Support | 2023-07-19 00:00:00 | Read more |
11983956 | KB4131960 - FIX: Access violation when you run a nested select query against a columnstore index in SQL Server - Microsoft Support | 2023-07-19 00:00:00 | Read more |
11983935 | KB4094706 - FIX: Parallel query hangs when a worker thread is aborted in an instance of SQL Server - Microsoft Support | 2023-07-19 00:00:00 | Read more |
11983961 | KB4163087 - FIX: Performance is slow for an Always On AG when you process a read query in SQL Server - Microsoft Support | 2023-07-19 00:00:00 | Read more |
11952929 | KB4163087 - FIX: Performance is slow for an Always On AG when you process a read query in SQL Server - Microsoft Support | 2023-07-19 00:00:00 | Read more |
11751554 | KB4100582 - FIX: Sensitive data may be exposed when you enable DDM function in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-19 00:00:00 | Read more |
12757005 | KB4493364 - FIX: Error occurs when you back up a virtual machine with non-component based backup in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-18 00:00:00 | Read more |
12883479 | KB4511593 - FIX: DBCC SHOW_STATISTICS permission check fails with an AV error in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-18 00:00:00 | Read more |
12931699 | KB4493364 - FIX: Error occurs when you back up a virtual machine with non-component based backup in SQL Server 2016 and 2017 - Microsoft Support | 2023-07-18 00:00:00 | Read more |
12651915 | KB4490799 - FIX: DBCC STACKDUMP doesn't generate dump file for SQL Server 2017 on Linux starting from SQL Server 2017 CU9 to CU13 - Microsoft Support | 2023-07-18 00:00:00 | Read more |
12336241 | KB4458316 - FIX: "Internal error: An unexpected error occurred" when you run an MDX query that was generated by Excel in SSAS - Microsoft Support | 2023-07-18 00:00:00 | Read more |
12362293 | KB4459220 - FIX: Incorrect results occur when you convert "pollinginterval" parameter from seconds to hours in sys.sp_cdc_scan in SQL Server - Microsoft Support | 2023-07-18 00:00:00 | Read more |
10985578 | KB4045329 - FIX: Error when a stored procedure passes a memory-optimized table to an inline table-valued function in SQL Server 2017 - Microsoft Support | 2023-07-17 00:00:00 | Read more |
2434843 | Fixes an issue in which a thread deadlock between Query Store (QDS) background tasks blocks the database shutdown. | 2023-07-13 00:00:00 | Read more |
2382857 | Fixes an issue in which the node profile information from parallel threads for Cardinality Estimation (CE) feedback is missing. After you apply this fix, CE feedback can suggest hi... | 2023-07-13 00:00:00 | Read more |
2470755 | Fixes an access violation that you encounter under a race condition if the parameter sensitive plan (PSP) optimization feature has Query Store integration enabled, and a query vari... | 2023-07-13 00:00:00 | Read more |
2442348 | Fixes an issue in which applying a patch on the secondary replica or performing an in-place upgrade fails if a database has change data capture (CDC) enabled and is in an availabil... | 2023-07-13 00:00:00 | Read more |
2266818 | Adds a new error 673 that helps avoid the assertion failure (Location: IndexRowScanner.cpp:1449; Expression: m_versionStatus.IsVisible ()) that you might encounter when you enable ... | 2023-07-13 00:00:00 | Read more |
2475171 | Enables Azure Active Directory (Azure AD) authentication for SQL Server replication. Azure AD authentication for replication can be disabled by using trace flag 11561. Using Azure ... | 2023-07-13 00:00:00 | Read more |
2472403 | Fixes the following error 41313 that you encounter when you create a natively compiled stored procedure that contains a CASE statement and a column that uses dynamic data masking (... | 2023-07-13 00:00:00 | Read more |
2425643 | Fixes an issue in which running DBCC CHECKDB reports RBPEX::NotifyFileShutdown in the SQL Server error log. | 2023-07-13 00:00:00 | Read more |
2424714 | Fixes a non-yielding scheduler condition (Msg 17883) that you encounter when backup operations can't handle abort signals correctly in some cases while waiting for pending I/O writ... | 2023-07-13 00:00:00 | Read more |
2449506 | Fixes an issue in which the SQL Server instance stops responding when it calls a memory-optimized stored procedure from another memory-optimized stored procedure in which the calle... | 2023-07-13 00:00:00 | Read more |
2439381 | Fixes potential memory access violations and incorrect results when executing specific Data Analysis Expressions (DAX) queries that trigger the internal Horizontal Fusion query opt... | 2023-07-13 00:00:00 | Read more |
2431805 | Fixes a non-yielding dump issue that you encounter when the IORequestDispenser is waiting for the I/O to finish. | 2023-07-13 00:00:00 | Read more |
2405773 | Fixes an issue in which upgrading SQL Server 2017 to SQL Server 2022 on Linux fails and returns an error such as "'model_replicatedmaster.ldf' file does not exist." | 2023-07-13 00:00:00 | Read more |
2442140 | Fixes an issue in which an alias error occurs during a database upgrade if you apply the name "en" to an attribute. | 2023-07-13 00:00:00 | Read more |
2397656 | KB4052136 - FIX: SQL Server Audit Events don't write to the Security log - Microsoft Support | 2023-07-13 00:00:00 | Read more |
2397659 | KB4052136 - FIX: SQL Server Audit Events don't write to the Security log - Microsoft Support | 2023-07-13 00:00:00 | Read more |
13317221 | KB4537749 - Improvement: Port additional two system tables in Tempdb Memory-Optimized Metadata feature in SQL Server 2019 - Microsoft Support | 2023-06-29 00:00:00 | Read more |
13959563 | KB5000715 - FIX: Failures with log reader agent occur when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017 or 2016 - Microsoft Support | 2023-06-20 00:00:00 | Read more |
13472695 | KB4563348 - After upgrading SQL Server 2017 Distributor to SQL Server 2019, transactional push replication fails when subscriber is using non-default port - Microsoft Support | 2023-06-20 00:00:00 | Read more |
13959562 | KB5000715 - FIX: Failures with log reader agent occur when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017 or 2016 - Microsoft Support | 2023-06-20 00:00:00 | Read more |
2342416 | Adds the sp_validate_certificate_ca_chain stored procedure for checking the validity of the certificate chain used for certificate-based authentication on endpoints of Service Brok... | 2023-06-15 00:00:00 | Read more |
2369044 | Adds additional enforcement of write operations to the encryption algorithm that's used to encrypt data sources and connection strings in SQL Server Analysis Services (SSAS) models... | 2023-06-15 00:00:00 | Read more |
2400346 | Fixes an issue where a hierarchy created in Master Data Services (MDS) doesn't expand correctly (on both the Edit Derived Hierarchy page and the Hierarchy page in the Explorer area... | 2023-06-15 00:00:00 | Read more |
2400389 | Adds an option for the Master Data Services (MDS) configuration tool to decide whether to enable the PerformanceImprovementEnable performance improvement setting. | 2023-06-15 00:00:00 | Read more |
2400415 | Fixes the following error that you may encounter when selecting any cell of a domain-based attribute column that has a different name and display name in a Master Data Services (MD... | 2023-06-15 00:00:00 | Read more |
2384656 | Updates the support for predicate pushdown when filtering on the session_id column of the sys.dm_exec_connections dynamic management view (DMV). | 2023-06-15 00:00:00 | Read more |
2396496 | Fixes a network socket crash that affects SQL connectivity during a large number of connections. | 2023-06-15 00:00:00 | Read more |
2402260 | Updates the version of the Microsoft ODBC driver to 17.10.4.1. For more information, see Release Notes for Microsoft ODBC Driver for SQL Server on Windows. | 2023-06-15 00:00:00 | Read more |
2402263 | Updates the version of the Microsoft OLE DB driver to 18.6.6. For more information, see Release notes for the Microsoft OLE DB Driver for SQL Server. | 2023-06-15 00:00:00 | Read more |
2402141 | Fixes an issue where applying the option ONLINE in the ALTER INDEX REBUILD statement is invalid when running the index rebuild task created in an index maintenance plan. | 2023-06-15 00:00:00 | Read more |
2399781 | Fixes a memory leak issue that you encounter when you run queries that use an equals (=) string predicate on a clustered columnstore index (CCI). | 2023-06-15 00:00:00 | Read more |
2399843 | Fixes a performance issue that you may encounter when the String Min/Max for Rowgroup Elimination feature is enabled, and you query a clustered columnstore index (CCI) that's built... | 2023-06-15 00:00:00 | Read more |
2417114 | Consider the following scenario: 1. You have an instance of SQL Server that connects to Azure Active Directory (Azure AD). 2. You enable Transport Layer Security (TLS) encryption o... | 2023-06-15 00:00:00 | Read more |
2375473 | Fixes an issue where the following error occurs when you disable the FILESTREAM feature on a SQL Server failover cluster instance (FCI) by using SQL Server Configuration Manager (S... | 2023-06-15 00:00:00 | Read more |
2391164 | Fixes an issue where messages in the sys.transmission_queue of the initiator database in a SQL Server Service Broker conversation are missing or stuck after a failover of the targe... | 2023-06-15 00:00:00 | Read more |
2268493 | Fixes an issue where restoring an In-Memory OLTP database backup that has Transparent data encryption (TDE) enabled fails and returns the following error message: Error: 33126, Sev... | 2023-06-15 00:00:00 | Read more |
2370134 | Fixes an assertion dump issue (Location: "sql\\ntdbms\\hekaton\\engine\\core\\tx.cpp":4753; Expression: 0 == Dependencies.CommitDepCountOut) that causes an availability group failo... | 2023-06-15 00:00:00 | Read more |
2396747 | Fixes a dump issue where a huge number of concurrent In-Memory OLTP transactions cause a stack overflow. | 2023-06-15 00:00:00 | Read more |
2402985 | Removes the need for running the sys.sp_xtp_force_gc stored procedure twice to free up allocated and used XTP memory, and running it once is enough. You need at least the ALTER SER... | 2023-06-15 00:00:00 | Read more |
2005656 | Adds support for Azure Data Lake Storage (ADLS) Gen2 as a storage location in CREATE EXTERNAL TABLE AS SELECT (CETAS), which fixes the following error 15883 that you encounter when... | 2023-06-15 00:00:00 | Read more |
2398344 | Fixes an issue where external data sources that use the generic ODBC connector may not work after you install SQL Server 2022 CU2 or later versions. You may encounter the following... | 2023-06-15 00:00:00 | Read more |
2357623 | Fixes an access violation caused by transient race conditions in certain scenarios when parameter sensitive plan (PSP) optimization has Query Store integration enabled. | 2023-06-15 00:00:00 | Read more |
2371755 | Fixes a dump issue where the Cardinality Estimation (CE) feedback validation flag is set on statements that come after the statement analyzed by CE Feedback within a batch. | 2023-06-15 00:00:00 | Read more |
2320880 | Fixes an issue where applying a patch on a secondary replica or performing an in-place upgrade fails when the distribution database is in an availability group. The following error... | 2023-06-15 00:00:00 | Read more |
2357336 | Fixes an issue that you encounter in the following scenario: - A SQL Server 2017 instance is configured as the Publisher, and a SQL Server 2022 instance is configured as the Distri... | 2023-06-15 00:00:00 | Read more |
2351584 | Fixes an issue where high PREEMPTIVE_OS_QUERYREGISTRY waits occur. To apply this fix, you need to turn on trace flag 12502, which is used to disable external authorization policies... | 2023-06-15 00:00:00 | Read more |
2401498 | Consider the following scenario: 1. You connect to SQL Server as user A. 2. In the meantime, user B's password is changed in the background. In this scenario, the following error m... | 2023-06-15 00:00:00 | Read more |
2429240 | Fixes an issue where upgrading to SQL Server 2022 database mirroring fails and returns the following errors: Error: 37526, Severity: 16, State: 1. A ledger table cannot be created ... | 2023-06-15 00:00:00 | Read more |
2357203 | Fixes an issue where the following error occurs when you try to manually enter the product key while configuring SQL Server by using the command /opt/mssql/bin/mssql-conf setup or ... | 2023-06-15 00:00:00 | Read more |
2391385 | Fixes a non-yielding dump issue that you encounter when creating an Extended Events (XEvents) session that captures the sql_text field and has several kilobytes of T-SQL queries. | 2023-06-15 00:00:00 | Read more |
2355184 | After applying this update, master databases that are part of contained availability groups will no longer incorrectly report errors when DBCC CHECKDB is being run against them out... | 2023-06-15 00:00:00 | Read more |
2417020 | FIX: Incorrect results may occur when you run queries against tables that contain indexes using a descending sort order | 2023-06-15 00:00:00 | Read more |
2354551 | Adds an option for the Master Data Services (MDS) configuration tool to decide whether to enable the PerformanceImprovementEnable performance improvement setting. | 2023-06-15 00:00:00 | Read more |
2367741 | Fixes an issue where a hierarchy created in Master Data Services (MDS) doesn't expand correctly (on both the Edit Derived Hierarchy page and the Hierarchy page in the Explorer area... | 2023-06-15 00:00:00 | Read more |
2375656 | Fixes the following error that you may encounter when selecting any cell of a domain-based attribute column that has a different name and display name in a Master Data Services (MD... | 2023-06-15 00:00:00 | Read more |
2385119 | Updates the support for predicate pushdown when filtering on the session_id column of the sys.dm_exec_connections dynamic management view (DMV). | 2023-06-15 00:00:00 | Read more |
2405054 | Updates the version of the Microsoft ODBC driver to 17.10.4.1. For more information, see Release Notes for Microsoft ODBC Driver for SQL Server on Windows. | 2023-06-15 00:00:00 | Read more |
2405058 | Updates the version of the Microsoft OLE DB driver to 18.6.6. For more information, see Release notes for the Microsoft OLE DB Driver for SQL Server. | 2023-06-15 00:00:00 | Read more |
2405087 | Fixes an issue where applying the option ONLINE in the ALTER INDEX REBUILD statement is invalid when running the index rebuild task created in an index maintenance plan. | 2023-06-15 00:00:00 | Read more |
2399354 | Consider the following scenario: 1. You have an instance of SQL Server that connects to Azure Active Directory (Azure AD). 2. You enable Transport Layer Security (TLS) encryption o... | 2023-06-15 00:00:00 | Read more |
2375469 | Fixes an issue where the following error occurs when you disable the FILESTREAM feature on a SQL Server failover cluster instance (FCI) by using SQL Server Configuration Manager (S... | 2023-06-15 00:00:00 | Read more |
2195940 | Fixes an issue where messages in the sys.transmission_queue of the initiator database in a SQL Server Service Broker conversation are missing or stuck after a failover of the targe... | 2023-06-15 00:00:00 | Read more |
2101590 | Fixes an issue where restoring an In-Memory OLTP database backup that has Transparent data encryption (TDE) enabled fails and returns the following error message: Error: 33126, Sev... | 2023-06-15 00:00:00 | Read more |
2184943 | Fixes an assertion dump issue (Location: "sql\\ntdbms\\hekaton\\engine\\core\\tx.cpp":4753; Expression: 0 == Dependencies.CommitDepCountOut) that causes an availability group failo... | 2023-06-15 00:00:00 | Read more |
2347043 | Provides the details of the corrupt checkpoint file that's associated with the in-memory database when you try to restore a database but it fails with the following error: [ERROR] ... | 2023-06-15 00:00:00 | Read more |
2401115 | Fixes a dump issue where a huge number of concurrent In-Memory OLTP transactions cause a stack overflow. | 2023-06-15 00:00:00 | Read more |
2404944 | Removes the need for running the sys.sp_xtp_force_gc stored procedure twice to free up allocated and used XTP memory, and running it once is enough. You need at least the ALTER SER... | 2023-06-15 00:00:00 | Read more |
2312800 | Fixes an issue where external data sources that use the generic ODBC connector may not work after you install SQL Server 2019 CU19 or later versions. You may encounter the followin... | 2023-06-15 00:00:00 | Read more |
2117672 | Fixes an issue that can cause the query execution to encounter an access violation error when the query has an aggregate function or a GROUP BY clause against a columnstore table t... | 2023-06-15 00:00:00 | Read more |
2346939 | Fixes an assertion failure (Location: tmpilb.cpp:3540; Expression: RTL_ASSERTSZ(fFalse, "Attempt to access expired blob handle (1)")) and the following errors that you encounter wh... | 2023-06-15 00:00:00 | Read more |
2307898 | Fixes incorrect results for queries that filter on ROW_NUMBER and involve nullable columns. | 2023-06-15 00:00:00 | Read more |
2313620 | Fixes the following errors and access violations that are caused by an incorrect plan in the case of multiple occurrences of the same scalar subquery: Msg 596, Level 21, State 1, L... | 2023-06-15 00:00:00 | Read more |
2363303 | Improves the cardinality estimation (CE) for "AND" conjunctions that are composed of point predicates when the predicates have a multi-column statistic covering them, and the predi... | 2023-06-15 00:00:00 | Read more |
2391556 | Fixes inconsistent results that are caused by the parallel spool in the plan for the INSERT, UPDATE, or DELETE query. | 2023-06-15 00:00:00 | Read more |
2266806 | Adds a new error 673 that helps avoid the assertion failure (Location: IndexRowScanner.cpp:1449; Expression: m_versionStatus.IsVisible ()) that you might encounter when you enable ... | 2023-06-15 00:00:00 | Read more |
2320889 | Fixes an issue where applying an update on a secondary replica or performing an in-place upgrade fails when the distribution database is in an availability group. The following err... | 2023-06-15 00:00:00 | Read more |
2421435 | Fixes a manual cleanup issue where the repeated lock escalations on the tables cause contention and slowness in cleaning up the expired change tracking metadata. Note: You need to ... | 2023-06-15 00:00:00 | Read more |
2409008 | Fixes error 207 (Invalid column name '<ColumnName>') that you encounter when you run a user-defined function (UDF), which references a dropped column that uses dynamic data masking... | 2023-06-15 00:00:00 | Read more |
2330957 | Fixes the following error that you encounter on the target instance when configuring a Service Broker communication with transport security and the certificate serial number length... | 2023-06-15 00:00:00 | Read more |
2410400 | SOS_BLOCKALLOCPARTIALLIST spinlock contention and elevated CPU utilization occur on large-memory machines. DBCC DROPCLEANBUFFERS provides temporary mitigation for this issue when e... | 2023-06-15 00:00:00 | Read more |
13703268 | KB4580915 - FIX: SQL Server error log receives several ADR enabled/disabled messages even when ADR isn't explicitly enabled/disabled - Microsoft Support | 2023-06-09 00:00:00 | Read more |
13521037 | KB4580949 - FIX: Snapshot agent fails when you create Transactional Publication with all tables and UDFs in SQL Server 2019 - Microsoft Support | 2023-06-09 00:00:00 | Read more |
13704325 | KB4580639 - FIX: PolyBase queries can now be run with EXECUTE AS impersonation context in SQL Server 2019 - Microsoft Support | 2023-06-08 00:00:00 | Read more |
13693311 | KB4580648 - FIX: Errors may occur or PolyBase services fail to start when you run PolyBase queries on a non-English OS - Microsoft Support | 2023-06-08 00:00:00 | Read more |
13703114 | KB4580413 - FIX: Deadlock occurs between Availability Group Configuration and Replica Transport State Lock in SQL Server 2019 - Microsoft Support | 2023-06-08 00:00:00 | Read more |
13691465 | KB4579223 - FIX: PolyBase processes delayed to avoid data dump during provisioning in SQL Server 2019 - Microsoft Support | 2023-06-08 00:00:00 | Read more |
2217036 | KB5017009 - FIX: sp_replmonitorsubscriptionpendingcmds returns incorrect pending commands for P2P replication - Microsoft Support | 2023-05-12 00:00:00 | Read more |
14737844 | KB5017009 - FIX: sp_replmonitorsubscriptionpendingcmds returns incorrect pending commands for P2P replication - Microsoft Support | 2023-05-12 00:00:00 | Read more |
2305079 | Fixes a DateTime issue where the month and day are incorrectly recognized in Master Data Services (MDS) that you encounter when the input format doesn't match the preset format. | 2023-05-11 00:00:00 | Read more |
2300365 | Fixes an access violation issue, most often seen on a database in an availability group, that you encounter during virtual device interface (VDI) backups. | 2023-05-11 00:00:00 | Read more |
2299195 | Fixes an issue where SQL Server Agent job steps fail with the following error after the management data warehouse (MDW) is configured on a server: Executed as user: NT Service\SQLS... | 2023-05-11 00:00:00 | Read more |
2306513 | Fixes access violations and INVALID_POINTER_READ_c0000005_sqlmin.dll!CProfileList::FGetPartitionSummaryXML exceptions that you may encounter during the execution of sys.dm_exec_que... | 2023-05-11 00:00:00 | Read more |
2310201 | Fixes an issue where running the ALTER ASSEMBLY command for a complex common language runtime (CLR) assembly can cause some of the other commands that are executed in parallel to t... | 2023-05-11 00:00:00 | Read more |
2344871 | Adds two new trace flags (TF) to the automatic plan correction (APC) feature of automatic tuning. TF 12618 introduces a new plan regression detection model that includes multiple c... | 2023-05-11 00:00:00 | Read more |
2306669 | Fixes an issue where parameter sensitive plan (PSP) optimization produces a dispatcher expression but fails to create a query variant when an application attempts to use the SET FM... | 2023-05-11 00:00:00 | Read more |
2329208 | Fixes an issue where parameter sensitive plan (PSP) optimization can't successfully remove a query from the in-memory portion of the Query Store when PSP optimization has Query Sto... | 2023-05-11 00:00:00 | Read more |
2344940 | Fixes an access violation when parameter sensitive plan (PSP) optimization has Query Store integration enabled under certain conditions when query variants and dispatcher plans are... | 2023-05-11 00:00:00 | Read more |
2344943 | Fixes an access violation when parameter sensitive plan (PSP) optimization has Query Store integration enabled when an inconsistent state exists within the PSP-related Query Store.... | 2023-05-11 00:00:00 | Read more |
2344945 | Fixes an issue when parameter sensitive plan (PSP) optimization has Query Store integration enabled when a dispatcher plan is removed from the Query Store. | 2023-05-11 00:00:00 | Read more |
2278800 | Fixes an issue where incorrect results are returned when you use the LAG or LEAD window functions while using the IGNORE NULLS clause. | 2023-05-11 00:00:00 | Read more |
2297428 | Fixes an issue where the KILL STATS JOB process leaks reference counts on some items when multiple asynchronous statistics jobs are running, which causes those items to remain in t... | 2023-05-11 00:00:00 | Read more |
2307893 | Fixes incorrect results for queries that filter on ROW_NUMBER and involve nullable columns. | 2023-05-11 00:00:00 | Read more |
2313621 | Fixes the following errors and access violations that are caused by an incorrect plan in the case of multiple occurrences of the same scalar subquery: Msg 596, Level 21, State 1, L... | 2023-05-11 00:00:00 | Read more |
2343788 | Fixes a memory leak issue in the Cardinality Estimation (CE) feedback when an OOM (Out of Memory) error occurs in a constructor function. | 2023-05-11 00:00:00 | Read more |
2303424 | Fixes an issue that prevents you from dropping table groups on a database that has Azure Synapse Link enabled and the collation is set to Latin1_General_BIN2. | 2023-05-11 00:00:00 | Read more |
2335976 | Fixes an issue where error 22836 occurs when you add the change data capture (CDC) job again after deleting CDC capture and removing a job in SQL Server Agent. | 2023-05-11 00:00:00 | Read more |
2329148 | Fixes an issue where the SQL Server service on Linux exits with an unsuccessful code when you request to stop it. | 2023-05-11 00:00:00 | Read more |
2312111 | FIX: Errors occur after you apply a cumulative update to an instance of SQL Server that has a contained availability group | 2023-05-11 00:00:00 | Read more |
2273502 | Fixes an issue where the change tracking auto cleanup process generates dumps under rare conditions when the parent table name that the system tries to access isn't available durin... | 2023-04-13 00:00:00 | Read more |
2283663 | Adds a new feature that helps parallelize the version cleaner, which will help clean up the stale versions faster on databases that have the persistent version store. | 2023-04-13 00:00:00 | Read more |
2279666 | Fixes a failure in SQL Server Analysis Services (SSAS) that you encounter after you rename partitions to the same name in a multidimensional model. | 2023-04-13 00:00:00 | Read more |
2251138 | Updates the error message that's returned in the SqlBackendNotSupported exception when you run CREATE EXTERNAL TABLE by using a Synapse serverless external data source to the follo... | 2023-04-13 00:00:00 | Read more |
2270253 | Fixes a failure where the DateTime field can't be pushed down to some PolyBase generic ODBC external data sources such as Denodo when you query an external table by using a filter ... | 2023-04-13 00:00:00 | Read more |
2168305 | Fixes a memory leak issue that you encounter when configuring SQL Server log shipping that's in standby or read-only mode for an In-memory OLTP database. Note: You need to turn on ... | 2023-04-13 00:00:00 | Read more |
2255710 | Fixes security vulnerabilities CVE-2015-6420 and CVE-2017-15708. | 2023-04-13 00:00:00 | Read more |
2214981 | Fixes an issue where the mssql-conf commands give incorrect errors even if they succeed on Linux. | 2023-04-13 00:00:00 | Read more |
2204516 | Fixes an issue that can cause corruption of the internal data structure that the Analysis Services engine uses to manage memory. | 2023-04-13 00:00:00 | Read more |
2216357 | Produces consistent results for statements that perform multiple updates to a variable when the query optimization hotfixes are enabled, such as SELECT @sum = @sum + c FROM t. | 2023-04-13 00:00:00 | Read more |
2264977 | Fixes an issue that's caused by automatic parameterization of queries where interleaved execution of multi-statement table-valued functions (MSTVFs) may return incorrect results or... | 2023-04-13 00:00:00 | Read more |
2212160 | Before the fix, you can still enable transactional replication or change data capture (CDC) and delayed durability on a database at the same time, even if transactional replication... | 2023-04-13 00:00:00 | Read more |
2279650 | Fixes a failure in SQL Server Analysis Services (SSAS) that you encounter after you rename partitions to the same name in a multidimensional model. | 2023-04-13 00:00:00 | Read more |
2251105 | Updates the error message that is returned in the SqlBackendNotSupported exception when you run CREATE EXTERNAL TABLE by using a Synapse serverless external data source to the foll... | 2023-04-13 00:00:00 | Read more |
2285519 | Fixes a failure where the DateTime field can't be pushed down to some PolyBase generic ODBC external data sources such as Denodo when you query an external table by using a filter ... | 2023-04-13 00:00:00 | Read more |
2290381 | Fixes an access violation issue, most often seen on a database in an availability group, that you encounter during virtual device interface (VDI) backups. | 2023-04-13 00:00:00 | Read more |
2292999 | Fixes an issue where running the ALTER ASSEMBLY command for a complex common language runtime (CLR) assembly can cause some of the other commands that are executed in parallel to t... | 2023-04-13 00:00:00 | Read more |
2275387 | Fixes an assertion failure (Location: bpctxt.cpp:129; Expression: 'm_cCreated < m_cMaxBatches') that you encounter when running window queries that have aggregate functions in batc... | 2023-04-13 00:00:00 | Read more |
2162863 | Fixes an access violation that may be encountered when querying the sys.dm_os_memory_objects dynamic management view (DMV). | 2023-04-13 00:00:00 | Read more |
2204764 | Fixes access violations and INVALID_POINTER_READ_c0000005_sqlmin.dll!CProfileList::FGetPartitionSummaryXML exceptions that you may encounter during the execution of sys.dm_exec_que... | 2023-04-13 00:00:00 | Read more |
2112485 | Fixes an issue where the cardinality estimation (CE) uniformly increases after each LEFT JOIN or RIGHT JOIN combines, which causes overestimation. This fix adds a limitation to the... | 2023-04-13 00:00:00 | Read more |
2161795 | Fixes an assertion failure (Location: purecall.cpp:51; Expression: !"purecall") that you encounter after you cancel a user-defined stored procedure that is still running. | 2023-04-13 00:00:00 | Read more |
2299078 | Fixes an issue where the KILL STATS JOB process leaks reference counts on some items when multiple asynchronous statistics jobs are running, which causes those items to remain in t... | 2023-04-13 00:00:00 | Read more |
2162994 | Fixes an issue where the DataAccess property for the linked server is reset to False when you execute the sp_addsubscription stored procedure or create a subscription through the N... | 2023-04-13 00:00:00 | Read more |
2269819 | Before the fix, you can still enable transactional replication or change data capture (CDC) and delayed durability on a database at the same time, even if transactional replication... | 2023-04-13 00:00:00 | Read more |
2255878 | Fixes security vulnerabilities CVE-2015-6420 and CVE-2017-15708. | 2023-04-13 00:00:00 | Read more |
2128204 | Fixes an assertion failure (Location: interop.cpp:125; Expression: 'RTL_ASSERT(nullptr != error) or (nullptr == error)') that you encounter when memory-optimized tempdb metadata is... | 2023-04-13 00:00:00 | Read more |
2268752 | Fixes a memory leak issue that you encounter when configuring SQL Server log shipping that's in standby or read-only mode for an In-memory OLTP database. Note: You need to turn on ... | 2023-04-13 00:00:00 | Read more |
2284765 | Fixes a DateTime issue where the month and day are incorrectly recognized in Master Data Services (MDS) that you encounter when the input format doesn't match the preset format. | 2023-04-13 00:00:00 | Read more |
2021114 | FIX: Error may occur when setting the SQL Server Agent job history log | 2023-04-13 00:00:00 | Read more |
2043384 | Fixes an issue where the sqlcmd utility doesn't honor the sqlcmd command ":!!" when you run operating system (OS) commands. For more information, see sqlcmd commands. | 2023-03-15 00:00:00 | Read more |
2119277 | Fixes an issue where the full cleanup failure in the first side table and partial cleanup failure in others can cause incorrect syscommittab table cleanup in change tracking auto c... | 2023-03-15 00:00:00 | Read more |
2163005 | Fixes an issue where the DataAccess property for the linked server is reset to False when you execute the sp_addsubscription stored procedure or create a subscription through the N... | 2023-03-15 00:00:00 | Read more |
2217522 | Fixes an issue where interleaved execution for multi-statement table-valued functions (MSTVFs) uses the OPTIMIZE FOR query hint value and returns an incorrect result on the first e... | 2023-03-15 00:00:00 | Read more |
2217553 | Fixes a memory issue when a recursive graph query is aborted during execution. | 2023-03-15 00:00:00 | Read more |
2223628 | Fixes the incorrect primary key column indexing issue during the schema export phase of Azure Synapse Link replication. This issue occurs when you drop one or more columns that are... | 2023-03-15 00:00:00 | Read more |
2231144 | Fixes an issue that's caused by automatic parameterization of queries where interleaved execution of multi-statement table-valued functions (MSTVFs) may return incorrect results or... | 2023-03-15 00:00:00 | Read more |
2232487 | Starting in SQL Server 2022 CU2, CREATE EXTERNAL DATA SOURCE supports the use of TNS files when connecting to Oracle by using the CONNECTION_OPTIONS parameter. | 2023-03-15 00:00:00 | Read more |
2216691 | Before the fix, you can still enable transactional replication or change data capture (CDC) and delayed durability on a database at the same time, even if transactional replication... | 2023-03-15 00:00:00 | Read more |
2234321 | Before the fix, you can still enable transactional replication or change data capture (CDC) and delayed durability on a database at the same time, even if transactional replication... | 2023-03-15 00:00:00 | Read more |
2205260 | Before the fix, you can still enable transactional replication or change data capture (CDC) and delayed durability on a database at the same time, even if transactional replication... | 2023-03-15 00:00:00 | Read more |
2230926 | FIX: Error may occur when setting the SQL Server Agent job history log (KB5024352) | 2023-03-15 00:00:00 | Read more |
1993393 | Fixes error 35221 that occurs in the following scenarios: - You attempt to add a file to a FILESTREAM filegroup or a memory-optimized filegroup. - You attempt to add additional tra... | 2023-02-16 00:00:00 | Read more |
2162849 | Fixes a self-deadlock issue where internal update statistic transactions persist locks, which can cause unresolved deadlocks with user queries. The issue occurs because the lock is... | 2023-02-16 00:00:00 | Read more |
2113374 | Fixes an access violation exception that occurs on the primary replica when the secondary replica sends cursor plans to the primary replica for storage in Query Store (QDS). | 2023-02-16 00:00:00 | Read more |
2113832 | Updates Microsoft.Data.SqlClient assemblies used by the mashup engine to address security vulnerability discussed in CVE-2022-41064. | 2023-02-16 00:00:00 | Read more |
2114313 | This fix is a safeguard for issues that can cause unavailability due to memory capacity in some rare queries (nested queries performing table scans). Before issuing these queries, ... | 2023-02-16 00:00:00 | Read more |
2114695 | Fixes an issue with differential backup skipping new Page Free Space (PFS) pages after a data file grows around a PFS boundary (a multiple of 8,088 pages; 64,704 KB), resulting in ... | 2023-02-16 00:00:00 | Read more |
2115275 | Enhances the encryption algorithm that's used to encrypt data sources and connection strings in SQL Server Analysis Services (SSAS) models. For more information, see Upgrade encryp... | 2023-02-16 00:00:00 | Read more |
2115768 | Fixes an assertion failure that occurs in natively compiled modules when the Inner FOR JSON operator is followed by an operator that buffers the corresponding objects, such as anot... | 2023-02-16 00:00:00 | Read more |
2153494 | Fixes an assertion failure (Location: execcoll.cpp:1317; Expression: 'savepointId > HkTxSavePointDefault') that occurs during the savepoint cleanup in a Hekaton transaction. | 2023-02-16 00:00:00 | Read more |
2154919 | Fixes an issue where the Transact-SQL snapshot backup fails with the following errors when a database is suspended in single-user mode: Msg 3081, Level 16, State 9, Line <LineNumbe... | 2023-02-16 00:00:00 | Read more |
2157874 | Fixes an access violation and INVALID_POINTER_READ_CPP_EXCEPTION_c0000005_sqldk.dll!ex_oomCheck exceptions triggered by an out-of-memory (OOM) exception when the SQL Server instanc... | 2023-02-16 00:00:00 | Read more |
2158583 | This fix is a safeguard for issues that can cause unavailability due to memory capacity in some rare queries (nested queries performing table scans). Before issuing these queries, ... | 2023-02-16 00:00:00 | Read more |
2159526 | Reverts the length of ROUTINE_DEFINITION column to 4000 in the INFORMATION_SCHEMA.ROUTINES view as the previous change in the length may cause unexpected inconsistencies. | 2023-02-16 00:00:00 | Read more |
2160880 | Fixes an issue where In-Memory OLTP stored procedures that have streaming table-valued functions (STVFs), expressions, or constraint checks may generate inconsistent query plan has... | 2023-02-16 00:00:00 | Read more |
2160907 | Fixes an issue where the Distribution Agent returns a general message code 20046 instead of the connection failure message code 20084 when it fails to connect to the Subscriber by ... | 2023-02-16 00:00:00 | Read more |
2116378 | Fixes a failure to raise the proper data type overflow error when a comma-separated values (CSV) file has an integer (int) value larger than the maximum value of int and you run SE... | 2023-02-16 00:00:00 | Read more |
2117119 | Removes a case of multiple inheritance in the RSA encryption code in SQL Server 2022. | 2023-02-16 00:00:00 | Read more |
2117122 | Fixes a spelling issue in error 33025 (Invalid cryptographic provider property: %S_MSG) when you use the Extensible Key Management (EKM) feature. | 2023-02-16 00:00:00 | Read more |
2117214 | Fixes the following error that can occur when you load audit logs from SQL Server Management Studio (SSMS): Item has already been added. Key in dictionary: 'MNDO' Key being added: ... | 2023-02-16 00:00:00 | Read more |
2118401 | Before you apply this update, the key name in the JSON_OBJECT function output isn't quoted when the data type is a numeric, Boolean, or internal JSON data type. After you apply thi... | 2023-02-16 00:00:00 | Read more |
2120696 | Improvement: Automatically enables the binary large object (BLOB) trace ring buffer feature when a BLOB assertion failure is detected. This improvement helps to better investigate ... | 2023-02-16 00:00:00 | Read more |
2120777 | Fixes a rare issue where memory corruption in the ODBC driver can occur in communications between two SQL Server instances. This issue occurs when the target SQL Server instance us... | 2023-02-16 00:00:00 | Read more |
2123504 | Enhancement: Split the FT_IFTS_RWLOCK wait type into more granular wait types for more accurate diagnostics of the problem. For more information about these wait types, see sys.dm_... | 2023-02-16 00:00:00 | Read more |
2125981 | Adds a new sys.dm_external_provider_certificate_info dynamic management view (DMV), which returns information about the Azure cloud certificates used in SQL Server to set up and ma... | 2023-02-16 00:00:00 | Read more |
2129326 | Fixes error 8992 [Check Catalog Msg 3853, State 1: Attribute (owning_principal_id=<ID>) of row (principal_id=<ID>) in sys.database_principals does not have a matching row (principa... | 2023-02-16 00:00:00 | Read more |
2130492 | Resolves a query performance issue that affects change tracking autocleanup and manual cleanup queries. Note You need to turn on trace flags 8286 and 8287, as this forces the clean... | 2023-02-16 00:00:00 | Read more |
2131225 | Fixes the following issues with attribute-based policies of Purview - Azure Attribute-based access control (Azure ABAC): - Attributes don't synchronize correctly. - The synchroniza... | 2023-02-16 00:00:00 | Read more |
2135970 | Fixes a DBCC CLONEDATABASE failure when upgrading the source database from an earlier version of SQL Server. | 2023-02-16 00:00:00 | Read more |
2137927 | Fixes an issue where schema modification (Sch-M) locks are acquired on foreign key tables when altering columns on the primary tables even if the transaction isn't related to the f... | 2023-02-16 00:00:00 | Read more |
2138330 | Fixes a primary key violation error that's caused by a timing issue in change data capture (CDC) in SQL Server 2022. The CDC capture process may try to insert a duplicate start_lsn... | 2023-02-16 00:00:00 | Read more |
2138691 | Fixes error 302 in SQL Server replication. When the Distribution Agent attempts to apply a snapshot generated on a table that has a primary key with the NEWSEQUENTIALID function as... | 2023-02-16 00:00:00 | Read more |
2138926 | Improvement: The sp_invoke_external_rest_endpoint stored procedure is only supported in Azure SQL Database environments. If you try to use this procedure in on-premises environment... | 2023-02-16 00:00:00 | Read more |
2151109 | Fixes error 241 that occurs while running the Snapshot Agent, and the system date format was changed to a different format than the one used by SQL Server. Error message: Conversio... | 2023-02-16 00:00:00 | Read more |
2098401 | Fixes an issue where a memory dump may occur in CMIterStatsDisk::GetNextStatForLeadingColumn caused by some metadata inconsistencies. | 2023-02-16 00:00:00 | Read more |
2100518 | Fixes an issue where the Azure Active Directory (Azure AD) administrator isn't added to the sysadmin group after you configure Azure AD for SQL Server 2022 | 2023-02-16 00:00:00 | Read more |
2101033 | Updates the error message 37517 used for the Microsoft Purview access policies in SQL Server to the following one: Internal error occurred while obtaining ARC resource information ... | 2023-02-16 00:00:00 | Read more |
2101035 | Fixes an exception that generates a dump file when using Microsoft Purview access policies for SQL Server 2022 and running the sp_external_policy_refresh stored procedure as a non-... | 2023-02-16 00:00:00 | Read more |
2104416 | Fixes an issue where the temporary linked server created by the Log Reader Agent isn't always properly dropped when the publisher is in an Always On availability group (AG) and the... | 2023-02-16 00:00:00 | Read more |
2105584 | Fixes an issue where Full-text Search generates memory leaks and high waits in full-text queries. | 2023-02-16 00:00:00 | Read more |
1860413 | This fix resolves the following issues that can occur when you rename databases: Issue 1: SQL Server crashes when a user who has a non-default schema (for example: CREATE USER <use... | 2023-02-16 00:00:00 | Read more |
1862944 | This update removes the requirement for the trace flag (TF) 809 for the hybrid buffer pool with direct write feature. After you apply this update, this feature is enabled by defaul... | 2023-02-16 00:00:00 | Read more |
1948145 | Fixes error 41842 that's incorrectly shown even when natively compiled stored procedures or in-memory transactions don't insert many records in a single transaction. Here's the err... | 2023-02-16 00:00:00 | Read more |
1959261 | Fixes a high CPU usage condition that occurs when you enable change tracking on a large number of tables and do automatic or manual cleanup of the change tracking tables. | 2023-02-16 00:00:00 | Read more |
1967560 | Fixes errors 12300 (Computed columns are not supported) and 12301 (Nullable columns in the index key are not supported) when transactional replication is enabled on memory optimize... | 2023-02-16 00:00:00 | Read more |
2008855 | Fixes the following error that occurs when you try to start the SQL Server Import and Export Wizard after you install the SQL Server Database Engine: An error occurred which the SQ... | 2023-02-16 00:00:00 | Read more |
2009090 | Fixes error 8657 when running queries that use percentile mode for memory grant feedback. | 2023-02-16 00:00:00 | Read more |
2021487 | Fixes spelling issues in Database Engine error messages in SQL Server 2022. | 2023-02-16 00:00:00 | Read more |
2042238 | Fixes "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x00 is unknown" error that occurs when using th... | 2023-02-16 00:00:00 | Read more |
2049442 | Consider the following scenario: - You have a transactional replication setup. - You execute the sp_changearticle stored procedure to change the property of an article on the publi... | 2023-02-16 00:00:00 | Read more |
2058060 | After you apply this update, you can audit events (EXTERNAL GOVERNANCE TURNED ON and EXTERNAL GOVERNANCE TURNED OFF) that correspond to external governance enable/disable actions (... | 2023-02-16 00:00:00 | Read more |
2068781 | Fixes a gradual memory leak in the SQL Server process (the high usage under MEMORYCLERK_SOSNODE) caused by the Log Reader Agent in transactional replication. | 2023-02-16 00:00:00 | Read more |
2069101 | Fixes an issue where Database Mail fails to send email messages and logs the following error message in the SQL Server error log, when used in a contained availability group (AG): ... | 2023-02-16 00:00:00 | Read more |
2075503 | Fixes an issue where the read query on a readable secondary replica may be aborted or return unexpected results if the query uses a heap and forwarding records are present in the h... | 2023-02-16 00:00:00 | Read more |
2076990 | Fixes the following error that occurs when running the change data capture (CDC) Control task fails: Could not load file or assembly 'Microsoft.SqlServer.DtsMsg, Version=16.100.0.0... | 2023-02-16 00:00:00 | Read more |
2078803 | Fixes potential memory access violations and incorrect results when executing specific Data Analysis Expressions (DAX) queries that trigger the internal Horizontal Fusion query opt... | 2023-02-16 00:00:00 | Read more |
2081891 | Fixes an exception that occurs when JSON_ARRAY/JSON_OBJECT return values are used in a parameter in functions that take strings. After you apply this fix, return values of JSON_ARR... | 2023-02-16 00:00:00 | Read more |
2082644 | Fixes an issue where any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege level role can create or overwrite arbitrary files on the machine hosting S... | 2023-02-16 00:00:00 | Read more |
2084307 | Fixes index inconsistency or incorrect results that may occur in the following scenario: 1. You enable accelerated database recovery (ADR) and snapshot isolation. 2. You roll back ... | 2023-02-16 00:00:00 | Read more |
2086044 | Fixes an issue where an authenticated attacker could affect SQL Server memory when executing a specially crafted CREATE STATISTICS or UPDATE STATISTICS statement. | 2023-02-16 00:00:00 | Read more |
2087479 | After you apply this update, you need at least the control server permission to run the procedure sys.sp_xtp_force_gc. This update changes the implementation of the procedure to a ... | 2023-02-16 00:00:00 | Read more |
2088539 | Adds the queries and category of the Microsoft Customer Experience Improvement Program (CEIP) telemetry to SQL Server 2022. | 2023-02-16 00:00:00 | Read more |
2089261 | Fixes an issue where any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege level role can create or overwrite arbitrary files on the machine hosting S... | 2023-02-16 00:00:00 | Read more |
1021159 | Adds the NullOnInvalid method for geometry and geography spatial data types to properly handle invalid spatial data. This enables you to have consistent behavior regardless of whet... | 2023-02-16 00:00:00 | Read more |
2122726 | Lock escalation policy propagation from a user table that has spatial columns to the internal table of related spatial indexes is enabled, which minimizes the chance of deadlocks i... | 2023-02-16 00:00:00 | Read more |
2086005 | Fixes an access violation exception that occurs in sqlmin.dll!sort_persistresumableprogress when you try to run the CREATE INDEX command that uses the RESUMABLE = ON option. | 2023-02-16 00:00:00 | Read more |
2122673 | The fix stops reporting transient error conditions that @@ERROR previously occurred when running queries by using a plan stored in Query Store (QDS). | 2023-02-16 00:00:00 | Read more |
2162840 | Fixes a self-deadlock issue where internal update statistic transactions persist locks, which can cause unresolved deadlocks with user queries. The issue occurs because the lock is... | 2023-02-16 00:00:00 | Read more |
2021484 | Fixes spelling issues in Database Engine error messages in SQL Server 2019. | 2023-02-16 00:00:00 | Read more |
2116382 | Fixes a failure to raise the proper data type overflow error when a comma-separated values (CSV) file has an integer (int) value larger than the maximum value of int and you run SE... | 2023-02-16 00:00:00 | Read more |
1943179 | Fixes an assertion failure (Location: schemamgr.cpp:1253; Expression: !regularPVSHobt->m_NeedsRefresh && !longtermPVSHobt->m_NeedsRefresh) that may occur when you run sys.dm_tran_p... | 2023-02-16 00:00:00 | Read more |
1990621 | After you apply this fix, the cluster_nodename returns valid results when you query sys.dm_server_services in SQL Server 2019. | 2023-02-16 00:00:00 | Read more |
2114705 | Fixes an issue with differential backup skipping new Page Free Space (PFS) pages after a data file grows around a PFS boundary (a multiple of 8,088 pages; 64,704 KB), resulting in ... | 2023-02-16 00:00:00 | Read more |
2134470 | Fixes a non-yielding scheduler condition (Msg 17883) that occurs when backup operations can't properly handle abort signals in some cases while waiting for pending I/O writes. | 2023-02-16 00:00:00 | Read more |
2069963 | Fixes error 41842 that's incorrectly shown even when natively compiled stored procedures or in-memory transactions don't insert many records in a single transaction. Here's the err... | 2023-02-16 00:00:00 | Read more |
2153945 | Fixes an assertion failure (Location: execcoll.cpp:1305; Expression: 'savepointId > HkTxSavePointDefault') that occurs during the savepoint cleanup in a Hekaton transaction. | 2023-02-16 00:00:00 | Read more |
2044132 | Fixes an access violation issue that occurs on the secondary replica of an Always On availability group while accessing the empty conversation list. This issue occurs due to a conc... | 2023-02-16 00:00:00 | Read more |
2025412 | After you apply this fix, the SQL Server performance counter 'Log File(s) Size (KB)' for the SQLServer:Databases object is correctly updated for secondary replicas in an Always On ... | 2023-02-16 00:00:00 | Read more |
1992694 | Fixes a failure of the SQL Server resource DLL (hadrres.dll) to report SQLSTATE when you retrieve the health information from SQL Server and SQLGetData returns SQL_ERROR. | 2023-02-16 00:00:00 | Read more |
2023266 | Fixes an assertion failure that occurs in natively compiled modules when the Inner FOR JSON operator is followed by an operator that buffers the corresponding objects, such as anot... | 2023-02-16 00:00:00 | Read more |
2012343 | Performance issues and deadlocks occur on SQL Server Agent in the msdb database that has automated backups. In addition, you see the following error messages in the SQL Server Agen... | 2023-02-16 00:00:00 | Read more |
2116348 | Fixes error 692 that occurs when you create a non-clustered index under the following scenario: - A clustered index already exists in the table. - You create a non-clustered index ... | 2023-02-16 00:00:00 | Read more |
2068768 | Fixes a gradual memory leak in the SQL Server process (the high usage under MEMORYCLERK_SOSNODE) caused by the Log Reader Agent in transactional replication. | 2023-02-16 00:00:00 | Read more |
2151106 | Fixes error 241 that occurs while running the Snapshot Agent, and the system date format was changed to a different format than the one used by SQL Server. Error message: Conversio... | 2023-02-16 00:00:00 | Read more |
2086544 | Fixes an issue with Change Tracking manual cleanup that caused internal tables to have orphaned records. Previously if the stored procedure experienced a lock timeout on a given ta... | 2023-02-16 00:00:00 | Read more |
2133575 | Resolves a query performance issue that affects change tracking autocleanup and manual cleanup queries. Note You need to turn on trace flags 8286 and 8287, as this forces the clean... | 2023-02-16 00:00:00 | Read more |
2123502 | Fixes an assertion issue (Location: tabcreat.cpp:16938; Expression: idIS/8 < sizeof(bmIndexId)) that occurs when you run ALTER TABLE ALTER COLUMN on a table that has many indexes a... | 2023-02-16 00:00:00 | Read more |
2030140 | Fixes an issue where the sqlcmd utility doesn't honor the sqlcmd command ":!!" when you run operating system (OS) commands. For more information, see sqlcmd Commands. | 2023-02-16 00:00:00 | Read more |
2047657 | Consider the following scenario: - You have a transactional replication setup. - You execute the sp_changearticle stored procedure to change the property of an article on the publi... | 2023-02-16 00:00:00 | Read more |
2104413 | Fixes an issue where the temporary linked server created by the Log Reader Agent isn't always properly dropped when the publisher is in an Always On availability group (AG) and the... | 2023-02-16 00:00:00 | Read more |
2129325 | Fixes error 8992 [Check Catalog Msg 3853, State 1: Attribute (owning_principal_id=ID) of row (principal_id=ID) in sys.database_principals does not have a matching row (principal_id... | 2023-02-16 00:00:00 | Read more |
308163385 | Starting in SQL Server 2019 CU 19, CREATE EXTERNAL DATA SOURCE supports the use of TNS files when connecting to Oracle, by using the CONNECTION_OPTIONS parameter. | 2023-02-16 00:00:00 | Read more |
2145226 | Fixes a primary key violation error that's caused by a timing issue in change data capture (CDC) in SQL Server 2019. The CDC capture process may try to insert a duplicate start_lsn... | 2023-02-16 00:00:00 | Read more |
2139793 | Improvement: Automatically enables the binary large object (BLOB) trace ring buffer feature when a BLOB assertion failure is detected. This improvement helps to better investigate ... | 2023-02-16 00:00:00 | Read more |
2061830 | Fixes the following stack overflow error that occurs when deeply nesting APPLY operations: Msg 8621, Level 17, State 1, Line <LineNumber> The query processor ran out of stack space... | 2023-02-16 00:00:00 | Read more |
2086069 | Fixes an issue where an authenticated attacker could affect SQL Server memory when executing a specially crafted CREATE STATISTICS or UPDATE STATISTICS statement. | 2023-02-16 00:00:00 | Read more |
2013429 | Fixes an issue where the Distribution Agent returns a general message code 20046 instead of the connection failure message code 20084 when it fails to connect to the Subscriber by ... | 2023-02-16 00:00:00 | Read more |
2032954 | Fixes an Access Violation issue that occurs when removing the database snapshot files on the readable secondary replica of an Always On availability group that has the buffer pool ... | 2023-02-16 00:00:00 | Read more |
2137926 | Fixes an issue where schema modification (Sch-M) locks are acquired on foreign key tables when altering columns on the primary tables even if the transaction isn't related to the f... | 2023-02-16 00:00:00 | Read more |
2192500 | Updates the version of msoledbsql.msi from 18.2.3 to 18.6.5 in SQL Server 2019, which resolves signature issues for custom actions. For more information, see Release notes for the ... | 2023-02-16 00:00:00 | Read more |
2087572 | After you apply this update, you need at least the control server permission to run the procedure sys.sp_xtp_force_gc. This update changes the implementation of the procedure to a ... | 2023-02-16 00:00:00 | Read more |
2147190 | This improvement adds Extended Events functionality to enhance the periodic primary replica to secondary replica notification investigation in availability groups for an in-memory ... | 2023-02-16 00:00:00 | Read more |
2120779 | Fixes a rare issue where memory corruption in the ODBC driver can occur in communications between two SQL Server instances. This issue occurs when the target SQL Server instance us... | 2023-02-16 00:00:00 | Read more |
2086067 | Fixes an issue where any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege level role can create or overwrite arbitrary files on the machine hosting S... | 2023-02-16 00:00:00 | Read more |
2118499 | FIX: Database accessibility issues with high-volume customer workloads that use EKM for encryption and key generation | 2023-02-16 00:00:00 | Read more |
2118514 | FIX: Database accessibility issues with high-volume customer workloads that use EKM for encryption and key generation | 2023-02-16 00:00:00 | Read more |
2024688 | KB5017788 - FIX: ParameterRuntimeValue is missing from the Showplan XML when you use the DMV sys.dm_exec_query_statistics_xml - Microsoft Support | 2023-02-16 00:00:00 | Read more |
2046472 | KB5022920 - FIX: Table-valued function that uses a parameter and the OPTION (OPTIMIZE FOR) clause gives incorrect results on the first run - Microsoft Support | 2023-02-16 00:00:00 | Read more |
2016962 | KB5018231 - FIX: Error 20598 after adding columns that have default constraints as part of the primary key for an existing table and configuring transactional replication - Microso... | 2023-02-16 00:00:00 | Read more |
14976696 | KB5017788 - FIX: ParameterRuntimeValue is missing from the Showplan XML when you use the DMV sys.dm_exec_query_statistics_xml - Microsoft Support | 2023-02-16 00:00:00 | Read more |
14810743 | KB5018231 - FIX: Error 20598 after adding columns that have default constraints as part of the primary key for an existing table and configuring transactional replication - Microso... | 2023-02-16 00:00:00 | Read more |
2033037 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2026953 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2048784 | Error when running remote procedure call (RPC) over strict connections. | 2023-02-14 00:00:00 | Read more |
2116918 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2095172 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2163971 | Updates Microsoft.Data.SqlClient assemblies used by the mashup engine to address security vulnerability discussed in | 2023-02-14 00:00:00 | Read more |
2033040 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2029152 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2120772 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2095153 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2028824 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2026948 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2044588 | Removes log4j component that's used by SQL Server Integration Services (SSIS). | 2023-02-14 00:00:00 | Read more |
2120770 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2089289 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2033041 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2029154 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2120769 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2095094 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2033042 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2026956 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2120766 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2095088 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2033044 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2026957 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2120758 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2094939 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2033043 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2029155 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2120764 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2094950 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2033045 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2029156 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2120756 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2094937 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2033047 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2026959 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2120753 | In rare circumstances, a memory corruption in the ODBC driver can occur in communications between two SQL Server-based servers. This issue occurs if the target SQL server uses a do... | 2023-02-14 00:00:00 | Read more |
2094935 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2033048 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
2045746 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can run codes on the computer that's hosting SQL Server as the account that's running... | 2023-02-14 00:00:00 | Read more |
2094933 | Any member who has the DQS KB Operator (dqs_kb_operator) role or a higher privilege-level role can create or overwrite arbitrary files on the computer that's hosting SQL Server as ... | 2023-02-14 00:00:00 | Read more |
2033050 | An authenticated attacker could affect SQL Server memory when running a specially crafted CREATE or UPDATE STATISTICS statement. | 2023-02-14 00:00:00 | Read more |
13200684 | KB4521739 - FIX: Error occurs when CDC capture process tries to insert duplicate key in table "cdc.lsn_time_mapping" in SQL Server 2016, 2017 and 2019 - Microsoft Support | 2023-01-11 00:00:00 | Read more |
13200683 | KB4521739 - FIX: Error occurs when CDC capture process tries to insert duplicate key in table "cdc.lsn_time_mapping" in SQL Server 2016, 2017 and 2019 - Microsoft Support | 2023-01-11 00:00:00 | Read more |
14487676 | KB4538688 - FIX: Severe spinlock contention occurs in SQL Server 2019 - Microsoft Support | 2022-12-13 00:00:00 | Read more |
14298184 | KB4538688 - FIX: Severe spinlock contention occurs in SQL Server 2019 - Microsoft Support | 2022-12-13 00:00:00 | Read more |
13694925 | KB4538688 - FIX: Severe spinlock contention occurs in SQL Server 2019 - Microsoft Support | 2022-12-13 00:00:00 | Read more |
13414966 | KB4538688 - FIX: Severe spinlock contention occurs in SQL Server 2019 - Microsoft Support | 2022-12-13 00:00:00 | Read more |
13336034 | KB4538688 - FIX: Severe spinlock contention occurs in SQL Server 2019 - Microsoft Support | 2022-12-13 00:00:00 | Read more |
13211960 | KB4522405 - FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019 - Microsoft Support | 2022-10-18 00:00:00 | Read more |
13136089 | KB4522405 - FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019 - Microsoft Support | 2022-10-18 00:00:00 | Read more |
11953689 | KB4338960 - FIX: "PAGE_FAULT_IN_NONPAGED_AREA" Stop error when enumerating contents in a SQL Server FileTable directory - Microsoft Support | 2022-10-18 00:00:00 | Read more |
15016426 | KB5018050 - Improvement: Add new Azure SQL Database service tier options to the Stretch Database feature - Microsoft Support | 2022-09-29 00:00:00 | Read more |
14931590 | KB5018050 - Improvement: Add new Azure SQL Database service tier options to the Stretch Database feature - Microsoft Support | 2022-09-29 00:00:00 | Read more |
15029590 | The Filestream RsFx driver may cause an access violation for IRP_MJ_NETWORK_QUERY_OPEN requests (Windows API GetFileAttributes), which may be triggered by a third-party application... | 2022-09-28 00:00:00 | Read more |
14993959 | An application that is running at Read Committed Snapshot Isolation (RCSI) may not see data committed by an XA transaction. | 2022-09-28 00:00:00 | Read more |
14989385 | The filegroup IDs of the files that belong to the clone database can be incorrect if the source database has gaps in the filegroup IDs due to the removal of files or filegroups. Wh... | 2022-09-28 00:00:00 | Read more |
14987604 | Error 9833 "Invalid data for UTF8-encoded characters" can occur in one of the following scenarios: 1. You create a merge publication or merge push subscription on a publication dat... | 2022-09-28 00:00:00 | Read more |
14982785 | The assertion "Status.Prepared" can occur when you perform a cross-database transaction that involves a memory-optimized table. | 2022-09-28 00:00:00 | Read more |
14964738 | The FILESTREAM feature is not enabled after you restart the operating system because of race conditions from multiple instances of SQL Server. In the error log, you can see the fol... | 2022-09-28 00:00:00 | Read more |
14942316 | High CPU usage occurs when you enable change tracking on a large number of tables and do automatic or manual cleanup of the change tracking tables. | 2022-09-28 00:00:00 | Read more |
14939335 | The installation of Microsoft SQL Server 2019 that uses the configuration file ignores the value for the ASCOLLATION parameter and falls back to the system default locale. Note If ... | 2022-09-28 00:00:00 | Read more |
14931025 | Access violation dumps are generated sometimes when stored procedures that use the Scalar UDF Inlining feature are used. | 2022-09-28 00:00:00 | Read more |
14930792 | In Microsoft SQL Server 2019 and 2017, an index creation over a persisted computed column and partition function fails. Additionally, the following error 8624 occurs: Internal Quer... | 2022-09-28 00:00:00 | Read more |
14916804 | Executing multiple SQL Server Agent jobs that use proxy accounts at the same time fails due to BCryptDecrypt issues. Additionally, one of the following errors occurs: 1. Unable to ... | 2022-09-28 00:00:00 | Read more |
14914170 | You use the sp_changereplicationserverpasswords stored procedure to change the password of the Microsoft SQL Server login used by replication agents. It fails and causes the follow... | 2022-09-28 00:00:00 | Read more |
1890457 | Fixes a high CPU usage condition that occurs when you enable change tracking on a large number of tables and do automatic or manual cleanup of the change tracking tables. | 2022-09-28 00:00:00 | Read more |
14913295 | Managed Backup fails intermittently because of the missing completion signal from the SQL Server Agent that causes backups for databases to stop. | 2022-09-28 00:00:00 | Read more |
14654914 | The NOLOCK hint still requests the IS Object lock. Thus, unexpected blocking occurs on the string-type column that has the columnstore index. | 2022-09-28 00:00:00 | Read more |
14654911 | The READ_COMMITTED_SNAPSHOT isolation level still requests the IS Object lock. Thus, unexpected blocking occurs on the string-type column that has the columnstore index. | 2022-09-28 00:00:00 | Read more |
1926384 | Transactional replication fails with errors 12300 and 12301 when the replication is enabled on memory optimized tables with computed columns and index on nullable columns respectiv... | 2022-09-28 00:00:00 | Read more |
1945560 | KB5019307 - FIX: Changes aren't applied to a newly added article in a peer-to-peer topology with a custom port - Microsoft Support | 2022-09-28 00:00:00 | Read more |
14979551 | KB5017551 - FIX: Installing SQL Server CUs may trigger IndexOutOfRangeException - Microsoft Support | 2022-09-28 00:00:00 | Read more |
14978498 | KB5017718 - FIX: Access violation when you use the query_post_execution_plan_profile XEvent and reuse the same execution plan - Microsoft Support | 2022-09-28 00:00:00 | Read more |
14979530 | KB5017551 - FIX: Installing SQL Server CUs may trigger IndexOutOfRangeException - Microsoft Support | 2022-09-28 00:00:00 | Read more |
12200692 | KB4458593 - Update adds lightweight query profiling hint in SQL Server 2016 and 2017 - Microsoft Support | 2022-09-22 00:00:00 | Read more |
12123248 | KB4340742 - FIX: Access to SSAS by using HTTP fails in SQL Server - Microsoft Support | 2022-09-22 00:00:00 | Read more |
11677210 | KB4135137 - FIX: SSMS and SSDT do not escape double quotation marks when you export data as CSV - Microsoft Support | 2022-09-22 00:00:00 | Read more |
11634330 | KB4092554 - FIX: Errors 627 or 12324 occur when cross database transactions are promoted to distributed transactions in SQL Server Availability Group - Microsoft Support | 2022-09-22 00:00:00 | Read more |
14302678 | KB5008184 - FIX: ForceLastGoodPlan doesn't account for aborted and timed out queries in regression detection logic - Microsoft Support | 2022-09-20 00:00:00 | Read more |
14915051 | Resolves the Denial of Service (DoS) vulnerability for the Newtonsoft library in SQL Server 2017. | 2022-09-20 00:00:00 | Read more |
15009086 | An access violation may occur after you apply SQL Server 2017 Cumulative Update 30 (CU30). This issue can occur when you perform a bulk insert operation followed by a SELECT statem... | 2022-09-20 00:00:00 | Read more |
14676488 | Error 9003 occurs with the incorrect log sequence number (LSN) when you do a subsequent restore after specifying the LSN at the virtual log file (VLF) boundary by using the RESTORE... | 2022-09-20 00:00:00 | Read more |
14924205 | Non-yielding dumps occur frequently on ColumnStoreAttributeCache::ColumnStoreColumnAttributeNode::GetSegmentById. | 2022-09-20 00:00:00 | Read more |
14989388 | The non-primary filegroup misses all files after you restore the clone database to SQL Server 2017 and change it to read-write mode. Additionally, you receive the following error m... | 2022-09-20 00:00:00 | Read more |
14923181 | A memory leak occurs in the range index of in-memory tables after the parallel index scan. | 2022-09-20 00:00:00 | Read more |
14923920 | A memory leak occurs under "Range Index Heap" on the in-memory table that has non-clustered indexes, whenever there are concurrent inserts. | 2022-09-20 00:00:00 | Read more |
14209349 | Memory-optimized tempdb metadata (HkTempDB) keeps consuming memory under VARHEAP: LOB Page Allocator. | 2022-09-20 00:00:00 | Read more |
14860451 | The read-only request still goes to the read-write primary node in an Always On availability group when the read-only routing list node goes down. | 2022-09-20 00:00:00 | Read more |
14904061 | An assertion failure occurs on secondary replica when you use Always On availability groups in high-latency networks in SQL Server 2017. You may see this assertion failure in the e... | 2022-09-20 00:00:00 | Read more |
13766490 | Performance issues and deadlocks occur on SQL Server Agent in the msdb database that has automated backups. In addition, you see the following error messages in the SQL Server Agen... | 2022-09-20 00:00:00 | Read more |
14876278 | A non-yielding scheduler dump occurs in sqldk!SOS_MemoryWorkSpace::Lookup. | 2022-09-20 00:00:00 | Read more |
14914142 | Error 208 occurs when you use the sp_changereplicationserverpasswords stored procedure to change stored passwords for the Microsoft SQL Server login used by replication agents. Her... | 2022-09-20 00:00:00 | Read more |
14962805 | High CPU usage occurs when you enable change tracking on a large number of tables and do automatic or manual cleanup of the change tracking tables. | 2022-09-20 00:00:00 | Read more |
14964725 | The FILESTREAM feature is not enabled after you restart the operating system because of race conditions from multiple instances of SQL Server. In the error log, you can see the fol... | 2022-09-20 00:00:00 | Read more |
14918513 | KB5008184 - FIX: ForceLastGoodPlan doesn't account for aborted and timed out queries in regression detection logic - Microsoft Support | 2022-09-20 00:00:00 | Read more |
14927877 | An assertion dump occurs in RaiseInternalError while processing binary large object (BLOB) data. | 2022-08-11 00:00:00 | Read more |
14924053 | In Microsoft SQL Server 2019, running parameterized queries skips the SelOnSeqPrj rule. Therefore, pushdown does not occur. | 2022-08-11 00:00:00 | Read more |
14923176 | A memory leak occurs in the range index of in-memory tables after the parallel index scan. | 2022-08-11 00:00:00 | Read more |
14915360 | The floating-point exception error 3628 occurs when you run a full-text query that contains a FREETEXTTABLE function. | 2022-08-11 00:00:00 | Read more |
14915048 | Resolves the Denial of Service (DoS) vulnerability for the Newtonsoft library in SQL Server 2019. | 2022-08-11 00:00:00 | Read more |
14910661 | A memory leak occurs under "Range Index Heap" on the in-memory table that has non-clustered indexes, whenever there are concurrent inserts. | 2022-08-11 00:00:00 | Read more |
14889419 | A system assertion failure occurs and the query is terminated when you try to use a derived table within a MATCH predicate. | 2022-08-11 00:00:00 | Read more |
14884007 | When you create a peer-to-peer publication by using the last-write-wins conflict resolution policy, and one or few articles in this publication have just 1 column which is the prim... | 2022-08-11 00:00:00 | Read more |
14871059 | An access violation occurs when you create a CLR assembly after restoring a database from a snapshot. | 2022-08-11 00:00:00 | Read more |
14862654 | An access violation occurs when XVBChainTails::UpdateChainTails updates m_pNewVersionChainTailInsert and m_pOldVersionChainTailInsert and these values are not allocated. | 2022-08-11 00:00:00 | Read more |
14861989 | In Microsoft SQL Server 2019, an index creation script fails and returns error message 8624. Here is the error message: Internal Query Processor Error: The query processor could no... | 2022-08-11 00:00:00 | Read more |
14860468 | The read-only request still goes to the read-write primary node in an Always On availability group when the read-only routing list node goes down. | 2022-08-11 00:00:00 | Read more |
14856153 | The last-chance exception handling for a Columnstore index occurs after a log-full 9002 error. | 2022-08-11 00:00:00 | Read more |
14826907 | Incorrect reporting of physical sector size for Linux block devices can cause unexpected "misaligned log IOs" warnings for log shipping and Always On availability groups. | 2022-08-11 00:00:00 | Read more |
14822463 | An access violation occurs in CSession::DeleteBlobHandleFactoryPool while resetting the SESSION for reuse. | 2022-08-11 00:00:00 | Read more |
14812570 | A latch time-out occurs and the IOCP listener stalls when Service Broker connects to an endpoint by using database mirroring. Note This fix is available when TF 12323 is enabled. | 2022-08-11 00:00:00 | Read more |
14788992 | An access violation or an assertion failure occurs when you use the LAST_QUERY_PLAN_STATS feature while running a parallel query. | 2022-08-11 00:00:00 | Read more |
14780760 | An assertion dump occurs in sqlmin!BOSLockThreadHashTable::AddEntry during a log backup on a secondary replica of an availability group. | 2022-08-11 00:00:00 | Read more |
14764719 | An instance of SQL Server Express LocalDB fails to start and returns error 9003 after multiple backups on the model database. | 2022-08-11 00:00:00 | Read more |
14764631 | An access violation occurs when you try to use an aggregate function together with WITHIN GROUP (GRAPH PATH), and the query doesn't have a suitable MATCH clause. | 2022-08-11 00:00:00 | Read more |
14764339 | An access violation occurs, and the query is terminated when you use sp_cursoropen for SHORTEST_PATH over graph tables. | 2022-08-11 00:00:00 | Read more |
14758810 | A database may fail to resume synchronization during the failover of an Always On availability group because the session working on the database synchronization or recovery is kill... | 2022-08-11 00:00:00 | Read more |
14729398 | Creating edge constraints on graph tables meets an access violation when you use a node table instead of an edge table in the constraint. | 2022-08-11 00:00:00 | Read more |
14729381 | Adds support for the missing "Implementation" parameter when you use the SharePoint Online Lists. | 2022-08-11 00:00:00 | Read more |
14726037 | QDS remains stuck in read-only mode if the size-based cleanup index rebuild releases space asynchronously. | 2022-08-11 00:00:00 | Read more |
14708235 | Traversing long IAM chains may cause a non-yielding scheduler and associated dump. | 2022-08-11 00:00:00 | Read more |
14679511 | This fix resolves the following issues: An online index rebuild may not finish when the database is using the simple recovery model. An assertion failure about the latch owner occu... | 2022-08-11 00:00:00 | Read more |
14676485 | Error 9003 occurs with the incorrect log sequence number (LSN) when you do a subsequent restore after specifying the LSN at the virtual log file (VLF) boundary by using the RESTORE... | 2022-08-11 00:00:00 | Read more |
14673410 | Error 2706 occurs when you run DBCC CHECKDB WITH EXTENDED_LOGICAL_CHECKS against a database by using the Table-Valued Function (TVF) that uses indexes. Here is the error message: T... | 2022-08-11 00:00:00 | Read more |
14638786 | The dynamic management view (DMV) sys.dm_hadr_availability_replica_cluster_nodes returns the invalid node_name for certain queries after applying SQL Server 2019 Cumulative Update ... | 2022-08-11 00:00:00 | Read more |
14537603 | The optimizer may fail to produce the plan and throw an error when you enable the Scalar User-Defined Function (UDF) Inlining feature and try to update a partitioned view by using ... | 2022-08-11 00:00:00 | Read more |
312902877 | When you use the AZDATA BDC ROTATE command to rotate the password of a SQL Server big data cluster that uses Active Directory, you receive the following error message: Failed to up... | 2022-08-11 00:00:00 | Read more |
14507664 | An error occurs when you execute the internal.cleanup_server_log stored procedure in the SSISDB database. Here is the error message: #MS_SSISServerCleanupJobLogin##. A cursor with ... | 2022-08-11 00:00:00 | Read more |
14350896 | Improves the response time of the system view sys.spt_columns_odbc_view on Linux. | 2022-08-11 00:00:00 | Read more |
14692739 | KB5017100 - FIX: Access violation dump file occurs during a columnstore index scan - Microsoft Support | 2022-08-11 00:00:00 | Read more |
14874191 | KB5016780 - Improvement: Provide the closest matching non-UTF8 collation for the client drivers that don't support UTF-8 - Microsoft Support | 2022-08-11 00:00:00 | Read more |
14708231 | KB5013181 - FIX: A subscription is still active after the distribution retention period expires - Microsoft Support | 2022-08-11 00:00:00 | Read more |
14561271 | KB5013181 - FIX: A subscription is still active after the distribution retention period expires - Microsoft Support | 2022-08-11 00:00:00 | Read more |
14576382 | KB5014047 - Improvement: Match the lock escalation policy for the change tracking table to that of the base table - Microsoft Support | 2022-07-13 00:00:00 | Read more |
14669410 | This fix resolves the following issues: An assertion failure occurs when your query contains the MERGE statement. The online index rebuild can't finish when you use the simple reco... | 2022-07-13 00:00:00 | Read more |
14812566 | A latch time-out occurs and the IOCP listener stalls when Service Broker connects to an endpoint by using database mirroring. Note This fix is available when TF 12323 is enabled. | 2022-07-13 00:00:00 | Read more |
14605069 | An access violation occurs when you try to truncate specific partitions of a table by using the $Partition function if the function name or table name does not exist. | 2022-07-13 00:00:00 | Read more |
14644630 | Dropping temp tables causes an unresolved deadlock and dump file in some rare cases. | 2022-07-13 00:00:00 | Read more |
14673411 | Error 2706 occurs when you run DBCC CHECKDB WITH EXTENDED_LOGICAL_CHECKS against a database by using the Table-Valued Function (TVF) that uses indexes. Here is the error message: T... | 2022-07-13 00:00:00 | Read more |
14783868 | In Microsoft SQL Server 2017, running parameterized queries skips the SelOnSeqPrj rule. Therefore, pushdown does not occur. | 2022-07-13 00:00:00 | Read more |
14861990 | In Microsoft SQL Server 2017, an index creation script fails and returns error message 8624. Here is the error message: Internal Query Processor Error: The query processor could no... | 2022-07-13 00:00:00 | Read more |
14576377 | KB5014047 - Improvement: Match the lock escalation policy for the change tracking table to that of the base table - Microsoft Support | 2022-07-13 00:00:00 | Read more |
12478582 | KB4470811 - FIX: Log message displays “N/A” when using ring buffer target to hold extended event data in memory in SQL Server - Microsoft Support | 2022-06-21 00:00:00 | Read more |
12333342 | KB4459576 - Update makes you set order for processing of business rules for Master Data Services database in SQL Server - Microsoft Support | 2022-06-21 00:00:00 | Read more |
12347661 | KB4460203 - FIX: Pacemaker may kill the resource agent processes when operation times out in SQL Server 2017 AlwaysOn Availability Group - Microsoft Support | 2022-06-21 00:00:00 | Read more |
12245670 | KB4340730 - FIX: Assertion error occurs when a query that uses a linked server is cancelled in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-21 00:00:00 | Read more |
12041154 | KB4340134 - FIX: Error when a role that is defined with a restricted column is used to run a drillthrough query in SSAS - Microsoft Support | 2022-06-21 00:00:00 | Read more |
12111717 | KB4340837 - FIX: Error 3906 when a hotfix is applied on a server that has a SQL Server database snapshot on a pull subscription database - Microsoft Support | 2022-06-21 00:00:00 | Read more |
11974804 | KB4295233 - FIX: Database recovery could stop responding if it contains in-memory objects and a recovery failure is encountered during a race condition in SQL Server 2017 - Microso... | 2022-06-21 00:00:00 | Read more |
12062786 | KB4339875 - Improvements for Always On Availability Groups on a Pacemaker cluster in SQL Server - Microsoft Support | 2022-06-21 00:00:00 | Read more |
11983950 | KB4135113 - FIX: Change tracking record is inconsistent during an update on a table that has a clustered or unique index in SQL Server - Microsoft Support | 2022-06-21 00:00:00 | Read more |
11701193 | KB4074862 - FIX: Unexpected error when you create a subcube in SQL Server 2016 and 2017 Analysis Services (Multidimensional model) - Microsoft Support | 2022-06-21 00:00:00 | Read more |
11290048 | KB4078302 - FIX: Processing a tabular model database, table, or partition takes long to process in SSAS 2017 - Microsoft Support | 2022-06-21 00:00:00 | Read more |
11281513 | KB4042948 - FIX: Data-driven subscription fails after you upgrade from SSRS 2008 to SSRS 2016 - Microsoft Support | 2022-06-21 00:00:00 | Read more |
11455814 | KB4057280 - FIX: High CPU use when large index is used in a query on a memory-optimized table in SQL Server - Microsoft Support | 2022-06-21 00:00:00 | Read more |
11457913 | KB4077103 - FIX: In-Memory databases in Availability Group hang during recovery in SQL Server 2017 - Microsoft Support | 2022-06-21 00:00:00 | Read more |
14729552 | An authenticated attacker could affect SQL Server memory when executing a specially crafted query using $partition against a table with a Column Store index. | 2022-06-14 00:00:00 | Read more |
14729555 | An authenticated attacker could affect SQL Server memory when executing a specially crafted query using $partition against a table with a Column Store index. | 2022-06-14 00:00:00 | Read more |
14729291 | An authenticated attacker could affect SQL Server memory when executing a specially crafted query using $partition against a table with a Column Store index. | 2022-06-14 00:00:00 | Read more |
14750560 | An authenticated attacker could affect SQL Server memory when executing a specially crafted query using $partition against a table with a Column Store index. | 2022-06-14 00:00:00 | Read more |
14333094 | KB5014298 - FIX: Error 3241 occurs during executing RESTORE DATABASE OR RESTORE LOG - Microsoft Support | 2022-06-04 00:00:00 | Read more |
13607135 | KB4567166 - FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13598931 | KB4561305 - FIX: Concurrent inserts against tables with columnstore indexes may cause queries to stop responding in SQL Server - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13402561 | KB4532432 - Mssql-conf tool fails if IPV6 is disabled on the Linux system - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13329355 | KB4538205 - Improvement: Download new CAB files that have fixes for R/Python runtime features - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13329379 | KB4536005 - FIX: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13324007 | KB4529876 - FIX: Memory may not get released when you process partitions with data in SQL Server - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13323992 | KB4521599 - FIX: Non-yielding scheduler condition occurs if large number of row-column values are processed in row groups in SQL Server 2016 or 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13598930 | KB4561305 - FIX: Concurrent inserts against tables with columnstore indexes may cause queries to stop responding in SQL Server - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13324006 | KB4529876 - FIX: Memory may not get released when you process partitions with data in SQL Server - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13264329 | KB4538205 - Improvement: Download new CAB files that have fixes for R/Python runtime features - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13315613 | KB4538275 - FIX: Database initialization may fail by using automatic seeding in SQL Server 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13546338 | KB3195888 - FIX: High CPU usage causes performance issues in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13087323 | KB4506912 - FIX: Concurrent inserts into a CCI can cause deadlock under memory pressure in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13387895 | KB4567166 - FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13087320 | KB4512567 - FIX: "Non-yielding Scheduler" occurs when you run queries with batch-mode hash join and/or sort in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12947204 | KB4497222 - FIX: Database may crash when multiple threads update permissions on the same database in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12887076 | KB4501542 - FIX: Refresh command stops responding occasionally because of thread deadlock in SSAS 2017 Tabular mode - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12519854 | KB4469600 - FIX: Peer-to-peer replication fails in SQL Server 2016 and 2017 if the host name is not uppercase - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12119927 | KB4338773 - FIX: Deadlock errors when you run an SSIS package in parallel in SQL Server - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12942301 | KB4512151 - FIX: Access Violation occurs when you use LOG function with a remote query in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12947196 | KB4502428 - FIX: Assertion error occurs when you run a query to access sys.dm_db_xtp_checkpoint_files in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12947201 | KB4494225 - FIX: Access violation occurs when you run a query against sys.availability_replicas in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12947197 | KB4491560 - FIX: Access violation occurs when you query sys.dm_hadr_availability_replica_states in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12996125 | KB4513237 - FIX: Async secondary replica receives logs from primary replica in SQL Server 2017 on Linux but it does not harden or redone - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12947202 | KB4494805 - FIX: Adding new Publication may fail if distribution database is in AG and collation is set to BIN in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
13045214 | KB4512016 - FIX: Syscommittab cleanup causes a lock escalation that will block the syscommittab flush in SQL Server 2014, 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12947198 | KB4497928 - FIX: Indirect checkpoints on tempdb database cause "Non-yielding scheduler" error in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12750851 | KB4480652 - FIX: SQL Writer Service can cause undetected deadlocks on system DMV when you do a VSS backup - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12670267 | KB4499423 - FIX: Performance issues and timeouts may occur while connecting with SQL Server 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12700549 | KB4490144 - Improvement: New XEvent sqlserver.security_authentication_perf_interrogate_login is added in SQL Server 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12580378 | KB4488026 - FIX: Access violation occurs when automatic statistics update happens on tables with incremental statistics in SQL Server 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12673173 | KB4490140 - FIX: Stack Dump occurs in the change tracking cleanup process in SQL Server 2014, 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12677802 | KB4490138 - FIX: Filtered NCI over a CCI may not be maintained when the table is updated in a way that none of the key or included columns of the NCI are changed in SQL Server 2016... | 2022-06-02 00:00:00 | Read more |
12594078 | KB4486931 - FIX: Upgrade to SQL Server 2016 SP2 CU3 or CU4 fails with an error when sysadmin account "sa" is renamed in SQL Server 2016 and 2017 - Microsoft Support | 2022-06-02 00:00:00 | Read more |
12552012 | KB4483593 - Snapshot Isolation and Savepoint support added for Availability Group databases on the same instance with DTC enabled in SQL Server - Microsoft Support | 2022-06-02 00:00:00 | Read more |
14711983 | KB5014137 - Improvement: Make the EO-compliant Microsoft Extensibility SDK available for Java for SQL Server 2019 - Microsoft Support | 2022-05-17 00:00:00 | Read more |
14689800 | KB5014136 - Improvement: Make the EO-compliant ML service CAB packages available for SQL Server 2019 - Microsoft Support | 2022-05-17 00:00:00 | Read more |
14662671 | KB5013391 - FIX: Remove the adutil tool from SQL Server 2019 - Microsoft Support | 2022-05-17 00:00:00 | Read more |
14541295 | KB5012964 - Improvement: Add an XEvent for tracking manual user plan forcing and unforcing - Microsoft Support | 2022-05-17 00:00:00 | Read more |
13324042 | KB4530955 - FIX: Error 18456 occurs when you run DMV queries on the SQL Server 2019 or 2017 instance after rebuilding system databases - Microsoft Support | 2022-05-17 00:00:00 | Read more |
13262554 | KB4530955 - FIX: Error 18456 occurs when you run DMV queries on the SQL Server 2019 or 2017 instance after rebuilding system databases - Microsoft Support | 2022-05-17 00:00:00 | Read more |
14694104 | A memory dump and assertion failure "Dependencies.CommitDepCountOut >= 1" may occur after a transaction rolls back if in-memory tempdb is enabled. | 2022-04-18 00:00:00 | Read more |
14670801 | Executing a query where the plan contains an adaptive join may fail together with the following error: Msg 8624, Level 16, State 21, Procedure <ProcedureName>, Line <LineNumber> [B... | 2022-04-18 00:00:00 | Read more |
14669436 | The bulk insert is blocked when the lock of the target table is held by another session, and the session of the bulk insert will remain in SQL Server until its lock is released eve... | 2022-04-18 00:00:00 | Read more |
14669019 | Removes log4j2 used by SQL Server 2019 Integration Services (SSIS) to avoid any potential security issues. | 2022-04-18 00:00:00 | Read more |
14662889 | An assertion failure occurs in tempdb during the rollback of transactions, and triggers a server shutdown. The following dump file is generated: <DateTime> **Dump thread - spid = 0... | 2022-04-18 00:00:00 | Read more |
14660934 | Resolves stalled I/O completion port (IOCP) issues when a heavily used service broker is configured on an availability group database. | 2022-04-18 00:00:00 | Read more |
14623946 | Adds two new Extended Events, iam_page_range_cache_invalidation and iam_page_range_cache_population, to respectively capture Index Allocation Map (IAM) page range cache invalidatio... | 2022-04-18 00:00:00 | Read more |
14621802 | The sqlcmd utility crashes when the batch_terminator parameter "-c" is set to ";" in SQL Server 2019. | 2022-04-18 00:00:00 | Read more |
14618099 | A "Non-yielding Scheduler" issue and dump occur during a backup operation because of concurrent Page Free Space (PFS) updates. | 2022-04-18 00:00:00 | Read more |
14617331 | Improves the response time of the Sqldumper.exe utility when in-memory objects are used in SQL Server or once existed. | 2022-04-18 00:00:00 | Read more |
14617266 | Supports more flexible cleanup and merge operations by changing In-Memory during restore operations. | 2022-04-18 00:00:00 | Read more |
14608912 | Exposes the option 'ldaphostcanon' by the mssql-conf tool so that you don't have to manually edit the mssql.conf file to enable or disable ldaphostcanon. | 2022-04-18 00:00:00 | Read more |
14579161 | Assume that you have tables with data on the peers and then you set a peer-to-peer publication by using a last-writer conflict detection policy. The distribution agent occurs the f... | 2022-04-18 00:00:00 | Read more |
14577537 | In SQL Server 2019 Master Data Services, the child nodes don't open in the derived hierarchy when a child entity is joined with a recursive hierarchy. | 2022-04-18 00:00:00 | Read more |
14576308 | Calling CMEDScan::EvaluateCmpResult to evaluate filter predicates for the current metadata scan misses the "NE" predicate, which causes an "INVALID_SWITCH_VALUE" exception. | 2022-04-18 00:00:00 | Read more |
14573042 | Restoring from a compressed backup that contains filestream objects randomly fails if the process is run through the Virtual Device Interface (VDI) client. Here are the error messa... | 2022-04-18 00:00:00 | Read more |
14569908 | An assertion failure, lck_sufficient (lckMode, LCK_M_IX) || lck_sufficient (lckMode, LCK_M_BU), occurs when you use Accelerated Database Recovery (ADR). | 2022-04-18 00:00:00 | Read more |
14566765 | An "Out of memory" error occurs when you take a log backup frequently and Stolen Server Memory grows at a synchronous secondary in Availability Groups | 2022-04-18 00:00:00 | Read more |
14558430 | Running DBCC CHECKDB will report "corruption" errors when you use SQL Server graph databases that have edge constraints. | 2022-04-18 00:00:00 | Read more |
14555263 | An access violation occurs if a query on sys.database_scoped_configurations is waiting for a shared lock on the database while another thread holds the exclusive lock to drop the s... | 2022-04-18 00:00:00 | Read more |
14549500 | The database recovery process is chosen as the deadlock victim on Availability Group (AG) failover under certain circumstances. The following error message is generated: <DateTime>... | 2022-04-18 00:00:00 | Read more |
14535149 | Memory-Optimized TempDB Metadata keeps consuming memory under VARHEAP: LOB Page Allocator, which causes out-of-memory (OOM) exceptions like error 701 or FAIL_PAGE_ALLOCATION. | 2022-04-18 00:00:00 | Read more |
14522124 | Dropping temp tables in some rare cases causes an unresolved deadlock and dump. | 2022-04-18 00:00:00 | Read more |
14520366 | The logon trigger may fail unexpectedly for the pooled connections even when the criteria are not met during the connection reset, and causes the following error: Error:17892, Seve... | 2022-04-18 00:00:00 | Read more |
14516287 | A view, created in a table that has an XML index, cannot return the correct result because of missing '%' in LIKE predicate on columns hidden for xml_index_nodes table. | 2022-04-18 00:00:00 | Read more |
14508625 | Improves the dynamic management view (DMV) to help debug the out-of-memory (OOM) issues. | 2022-04-18 00:00:00 | Read more |
14507662 | The query processor can't produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join. | 2022-04-18 00:00:00 | Read more |
14507658 | SQL Server disconnects a session when it gets an attention and INTERLEAVED_EXECUTION_TVF is enabled. | 2022-04-18 00:00:00 | Read more |
14507656 | The function sys.fn_hadr_backup_is_preferred_replica returns different results on primary or secondary replicas of read-scale availability groups (Cluster_Type=None) when running o... | 2022-04-18 00:00:00 | Read more |
14506574 | An access violation dump occurs when the query runs for a long time in parallel and tries to determine the version of the rowgroup for the particular transactions to read. | 2022-04-18 00:00:00 | Read more |
14396500 | The AlwaysOn_Health extended event doesn't set STARTUP_STATE to ON after installing a SQL Server Cumulative Update. | 2022-04-18 00:00:00 | Read more |
14332258 | A database freezes its I/O during a VSS backup but never thaws the I/O. This can lead to latch timeouts | 2022-04-18 00:00:00 | Read more |
14332252 | SQL Server 2019 using XTP UserDB for staging tables has a steady growing trend for "VARHEAP\Storage internal heap" in dm_db_xtp_memory_consumers that leads to OOM/41805 errors over... | 2022-04-18 00:00:00 | Read more |
14235719 | Restoring transaction logs from a compressed backup of a TDE-enabled database may cause a "misaligned I/O" message to be logged in the SQL Server error log: <DateTime> There have b... | 2022-04-18 00:00:00 | Read more |
14304467 | KB5008296 - FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message - Microsoft Support | 2022-03-30 00:00:00 | Read more |
14609626 | Traversing long IAM chains may cause a non-yielding scheduler and associated dump. | 2022-03-30 00:00:00 | Read more |
14553128 | Restoring from a compressed backup that contains filestream content occasionally fails when the restore is run by using the Virtual Device Interface (VDI) client. The following err... | 2022-03-30 00:00:00 | Read more |
14506575 | An access violation dump occurs when the query runs for a long time in parallel and tries to determine the version of the rowgroup for the particular transactions to read. | 2022-03-30 00:00:00 | Read more |
14287010 | Improves the response time of the Sqldumpr.exe utility when in-memory objects are used in SQL Server or once existed. | 2022-03-30 00:00:00 | Read more |
14607995 | Lets more flexible cleanup and merge operations enable by changing In-Memory during restore operations. | 2022-03-30 00:00:00 | Read more |
14401587 | An error occurs after the failover of a Distributed Availability Group (AG) that attempts to connect to the secondary AG listener with application intent set to READ ONLY. Here are... | 2022-03-30 00:00:00 | Read more |
14451454 | The AlwaysOn_Health extended event doesn't set STARTUP_STATE to ON after installing a SQL Server Cumulative Update. | 2022-03-30 00:00:00 | Read more |
14577899 | The database recovery process is chosen as the deadlock victim on Availability Group (AG) failover under certain circumstances. The following error message is generated: <DateTi... | 2022-03-30 00:00:00 | Read more |
14144674 | A filtered index becomes corrupted after you drop a computed column on the same table, and the filtered index corruptions are reported as 8951 and 8955 errors when you run DBCC CHE... | 2022-03-30 00:00:00 | Read more |
14587111 | The Table Valued Function (TVF) misses calling the execution plan if the same TVF is referenced more than once in the same SQL query. | 2022-03-30 00:00:00 | Read more |
14412963 | The query against the dynamic management view (DMV) sys.dm_os_ring_buffers may cause an access violation (AV). | 2022-03-30 00:00:00 | Read more |
14401562 | An access violation occurs when you use FileTables in SQL Server 2017. | 2022-03-30 00:00:00 | Read more |
14516280 | A view, created in a table that has an XML index, may not return the correct result because of missing '%' in LIKE predicate on columns hidden for xml_index_nodes table. | 2022-03-30 00:00:00 | Read more |
14422835 | KB5008296 - FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message - Microsoft Support | 2022-03-30 00:00:00 | Read more |
14641666 | KB5013207 - FIX: Python is broken after the runtime upgrades to Python 3.7 - Microsoft Support | 2022-03-30 00:00:00 | Read more |
13598911 | KB4563115 - FIX: Upgrade script fails if you use an Always On high availability group as a secondary replica in SQL Server - Microsoft Support | 2022-03-22 00:00:00 | Read more |
13598910 | KB4563115 - FIX: Upgrade script fails if you use an Always On high availability group as a secondary replica in SQL Server - Microsoft Support | 2022-03-22 00:00:00 | Read more |
13480950 | KB4568448 - FIX: Support for REJECTED_ROW_LOCATION parameter in CREATE EXTERNAL TABLE in SQL Server 2019 box product - Microsoft Support | 2022-02-18 00:00:00 | Read more |
14497737 | Adds improvement in capturing memory dumps on unexpected crashes in SQL Server 2019 on Linux | 2022-01-27 00:00:00 | Read more |
14491100 | Fixes an access violation that occurs in CXPort::Close after you use SQL Server 2019 Cumulative Update 14 (CU14) | 2022-01-27 00:00:00 | Read more |
14488550 | Fixes a parallel query executing in batch mode that may cause an access violation and memory dump after installing CU 14. | 2022-01-27 00:00:00 | Read more |
14465885 | Fixes the following error that occurs when you back up a database by using virtual device interface (VDI) on ubuntu docker container installed SQL Server 2019: Host_<DeviceName>_SQ... | 2022-01-27 00:00:00 | Read more |
14448989 | Fixes an issue where AVERAGEX(CURRENTGROUP()) function returns the incorrect result that is close to 0 unless you add 0.0 to the measure in the DAX query | 2022-01-27 00:00:00 | Read more |
14434937 | Fixes an issue where the specific statement for compilation in stored procedures seems "stuck" and shows sqlsource_transform until manual intervention | 2022-01-27 00:00:00 | Read more |
14428866 | Fixes an issue where the Shrink Database task in maintenance plans doesn't work in SQL Server 2019 | 2022-01-27 00:00:00 | Read more |
14421838 | Fixes a system-wide low memory issue that occurs when SQL Server commits memory above the maximum server memory under the memory model with the Lock Pages In Memory. Note You shoul... | 2022-01-27 00:00:00 | Read more |
14416748 | Fixes an assertion in CQPOnDemandTask::ExecuteQPJob if auto async update statistics is enabled. You may see this assert failure in the error log: Assertion: File: <sosmemobj.cpp>, ... | 2022-01-27 00:00:00 | Read more |
14412969 | Fixes the access violation sqldk!StringVPrintfWorkerW that occurs during the compilation of the query for Dynamic Management Views (DMVs) sys.dm_os_ring_buffers | 2022-01-27 00:00:00 | Read more |
14401590 | Fixes an error that occurs after a failover of a Distributed Availability Group that attempts to connect to the secondary AG listener with application intent set to READ ONLY | 2022-01-27 00:00:00 | Read more |
14401565 | Fixes an access violation that occurs when you use FileTable in SQL Server 2019 | 2022-01-27 00:00:00 | Read more |
14401082 | Fixes a committed memory accounting issue, which under some circumstances, FAIL_PAGE_ALLOCATION error could occur a few days after starting SQL Server services on Linux | 2022-01-27 00:00:00 | Read more |
14396775 | Adds the Reverting progress to SQL Server error logs in SQL Server 2019 just like the Recovery progress | 2022-01-27 00:00:00 | Read more |
14396483 | Adds improvement to capture sp_server_diagnostics XEvent in an AlwaysOn_health XEvent session when STATE is 3 (ERROR) to diagnose HADR Health Events | 2022-01-27 00:00:00 | Read more |
14394202 | Fixes the following error 104 that occurs when you use scalar User-Defined Function (UDF) lnlining in the ORDER BY clause during the query compilation that has a UNION operator: Ms... | 2022-01-27 00:00:00 | Read more |
14393059 | Fixes an issue about inconsistent data if you add a date that is between last day of 1899 and first day of March 1900 in the MDS add-in for Excel in SQL Server 2019 | 2022-01-27 00:00:00 | Read more |
14382474 | Fixes an issue where the output of sp_pkeys KEY_SEQ column doesn't conform to the ordering of columns defined in the Primary Key | 2022-01-27 00:00:00 | Read more |
14382100 | Fixes an issue where the dm_db_page_info function may record spurious corrupted pages entries in the suspect_pages table when calling the function against the transaction log file | 2022-01-27 00:00:00 | Read more |
14364622 | Fixes an issue where assertion failure on secondary replica when you use Always On availability groups in high-latency networks in SQL Server 2019. You may see this assert failure ... | 2022-01-27 00:00:00 | Read more |
14332270 | Fixes an issue where Cumulative Update (CU) patching fails with the following message when you set default data directory to Azure Blob Storage URL: The given path's format is not ... | 2022-01-27 00:00:00 | Read more |
14320308 | Fixes the memory release issue in execution of the STDistance spatial method while using spatial index. Before the fix, memory usage of MEMORYCLERK_SOSNODE gradually grew until all... | 2022-01-27 00:00:00 | Read more |
14312688 | Fixes an issue where java.nio.BufferOverflowException error occurs when using PolyBase external tables to query data from Hadoop. Note This error occurs when querying from a file t... | 2022-01-27 00:00:00 | Read more |
14300646 | Fixes the following insufficient memory error that occurs during In-Memory Online Transactional Processing (OLTP) if application native procedures update tables that have Large Obj... | 2022-01-27 00:00:00 | Read more |
14289674 | Fixes an issue where a filtered index becomes corrupted after you drop a computed column on the same table, and the filtered index corruptions are reported as 8951 and 8955 errors ... | 2022-01-27 00:00:00 | Read more |
14253634 | Fixes an issue where Distributed Replay Client may fail with an unhandled exception. This fix is for the Distributed Replay Client that is released with SQL Server 2019. The follow... | 2022-01-27 00:00:00 | Read more |
14227331 | Fixes an issue where the default trace on Linux rolls over before the limit size of 20 MB | 2022-01-27 00:00:00 | Read more |
14165626 | Fixes an issue where different conversion results are displayed in publisher and subscriber database tables when using the ASCII function to convert a column. For more information,... | 2022-01-27 00:00:00 | Read more |
14126931 | Fixes an issue where the tooltip of column name doesn't display in SQL Server 2019 Master Data Services (MDS) | 2022-01-27 00:00:00 | Read more |
14419546 | KB5009753 - FIX: Physical reads are counted two times for read-aheads - Microsoft Support | 2022-01-27 00:00:00 | Read more |
14288034 | Adds an improvement to enhance the security of machine keys by enabling you to change the default machine key location to a custom location by using SQL Platform Abstraction Layer ... | 2022-01-27 00:00:00 | Read more |
14500584 | KB5010653 - FIX: Database corruption after creating an external library in SQL Server 2019 - Microsoft Support | 2022-01-27 00:00:00 | Read more |
14196082 | KB5008647 - Improvement: Add mssql-conf and adutil utilities to SQL Server 2019 - Microsoft Support | 2022-01-27 00:00:00 | Read more |
14043526 | KB5010234 - FIX: Buffer overruns when data buffer spans multiple SNI packets - Microsoft Support | 2022-01-27 00:00:00 | Read more |
13313683 | KB5010246 - Improvement: Add 1 (true) and 0 (false) as valid values to mssql-conf Boolean settings - Microsoft Support | 2022-01-27 00:00:00 | Read more |
14459544 | KB5010555 - Improvement: Add the usage of signed certificates with multiple DNS names - Microsoft Support | 2022-01-27 00:00:00 | Read more |
13898015 | Fixes the following error that occurs when you execute the internal.cleanup_server_log stored procedure in the SSISDB database: #MS_SSISServerCleanupJobLogin##. A cursor with the n... | 2022-01-13 00:00:00 | Read more |
14042373 | Fixes an issue in which some of the temporary working folders are not cleared when many R queries are run in parallel | 2022-01-13 00:00:00 | Read more |
14335023 | Fixes the following error that occurs when you back up a database by using virtual device interface (VDI) on ubuntu docker container installed SQL Server 2017: Host_515697bb-6009-4... | 2022-01-13 00:00:00 | Read more |
14195813 | Fixes an issue where sys.fn_hadr_backup_is_preferred_replica returns different results on secondary replicas of read-scale availability groups (Cluster_Type=None) when running on s... | 2022-01-13 00:00:00 | Read more |
14293376 | Fixes an issue where executing concurrent queries with Large Object (LOB) parameters causes failed assertions in tmpilb.cpp and generates minidumps | 2022-01-13 00:00:00 | Read more |
14287618 | Fixes an issue where SQL Server disconnects a session when it gets an attention and INTERLEAVED_EXECUTION_TVF is enabled | 2022-01-13 00:00:00 | Read more |
14391931 | Fixes an issue in which the query processor can't produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join | 2022-01-13 00:00:00 | Read more |
14396480 | Adds improvement to capture sp_server_diagnostics XEvent in an AlwaysOn_health XEvent session when STATE is 3 (ERROR) to diagnose HADR Health Events | 2022-01-13 00:00:00 | Read more |
14227334 | Fixes an issue where the default trace on Linux rolls over before the limit size of 20 MB | 2022-01-13 00:00:00 | Read more |
13491016 | KB4552478 - FIX: Distribution Agent "Parameterized values for above command" log message is missing - Microsoft Support | 2021-11-24 00:00:00 | Read more |
14328046 | Fixes an access violation exception that may occur when sp_server_diagnostics is executed. | 2021-11-22 00:00:00 | Read more |
14311616 | Fixes the following error that occurs when you restore a database file (.mdf) that is larger than 15 GB on SQL Server 2019 Big Data Cluster (BDC) with high availability (HA) config... | 2021-11-22 00:00:00 | Read more |
14306964 | Fixes an issue causing the assertion fNoReaderWriterConflict. | 2021-11-22 00:00:00 | Read more |
14309095 | KB5008107 - Improvement: Cardinality estimation in Spatial TVF functions in SQL Server 2019 - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14302888 | Fixes an issue where the DirectQuery query has no table join clause when you have a DirectQuery model with many-to-many relationship defined and run a DAX query. | 2021-11-22 00:00:00 | Read more |
14295884 | Fixes an issue where you encounter an "ex_terminator - Last chance exception handling" memory dump. The memory dump is associated with a lease timeout while the recovery of an Alwa... | 2021-11-22 00:00:00 | Read more |
14295855 | Fixes an Access Violation (AV) that can occur when you run dynamic management views (DMVs) queries. | 2021-11-22 00:00:00 | Read more |
14294740 | Fixes a non-yielding scheduler dump in sqldk!SOS_MemoryWorkSpace::Lookup. | 2021-11-22 00:00:00 | Read more |
14288658 | Fixes an issue where SQL Server 2019 stops responding and crashes due to "ex_terminator - Last chance exception handling" when you use SQL Server Service Broker. | 2021-11-22 00:00:00 | Read more |
14276893 | Fixes an Access Violation (AV) at RbpEarlyFilter::TinyBitmapFilterSIMD that occurs when you run queries on CLUSTERED COLUMNSTORE INDEX (CCI) tables. Here is the dump file: Stack Du... | 2021-11-22 00:00:00 | Read more |
14255609 | Fixes the following runtime error that occurs when you build a 32-bit application where Microsoft.SqlServer.Rmo.dll is referenced from C:\Program Files (x86)\Microsoft SQL Server\1... | 2021-11-22 00:00:00 | Read more |
14254562 | Fixes a self-deadlock issue where thread always waits for HASH_TABLE_DELETE (HTDELETE) when you run parallel query in batch mode. | 2021-11-22 00:00:00 | Read more |
14253642 | Fixes the issue in MDS 2017, where the derived hierarchy permissions are lost in the copied version | 2021-11-22 00:00:00 | Read more |
14307204 | KB5008114 - FIX: The built-in SESSION_CONTEXT returns wrong results in parallel plans - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14253632 | Fixes the issue in SSAS 2017, where msmdsrv.log doesn't work when you customize the values of the configuration settings MaxFileSizeMB and MaxNumberOfLogFiles | 2021-11-22 00:00:00 | Read more |
14253625 | Fixes an issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated | 2021-11-22 00:00:00 | Read more |
14253624 | Fixes the issue in SSIS 2017 when Dimension Processing returns the following error message: clsid {ID}" could not be created and error code 0x80070005 "Access is denied.". Make sur... | 2021-11-22 00:00:00 | Read more |
14250829 | Fixes an issue where executing a query with BATCH_MODE_ON_ROWSTORE = ON causes the following error and a dump occurs during compilation of the execution plan: Msg 596, Level 21, St... | 2021-11-22 00:00:00 | Read more |
14307249 | KB5007719- FIX: Creating a resumable clustered index on a table with LOB causes corruption in SQL Server 2019 - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14227887 | Fixes an assert dump "pwchId && cwchId <= MAX_PATH && cwchId > 0" during Always On availability group (AG) Virtual Device Interface (VDI) seeding. | 2021-11-22 00:00:00 | Read more |
14199142 | Fixes an issue in which the query processor can't produce a query plan if the USE PLAN hint specifies a query plan that has a left outer join and an inner join. | 2021-11-22 00:00:00 | Read more |
14162439 | Fixes an issue where the following warning message occurs during the snapshot creation when you run the DBCC CHECKDB against a database that has a memory optimized filegroup: [WARN... | 2021-11-22 00:00:00 | Read more |
14134000 | Fixes an issue where the CollectPageLatchFields can cause an access violation (AV) under certain timing conditions when the latch_suspend_end XEvent is turned on. The underlying re... | 2021-11-22 00:00:00 | Read more |
14080213 | Fixes the failed assertion that occurs due to implicit conversion where predicate's precision is greater than the value. Msg 3624, Level 20, State 1, Line <LineNumber> A system ass... | 2021-11-22 00:00:00 | Read more |
13966323 | Fixes the EXCEPTION_INVALID_CRT_PARAMETER dump that is generated on insert or update of wide replicated table. | 2021-11-22 00:00:00 | Read more |
14307250 | KB5007744 - FIX: Add checkpoint handling for the first row in NonOptimizedGetAndInsertRows - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14265296 | KB5007794 - FIX: Non-yielding scheduler dumps during the recovery of a secondary availability database with a database snapshot - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14253635 | KB5004936 - FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2017 and 2019 - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14235259 | KB5007842 - FIX: An assertion occurs when Compute Scalar operator operates on computed, temporary lobs with batch mode - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14132334 | KB5004936 - FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2017 and 2019 - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14155040 | KB5004936 - FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2017 and 2019 - Microsoft Support | 2021-11-22 00:00:00 | Read more |
14216911 | Fixes an issue where Cumulative Update (CU) patching fails with the following message when you set default data directory to Azure Blob Storage URL: The given path's format is not ... | 2021-10-27 00:00:00 | Read more |
13748048 | Prevents ghost cleanup from triggering a memory dump during latch time-out in SQL Server 2019 | 2021-10-27 00:00:00 | Read more |
14080201 | Fixes the failed assertion that occurs due to implicit conversion where predicate's precision is greater than the value: Msg 3624, Level 20, State 1, Line LineNumber &nb... | 2021-10-27 00:00:00 | Read more |
14182231 | Fixes an issue where an incorrect name entry in sys.servers can result in Always On Availability Group (AG) replica being removed when the server name does not match Windows hostna... | 2021-10-27 00:00:00 | Read more |
14279542 | Fixes an access violation exception that may occur when sp_server_diagnostics is executed | 2021-10-27 00:00:00 | Read more |
14232818 | Fixes an issue in which the extended event version in the Alwayson_health session isn't changed automatically during the Cumulative Update upgrade and downgrade. | 2021-10-27 00:00:00 | Read more |
14266687 | Fixes an issue where the output of sp_pkeys KEY_SEQ column doesn't conform to the ordering of columns defined in the Primary Key | 2021-10-27 00:00:00 | Read more |
13788019 | Fixes an issue where Failover Cluster Instance (FCI) setup fails on secondary nodes of a PolyBase scale-out group in a standard edition of SQL Server 2019. Here is the error messag... | 2021-10-27 00:00:00 | Read more |
14247979 | KB5007158 - FIX: Access violation occurs when you use LOB data type with columnstore indexes in SQL Server 2017 - Microsoft Support | 2021-10-27 00:00:00 | Read more |
14269761 | KB5007381 - FIX: Sp_execute_external_script fails after you configure new runtime and remove a new Cumulative Update patch in SQL Server 2017 - Microsoft Support | 2021-10-27 00:00:00 | Read more |
14269725 | KB5007039 - FIX: You encounter error messages 8114 or 22122 when performing change tracking cleanup - Microsoft Support | 2021-10-27 00:00:00 | Read more |
13952862 | Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled | 2021-10-27 00:00:00 | Read more |
14243398 | KB5006632 - FIX: An assertion dump occurs many times in SQL Server 2019 - Microsoft Support | 2021-10-18 00:00:00 | Read more |
14239890 | KB5006665 - Improvement: Last Writer Wins and support for P2P database in Availability Group - Microsoft Support | 2021-10-12 00:00:00 | Read more |
14233210 | Fixed an issue where resumable clustered index creation may sometimes fail if a table has lots of LOB columns | 2021-10-05 00:00:00 | Read more |
14232813 | Fixes an issue about extended event version in Alwayson_health session is not changed automatically during Cumulative Update upgrade and downgrade | 2021-10-05 00:00:00 | Read more |
14218644 | Fixes an issue where you cannot complete image because the prepared instance is grayed out if you select [Database Engine Services] along with [Machine Learning Services and Langua... | 2021-10-05 00:00:00 | Read more |
14217780 | Fixes an issue where the assertion results in system suspend of asynchronous secondary replica: DateTime spid36s SQL Server Assertion: File: <"sql\\ntdbms\\storeng\\dfs\\trans\\lsn... | 2021-10-05 00:00:00 | Read more |
14209346 | Fixes an issue where Memory Optimized TempDB Metadata keeps consuming memory under VARHEAP: LOB Page Allocator | 2021-10-05 00:00:00 | Read more |
14190636 | Fixes an issue where Polybase is not generating the partition predicates for pushdown which generates the following error when you do cross-database joins in the backend where one ... | 2021-10-05 00:00:00 | Read more |
14182758 | Fixes an issue where an incorrect name entry in sys.servers can result in Always On Availability Group (AG) replica being removed when the server name does not match Windows hostna... | 2021-10-05 00:00:00 | Read more |
14181146 | Fixes an issue where you cannot edit jobs by using SQL Server Management Studio (SSMS) if SQLAgent permissions are granted at AD group level | 2021-10-05 00:00:00 | Read more |
14178357 | Adds pOwnerSess to the error message to find the owner session Id that runs the Log Reader Agent or log - related procedure in SQL Server 2017 | 2021-10-05 00:00:00 | Read more |
14127274 | Fixes an issue where 22836 error occurs when you add CDC job again after deleting CDC capture and removing jobs in SQL Server Agent | 2021-10-05 00:00:00 | Read more |
14115230 | Fix an issue where AD Authentication in SQL Server BDC encounters an error "enctype aes256-cts found in keytab but cannot decrypt ticket" if support for 128-bit and 256-bit Kerbero... | 2021-10-05 00:00:00 | Read more |
14021172 | Fixes an Access Violation that occurs in SQL Server 2019 when you attempt to add file to database that has backup in progress | 2021-10-05 00:00:00 | Read more |
13981081 | Fixes an issue where Integration Services packages start failing with the following error when you set ExecuteOutOfProcess property to True: Data Flow Task: Error: The Oracle Sourc... | 2021-10-05 00:00:00 | Read more |
13952861 | Fixes an intra-query deadlock that occurs with certain queries when verbose truncation feature is enabled | 2021-10-05 00:00:00 | Read more |
14237645 | KB5006359 - FIX: A dump occurs if you use the same synonym for a user-defined function in the view definition - Microsoft Support | 2021-10-05 00:00:00 | Read more |
14173307 | KB4530907 - Improvement: Corrupted statistics can be detected by using extended_logical_checks in SQL Server 2016, 2017, and 2019 - Microsoft Support | 2021-10-05 00:00:00 | Read more |
14194152 | KB5005788 - FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled - Microsoft Support | 2021-10-05 00:00:00 | Read more |
13262555 | KB4530907 - Improvement: Corrupted statistics can be detected by using extended_logical_checks in SQL Server 2016, 2017, and 2019 - Microsoft Support | 2021-10-05 00:00:00 | Read more |
14117711 | KB4530907 - Improvement: Corrupted statistics can be detected by using extended_logical_checks in SQL Server 2016, 2017, and 2019 - Microsoft Support | 2021-10-05 00:00:00 | Read more |
14193874 | KB5005788 - FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled - Microsoft Support | 2021-10-05 00:00:00 | Read more |
14082568 | KB5004766 - Improvement: Failover Cluster DNN in SQL Server 2017 - Microsoft Support | 2021-09-29 00:00:00 | Read more |
14068003 | KB5003596 - FIX: Log line is verbose when Always On Availability Group has many databases in SQL Server 2019 and 2016 - Microsoft Support | 2021-09-16 00:00:00 | Read more |
13974250 | KB5003937 - Improvement: New XEvents temp_table_cache_trace and temp_table_destroy_list_trace are created in SQL Server 2019 and 2016 - Microsoft Support | 2021-09-16 00:00:00 | Read more |
13679282 | KB4578579 - Improvement: Availability Group listener without the load balancer in SQL Server 2016, 2017 and 2019 - Microsoft Support | 2021-09-16 00:00:00 | Read more |
13421858 | KB4541303 - FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server - Microsoft Support | 2021-09-16 00:00:00 | Read more |
13359752 | KB4541132 - Improvement: Size and retention policy are increased in default XEvent trace system_health in SQL Server 2016, 2017 and 2019 - Microsoft Support | 2021-09-16 00:00:00 | Read more |
14089545 | KB5004466 - FIX: Update SQL Server 2017 and 2016 CEIP service to send usage and diagnostic data to a new endpoint - Microsoft Support | 2021-09-16 00:00:00 | Read more |
14082570 | KB4578579 - Improvement: Availability Group listener without the load balancer in SQL Server 2016, 2017 and 2019 - Microsoft Support | 2021-09-16 00:00:00 | Read more |
13277345 | KB4537868 - Improvement: Enable DNN feature in SQL Server 2016 and 2019 FCI - Microsoft Support | 2021-09-15 00:00:00 | Read more |
13198910 | KB4515772 - FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server - Microsoft Support | 2021-09-15 00:00:00 | Read more |
13288075 | KB4531386 - FIX: Assertion occurs when sys.sp_cdc_enable_table is used to enable CDC on column set table in SQL Server 2016 and 2017 - Microsoft Support | 2021-09-15 00:00:00 | Read more |
13193748 | KB4526524 - FIX: SQL update package does not update Local DB files correctly when installed using SqlLocalDb.msi - Microsoft Support | 2021-09-15 00:00:00 | Read more |
13198909 | KB4515772 - FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server - Microsoft Support | 2021-09-15 00:00:00 | Read more |
12949744 | KB4506023 - FIX: Geocentric Datum of Australia 2020 is added to SQL Server 2017, 2016, and 2014 - Microsoft Support | 2021-09-15 00:00:00 | Read more |
12644521 | KB4493329 - FIX: Error occurs when sp_addarticle is used to add article for transactional replication to memory-optimized table on subscriber in SQL Server 2017 and 2016 - Microsof... | 2021-09-15 00:00:00 | Read more |
12686636 | KB4500511 - Improvement: Improve CDC supportability and usability with In-Memory Databases - Microsoft Support | 2021-09-15 00:00:00 | Read more |
12347608 | KB4480630 - Improvement: Enhancement adds sql_statement_post_compile extended event in SQL Server 2017 and 2016 - Microsoft Support | 2021-09-15 00:00:00 | Read more |
11195379 | KB4046056 - FIX: Assertion occurs when you access memory-optimized table through MARS in SQL Server 2017 or 2016 - Microsoft Support | 2021-09-15 00:00:00 | Read more |
14138749 | KB5004734 - FIX: Persisted computed columns not being consistently blocked for Columnstore index - Microsoft Support | 2021-09-14 00:00:00 | Read more |
14124394 | KB5004573 - FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2017 and 2019 - Microsoft Support | 2021-09-14 00:00:00 | Read more |
14123177 | KB5004750 - FIX: SQL Server often crashes when network.forceencryption property is set to '1' - Microsoft Support | 2021-09-14 00:00:00 | Read more |
14157183 | Fixes an issue where the DAX query with union generates an exception: An unexpected error occurred (file 'FileName', line LineNumber, function 'FunctionName'). | 2021-09-14 00:00:00 | Read more |
14143953 | Fixes the issue in SSAS 2017, where msmdsrv.log doesn't work when you customize the values of the configuration settings MaxFileSizeMB and MaxNumberOfLogFiles | 2021-09-14 00:00:00 | Read more |
13905587 | Fixes the issue in SSIS 2017 when Dimension Processing returns clsid {ID}" could not be created and error code 0x80070005 "Access is denied.". Make sure that the component is regis... | 2021-09-14 00:00:00 | Read more |
14175901 | Fixes the issue in MDS 2017, where the derived hierarchy permissions are lost in the copied version | 2021-09-14 00:00:00 | Read more |
14125523 | Adds improvement to report SQL Server native error 35217 in the AlwaysOn_health XEvent log: DateTimeSpid Error: 35217, Severity: 16, State: 1. DateTim... | 2021-09-14 00:00:00 | Read more |
14031937 | Fixes an issue where Last_sent_time and Last_received_time columns in DMV dm_hadr_database_replica_states does not get updated | 2021-09-14 00:00:00 | Read more |
14135181 | Fixes an issue in SQL Server 2017 where you may encounter an Access Violation or Assertion when using the sys.dm_exec_query_statistics_xml Dynamic Management View | 2021-09-14 00:00:00 | Read more |
14134263 | Fixes an issue in SQL Server 2017 and 2019 where you may encounter an Access Violation or Assertion when using the sys.dm_exec_query_statistics_xml Dynamic Management View | 2021-09-14 00:00:00 | Read more |
14200277 | Fix to keep the PERSIST_SAMPLE_PERCENT value for statistics on an indexed column after index rebuild | 2021-09-14 00:00:00 | Read more |
14178360 | Adds pOwnerSess to the error message to find the owner session Id that runs the Log Reader Agent or log-related procedure in SQL Server 2017 | 2021-09-14 00:00:00 | Read more |
14193531 | Fixes the issue where datatype is not included in the warning message instead a 'null' value appears: Warning: Article with '(null)' data type column is not supported with memory o... | 2021-09-14 00:00:00 | Read more |
14130524 | Fixes missing data in the Change Data Capture (CDC) side table and adds additional error handling to prevent data loss | 2021-09-14 00:00:00 | Read more |
14148246 | KB5004734 - FIX: Persisted computed columns not being consistently blocked for Columnstore index - Microsoft Support | 2021-09-14 00:00:00 | Read more |
14149041 | Fixes an issue where Distributed Replay Client may fail with an unhandled exception. This fix is for the Distributed Replay Client that is released with SQL Server 2017. The follow... | 2021-09-14 00:00:00 | Read more |