SQL Server 2019 articles, fixes and updates

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2019 starts with letter F that have been released. The list is daily updated.

4538581 FIX: Scalar UDF Inlining issues in SQL Server 2022 and 2019 Q4538581 KB4538581 May 16, 2023
5017009 FIX: sp_replmonitorsubscriptionpendingcmds returns incorrect pending commands for P2P replication Q5017009 KB5017009 May 12, 2023
4575940 FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server Q4575940 KB4575940 April 26, 2023
5022920 FIX: Table-valued function that uses a parameter and the OPTION (OPTIMIZE FOR) clause gives incorrect results on the first run Q5022920 KB5022920 February 16, 2023
5018231 FIX: Error 20598 after adding columns that have default constraints as part of the primary key for an existing table and configuring transactional replication Q5018231 KB5018231 February 16, 2023
5017788 FIX: ParameterRuntimeValue is missing from the Showplan XML when you use the DMV sys.dm_exec_query_statistics_xml Q5017788 KB5017788 February 16, 2023
4521739 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 Q4521739 KB4521739 January 11, 2023
4538688 FIX: Severe spinlock contention occurs in SQL Server 2019 Q4538688 KB4538688 December 13, 2022
4522405 FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019 Q4522405 KB4522405 October 18, 2022
5019307 FIX: Changes aren't applied to a newly added article in a peer-to-peer topology with a custom port Q5019307 KB5019307 September 28, 2022
5017718 FIX: Access violation when you use the query_post_execution_plan_profile XEvent and reuse the same execution plan Q5017718 KB5017718 September 28, 2022
5017551 FIX: Installing SQL Server CUs may trigger IndexOutOfRangeException Q5017551 KB5017551 September 28, 2022
5008184 FIX: ForceLastGoodPlan doesn't account for aborted and timed out queries in regression detection logic Q5008184 KB5008184 September 20, 2022
5017100 FIX: Access violation dump file occurs during a columnstore index scan Q5017100 KB5017100 August 11, 2022
5013181 FIX: A subscription is still active after the distribution retention period expires Q5013181 KB5013181 August 11, 2022
5014298 FIX: Error 3241 occurs during executing RESTORE DATABASE OR RESTORE LOG Q5014298 KB5014298 June 4, 2022
4567166 FIX: Assertion failure occurs when you try to insert record into a page in fully logged mode in SQL Server 2017 and 2019 Q4567166 KB4567166 June 2, 2022
4561305 FIX: Concurrent inserts against tables with columnstore indexes may cause queries to stop responding in SQL Server Q4561305 KB4561305 June 2, 2022
4536005 FIX: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server Q4536005 KB4536005 June 2, 2022
4529876 FIX: Memory may not get released when you process partitions with data in SQL Server Q4529876 KB4529876 June 2, 2022
5013391 FIX: Remove the adutil tool from SQL Server 2019 Q5013391 KB5013391 May 17, 2022
4530955 FIX: Error 18456 occurs when you run DMV queries on the SQL Server 2019 or 2017 instance after rebuilding system databases Q4530955 KB4530955 May 17, 2022
5008296 FIX: Missing change data capture cleanup execution isn't identified because of a deadlock without an error message Q5008296 KB5008296 March 30, 2022
4563115 FIX: Upgrade script fails if you use an Always On high availability group as a secondary replica in SQL Server Q4563115 KB4563115 March 22, 2022
4568448 FIX: Support for REJECTED_ROW_LOCATION parameter in CREATE EXTERNAL TABLE in SQL Server 2019 box product Q4568448 KB4568448 February 18, 2022
5010653 FIX: Database corruption after creating an external library in SQL Server 2019 Q5010653 KB5010653 January 27, 2022
5010234 FIX: Buffer overruns when data buffer spans multiple SNI packets Q5010234 KB5010234 January 27, 2022
5009753 FIX: Physical reads are counted two times for read-aheads Q5009753 KB5009753 January 27, 2022
4552478 FIX: Distribution Agent "Parameterized values for above command" log message is missing Q4552478 KB4552478 November 24, 2021
5008114 FIX: The built-in SESSION_CONTEXT returns wrong results in parallel plans Q5008114 KB5008114 November 22, 2021
5007842 FIX: An assertion occurs when Compute Scalar operator operates on computed, temporary lobs with batch mode Q5007842 KB5007842 November 22, 2021
5007794 FIX: Non-yielding scheduler dumps during the recovery of a secondary availability database with a database snapshot Q5007794 KB5007794 November 22, 2021
5007744 FIX: Add checkpoint handling for the first row in NonOptimizedGetAndInsertRows Q5007744 KB5007744 November 22, 2021
5007719 FIX: Creating a resumable clustered index on a table with LOB causes corruption in SQL Server 2019 Q5007719 KB5007719 November 22, 2021
5004936 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 Q5004936 KB5004936 November 22, 2021
5006632 FIX: An assertion dump occurs many times in SQL Server 2019 Q5006632 KB5006632 October 18, 2021
5005832 FIX: Cannot fetch a row by using OPENROWSET or OPENDATASOURCE and "MSOLEDBSQL" OLE DB driver for SQL Server in batch mode Q5005832 KB5005832 October 14, 2021
5006359 FIX: A dump occurs if you use the same synonym for a user-defined function in the view definition Q5006359 KB5006359 October 5, 2021
5005788 FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled Q5005788 KB5005788 October 5, 2021
5003596 FIX: Log line is verbose when Always On Availability Group has many databases in SQL Server 2019 and 2016 Q5003596 KB5003596 September 16, 2021
4541303 FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server Q4541303 KB4541303 September 16, 2021
4515772 FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server Q4515772 KB4515772 September 15, 2021
5004750 FIX: SQL Server often crashes when network.forceencryption property is set to '1' Q5004750 KB5004750 September 14, 2021
5004734 FIX: Persisted computed columns not being consistently blocked for Columnstore index Q5004734 KB5004734 September 14, 2021
5004573 FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2017 and 2019 Q5004573 KB5004573 September 14, 2021
5005321 FIX: Dropping an index from the view on primary may cause access violation on readable secondary Q5005321 KB5005321 August 4, 2021
5004733 FIX: Debug assert when a lock is acquired by the ParNested Transaction and attempts to get logged in sLog for the parent transaction Q5004733 KB5004733 August 4, 2021
5004649 FIX: Parallel redo failure on secondary replica in SQL Server 2019 Q5004649 KB5004649 August 4, 2021
5004560 FIX: Wrong results during Clustered Columnstore Index alter "index reorganize" in versioned scans in SQL Server 2017 and 2019 Q5004560 KB5004560 August 4, 2021
5001045 FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017 and 2019 Q5001045 KB5001045 August 4, 2021
4539340 FIX: Issue occurs when using PolyBase for SQL Server 2019 generic ODBC with drivers from Microsoft Access Database Engine Redistributable package Q4539340 KB4539340 June 11, 2021
5003870 FIX: Support using the PolyBase SQL Server connector to create external table with remote database name containing a period Q5003870 KB5003870 June 10, 2021
5003869 FIX: Support schema reflection stored procedures for the Polybase generic ODBC connector Q5003869 KB5003869 June 10, 2021
5003750 FIX: Performance issues occur when metadata is scanned to find keys to be sent to the AE enclave in SQL Server 2019 Q5003750 KB5003750 June 10, 2021
5003589 FIX: Error 19432 occurs when Log Writer thread fails to send a log back and stop log capture on Log Writer threads in SQL Server 2019 Q5003589 KB5003589 June 10, 2021
5003342 FIX: SQL Server Express LocalDB can't start or connect to shared instances of SQL Server Express LocalDB 2019 or 2017 Q5003342 KB5003342 June 10, 2021
4581886 FIX: Joins not getting pushed down for PolyBase query that joins multiple external tables Q4581886 KB4581886 June 10, 2021
4023170 FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 Q4023170 KB4023170 June 10, 2021
5000715 FIX: Failures with log reader agent occurs when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017 or 2016 Q5000715 KB5000715 May 11, 2021
4589350 FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server Q4589350 KB4589350 May 11, 2021
5000649 FIX: Wrong results due to undetected concatenation parameters from scalar expression Q5000649 KB5000649 April 7, 2021
5001526 FIX: Access violation occurs when Dynamic Data Masking and nested UDFs are used in SQL Server 2019 Q5001526 KB5001526 April 6, 2021
5001517 FIX: Metadata deadlock causes availability issues when changing auditing properties in SQL Server 2019 Q5001517 KB5001517 April 6, 2021
5001266 FIX: Access violation occurs when hybrid buffer pool is enabled in SQL Server 2019 Q5001266 KB5001266 April 6, 2021
5001159 FIX: Assertion failure occurs when Online Clustered Columnstore Index Rebuild reuses truncated hobt instead of new hobt in SQL Server 2019 Q5001159 KB5001159 April 6, 2021
5001044 FIX: Wrong results occur when you run a query on In-Memory optimized tables in SQL Server Q5001044 KB5001044 April 6, 2021
5000650 FIX: Incorrect results occur when you run query on In-memory optimized table that has clustered columnstore index in SQL Server 2016 or 2019 Q5000650 KB5000650 April 6, 2021
4548523 FIX: Database creation to Azure blob storage from SQL Server 2017 or 2019 on Linux may fail with error Q4548523 KB4548523 April 6, 2021
4486936 FIX: "Login failed for user" error occurs when you run Maintenance plan with SQL login account in SQL Server Q4486936 KB4486936 April 6, 2021
5000670 FIX: Error occurs when you map an Oracle NUMBER type to a T-SQL DECIMAL/NUMERIC type Q5000670 KB5000670 March 18, 2021
5000656 FIX: Incorrect type of data mask is applied when DDM is used with queries that have UDFs in SQL Server 2019 Q5000656 KB5000656 March 18, 2021
5000655 FIX: Memory leak may occur when SQL Server auditing feature is used on an instance of SQL Server 2019 Q5000655 KB5000655 March 18, 2021
4585971 FIX: User session is in rollback state indefinitely after it is killed in SQL Server Q4585971 KB4585971 March 18, 2021
4568447 FIX: Automatic seeding failure occurs for a secondary replica in SQL Server Q4568447 KB4568447 February 27, 2021
4582558 FIX: SQL Server service fails to start in Linux operating system Q4582558 KB4582558 February 25, 2021
4589170 FIX: Indefinite hang during cube processing after applying SSAS 2016 SP2 CU7 Q4589170 KB4589170 February 24, 2021
4588977 FIX: SQL Server crashes when Afd!DbCreateSocketOperation process fails Q4588977 KB4588977 February 24, 2021
4580397 FIX: Incorrect results when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server Q4580397 KB4580397 February 24, 2021
4575939 FIX: Log reader agent generates access violation exception for P2P or transactional replication with partitioning tables in SQL Server Q4575939 KB4575939 February 24, 2021
4569837 FIX: Intermittent connection error occurs when an expression is used for both connection string and password of a connection manager Q4569837 KB4569837 February 24, 2021
4547890 FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server Q4547890 KB4547890 February 24, 2021
4589171 FIX: Unexpected error occurs when a query is run on an instance of SSAS Q4589171 KB4589171 February 15, 2021
4575689 FIX: Incorrect results can occur when you run linked server query with aggregates or joins on table with filtered index on a remote server in SQL Server Q4575689 KB4575689 February 15, 2021
4589345 FIX: Error 3625 occurs during query execution when batch mode on rowstore is enabled in SQL Server 2019 Q4589345 KB4589345 February 12, 2021
4588984 FIX: Contention on XVB_List spinlock in highly concurrent workloads when using RCSI Q4588984 KB4588984 February 12, 2021
5000672 FIX: Fixes reading of NULL Time fields for non-sqlserver backends Q5000672 KB5000672 February 11, 2021
5000671 FIX: Error occurs when casting non-Unicode string column using a Unicode-only UTF8 collation in SQL Server 2019 Q5000671 KB5000671 February 11, 2021
5000663 FIX: Database mail doesn't send email messages when IP address is specified in mssql-conf Q5000663 KB5000663 February 11, 2021
4594016 FIX: Assertion failure error occurs on sqlmin.dll!XdesRMBase::StartStmtSnapshot in SQL Server 2019 Q4594016 KB4594016 February 11, 2021
4588983 FIX: CREATE STATISTICS WITH SAMPLE PERCENT command fails with error when Oracle data source has partitioned table Q4588983 KB4588983 February 11, 2021
4588982 FIX: sys.dm_exec_requests returns transaction_id as "0" in certain scenarios in SQL Server 2019 Q4588982 KB4588982 February 11, 2021
4588981 FIX: "LogConsumer::StartScan failed to get the control lock" error occurs and the log writer activity stops completely in SQL Server 2019 Q4588981 KB4588981 February 11, 2021
4588980 FIX: Higher than expected number of single row Columnstore rowgroups may be generated for Columnstore bulk insert when both large page allocator and scalable Columnstore bulk insert features are turned on Q4588980 KB4588980 February 11, 2021
4588979 FIX: Fail to create AG on top of FCI in SQL Server 2019 Q4588979 KB4588979 February 11, 2021
4588978 FIX: Statistics are ignored when a query is run on PolyBase external table in SQL Server 2019 Q4588978 KB4588978 February 11, 2021
4577976 FIX: COMPILE blocking occurs when executing many concurrent stored procedures in SQL Server 2017 and 2019 Q4577976 KB4577976 February 11, 2021
4577933 FIX: Cascade delete on key values outside of leading table histogram bounds causes index scan in SQL Server 2017 and 2019 Q4577933 KB4577933 February 11, 2021
4577932 FIX: Access Violation exception occurs in Availability Groups in SQL Server 2017 under certain conditions Q4577932 KB4577932 February 11, 2021
4034376 FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature in SQL Server Q4034376 KB4034376 January 26, 2021
4580648 FIX: Errors may occur or PolyBase services fail to start when you run PolyBase queries on a non-English OS Q4580648 KB4580648 January 14, 2021
4580639 FIX: PolyBase queries can now be run with EXECUTE AS impersonation context in SQL Server 2019 Q4580639 KB4580639 January 14, 2021
4579223 FIX: PolyBase processes delayed to avoid data dump during provisioning in SQL Server 2019 Q4579223 KB4579223 January 14, 2021
4578292 FIX: Error occurs when you try to deploy CU5 or CU6 for SQL Server 2019 BDC irrespective of the azdata version Q4578292 KB4578292 January 14, 2021
4577837 FIX: Queries fail if storage pool caching is enabled by default in SQL Server 2019 Big Data Cluster Q4577837 KB4577837 January 14, 2021
4577594 FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019 Q4577594 KB4577594 January 14, 2021
4563007 FIX: VDI backup fails with error after applying SQL Server 2019 CU2/CU3/CU4 or SQL Server 2017 CU19/CU20/CU21 Q4563007 KB4563007 January 14, 2021
4538496 FIX: Unable to encrypt data when using column encryption with symmetric keys in SQL Server 2019 Q4538496 KB4538496 January 14, 2021
4538017 FIX: Severe contention on LOGCACHE_ACCESS spinlock in SQL Server 2019 Q4538017 KB4538017 January 14, 2021
4560494 FIX: MDX queries with calculated measure using the "/" operator run slow in SSAS Q4560494 KB4560494 October 24, 2020
4581882 FIX: Restoring database fails due to backup command time-out in SQL Server 2019 Q4581882 KB4581882 October 23, 2020
4580949 FIX: Snapshot agent fails when you create Transactional Publication with all tables and UDFs in SQL Server 2019 Q4580949 KB4580949 October 23, 2020
4580915 FIX: SQL Server error log receives several ADR enabled/disabled messages even when ADR isn't explicitly enabled/disabled Q4580915 KB4580915 October 23, 2020
4580413 FIX: Deadlock occurs between Availability Group Configuration and Replica Transport State Lock in SQL Server 2019 Q4580413 KB4580413 October 23, 2020
4578395 FIX: Error occurs when using DBCC operations while TDE key change occurs in SQL Server 2019 Q4578395 KB4578395 October 23, 2020
4578267 FIX: Different result set for the same query using dm_sql_referenced_entities in SQL Server 2019 Q4578267 KB4578267 October 23, 2020
4578110 FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2017 and 2019 Q4578110 KB4578110 October 23, 2020
4578011 FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size Q4578011 KB4578011 October 23, 2020
4577836 FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset Q4577836 KB4577836 October 23, 2020
4577591 FIX: Widerow insert to an external table is not supported when the row width is more than 32K in SQL Server 2019 Q4577591 KB4577591 October 23, 2020
4577590 FIX: Error occurs when row width is less than DMS buffer size of 32K and an incorrect return path is chosen in SQL Server 2019 Q4577590 KB4577590 October 23, 2020
4577562 FIX: Istio proxy fails as automountServiceAccountToken is set to FALSE in CU5 for SQL Server 2019 Q4577562 KB4577562 October 23, 2020
4577561 FIX: Error occurs when you try to filter the members of an entity for numeric values less than or greater than '0' in MDS 2019 Q4577561 KB4577561 October 23, 2020
4576778 FIX: Table Variable Deferred Compilation feature on SQL Server 2019 database remains enabled when database compatibility level is 140 or lower Q4576778 KB4576778 October 23, 2020
4575453 FIX: SQL Server does not start when remote admin connections are enabled and IPV6 is disabled on the host Q4575453 KB4575453 October 23, 2020
4575275 FIX: Access violation occurs when MSTVF references an In-Memory OLTP large-value data type with interleaved execution enabled in SQL Server 2019 Q4575275 KB4575275 October 23, 2020
4574801 FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019 Q4574801 KB4574801 October 23, 2020
4570679 FIX: Remote Hadoop bridge fails when using Hadoop connectivity levels other than seven in SQL Server 2019 on Linux Q4570679 KB4570679 October 23, 2020
4570571 FIX: Query slowness may occur when CPU-intensive SQL Server system tasks run in SQL Server 2019 Q4570571 KB4570571 October 23, 2020
4570433 FIX: "Culture is not supported" error or wrong results occur when you run PolyBase query in SQL Server 2019 Q4570433 KB4570433 October 23, 2020
4570355 FIX: Error occurs when you insert data from one replicated BDC data pool table to another in SQL Server 2019 Q4570355 KB4570355 October 23, 2020
4569425 FIX: Transactional replication publications can support URL type device to initialize subscriptions from backups in Azure Blob Storage in SQL Server 2017 and 2019 Q4569425 KB4569425 October 23, 2020
4569424 FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server Q4569424 KB4569424 October 23, 2020
4568653 FIX: INSERT EXEC doesn't work when you insert row containing explicit identity value into table with IDENTITY column and IDENTITY_INSERT is OFF by default in SQL Server Q4568653 KB4568653 October 23, 2020
4564876 FIX: Unable to reconfigure Database mirroring when ADR is enabled and disabled in SQL Server 2019 Q4564876 KB4564876 October 23, 2020
4564868 FIX: Assertion exception occurs when you query the DMV sys.dm_db_file_space_usage in SQL Server 2017 and 2019 Q4564868 KB4564868 October 23, 2020
4563597 FIX: Assertion dump may occur when Implicit Transactions are enabled in SQL Server 2019, 2017, and 2016 Q4563597 KB4563597 October 23, 2020
4563195 FIX: sp_execute_external_script may fail to run R scripts that use the RxLocalParallel compute context or the doParallel R package in SQL Server 2019 Q4563195 KB4563195 October 23, 2020
4563044 FIX: Allow external resource pool to use more than one processor group in SQL Server 2019 on Windows Q4563044 KB4563044 October 23, 2020
4562618 FIX: Changes to firewall rules created when you install PolyBase in scale-out group configuration in SQL Server 2019 Q4562618 KB4562618 October 23, 2020
4562173 FIX: Availability Group failover generates lot of dumps as DTC support is toggled between PER_DB and NONE multiple times Q4562173 KB4562173 October 23, 2020
4560183 FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server Q4560183 KB4560183 October 23, 2020
4560051 FIX: SQL Server may still read data from secondary replica when ALLOW_CONNECTIONS is set to NO Q4560051 KB4560051 October 23, 2020
4556244 FIX: Credential update frequency option is added to mssql-conf option in SQL Server 2019 on Linux Q4556244 KB4556244 October 23, 2020
4556233 FIX: Setup is unable to extract product update when it is executed as LOCAL SYSTEM with UPDATE SOURCE option specified in SQL Server 2019 Q4556233 KB4556233 October 23, 2020
4555232 FIX: Blocking may occur when Reduce Recompilations feature is enabled by default in SQL Server 2019 Q4555232 KB4555232 October 23, 2020
4552205 FIX: Error occurs when you try to create external table in PolyBase with database_default as collation in SQL Server 2019 Q4552205 KB4552205 October 23, 2020
4552159 FIX: Error occurs when you apply a security policy on PolyBase external table in SQL Server 2019 Q4552159 KB4552159 October 23, 2020
4551838 FIX: Memory leak by Controller container in SQL Server 2019 BDC Q4551838 KB4551838 October 23, 2020
4551221 FIX: Error occurs when you try to create a differential backup on secondary replica in SQL Server Q4551221 KB4551221 October 23, 2020
4551220 FIX: Assertion error occurs when you run resumable index build statement in SQL Server Q4551220 KB4551220 October 23, 2020
4550657 FIX: Error occurs when you interact with SQL Server Agent in SQL Server 2019 Q4550657 KB4550657 October 23, 2020
4548133 FIX: Data length/size of Unicode nvarchar data type column is not correct for OutputDataSet in sp_execute_external_script query in SQL Server 2019 on Linux Q4548133 KB4548133 October 23, 2020
4548131 FIX: Fail to access openmpi path when running rx jobs in parallel mode with Revo package in Linux SQL Server 2019 Q4548131 KB4548131 October 23, 2020
4548103 FIX: Performance degradation occurs on PMEM devices with Hybrid Buffer Pool enabled in SQL Server 2019 Q4548103 KB4548103 October 23, 2020
4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 October 23, 2020
4541770 FIX: Assertion failure occurs when persistent log buffer is used in SQL Server Q4541770 KB4541770 October 23, 2020
4541762 FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server Q4541762 KB4541762 October 23, 2020
4541724 FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server Q4541724 KB4541724 October 23, 2020
4541520 FIX: Assertion occurs when you process a malformed XML message sent as message in Service Broker queue in SQL Server Q4541520 KB4541520 October 23, 2020
4541435 FIX: Error occurs when you rename a column on temporal current table in SQL Server Q4541435 KB4541435 October 23, 2020
4541309 FIX: Missing log block may occur when you use Always On availability group in SQL Server Q4541309 KB4541309 October 23, 2020
4541300 FIX: Fix incorrect values in auto seeding XEvents in SQL Server Q4541300 KB4541300 October 23, 2020
4541096 FIX: Access Violation occurs when you run query on computed columns in SQL Server Q4541096 KB4541096 October 23, 2020
4540901 FIX: SQL Server may terminate due to lock conflicts during error message processing in SQL Server 2016, 2017 and 2019 Q4540901 KB4540901 October 23, 2020
4540896 FIX: Access violation may occur when enumerating files in a FileTable in SQL Server Q4540896 KB4540896 October 23, 2020
4540449 FIX: Error occurs in sp_xml_preparedocument where MSXMLSQL tries to access virtual address space beyond limit in SQL Server 2016, 2017 and 2019 Q4540449 KB4540449 October 23, 2020
4540372 FIX: XML PATH queries in PolyBase fail with an error in SQL Server 2019 Q4540372 KB4540372 October 23, 2020
4540371 FIX: Query on Clustered Columnstore Index in SQL Server 2019 uses more CPU time than in SQL Server 2016 Q4540371 KB4540371 October 23, 2020
4540346 FIX: MERGE statement fails with assert “Attempt to access expired blob handle (1)” in SQL Server 2016, 2017 and 2019 Q4540346 KB4540346 October 23, 2020
4540342 FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server Q4540342 KB4540342 October 23, 2020
4540121 FIX: sp_execute_external_script doesn't run when you install SQL Server 2019 with Machine Learning Services and a customized Shared feature directory Q4540121 KB4540121 October 23, 2020
4540107 FIX: System or background task may fail when number of sessions reaches the maximum limit in SQL Server 2016, 2017 and 2019 Q4540107 KB4540107 October 23, 2020
4539880 FIX: Access violation occurs with wait_info XEvent on busy SQL Server Q4539880 KB4539880 October 23, 2020
4539815 FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server Q4539815 KB4539815 October 23, 2020
4539203 FIX: Error occurs when you use PolyBase Generic ODBC connector with backend that has unsupported quote character in SQL Server 2019 Q4539203 KB4539203 October 23, 2020
4539201 FIX: XML queries in PolyBase fail with an unknown type error in SQL Server 2019 Q4539201 KB4539201 October 23, 2020
4539200 FIX: Internal DMS error when you use PolyBase Generic ODBC connector in SQL Server 2019 Q4539200 KB4539200 October 23, 2020
4539199 FIX: PolyBase defaults string mapping for Microsoft Spark ODBC driver in SQL Server 2019 Q4539199 KB4539199 October 23, 2020
4539198 FIX: Map large fixed width types to variable width types in PolyBase in SQL Server 2019 Q4539198 KB4539198 October 23, 2020
4539197 FIX: Null pointer exception error occurs when "latch_suspend_end" XEvent is enabled in SQL Server 2019 Q4539197 KB4539197 October 23, 2020
4539172 FIX: Launchpad services fails to start during failover in SQL Server 2019 Q4539172 KB4539172 October 23, 2020
4539023 FIX: Analysis Services Execute DDL task fails to impersonate the user context to the remote Analysis services instance in SQL Server 2017 and 2019 Q4539023 KB4539023 October 23, 2020
4539000 FIX: SSMS showplan error occurs for BDC query in SQL Server 2019 Q4539000 KB4539000 October 23, 2020
4538968 FIX: PolyBase query execution time may increase exponentially when you run concurrent queries in SQL Server 2019 Q4538968 KB4538968 October 23, 2020
4538858 FIX: Dumps occur because of OOM condition in SQL Server 2019 Q4538858 KB4538858 October 23, 2020
4538849 FIX: Transaction commit delay time is higher under low usage workloads in SQL Server 2017 and 2019 Q4538849 KB4538849 October 23, 2020
4538575 FIX: Login and logout failures occur while auditing data classification attributes in SQL Server 2019 Q4538575 KB4538575 October 23, 2020
4538573 FIX: Changes made using ALTER DATABASE...SQL Server 2019 fails to log changes in SQL Error log or raise database trigger Q4538573 KB4538573 October 23, 2020
4538497 FIX: Slow query performance when using query predicates with UPPER, LOWER or RTRIM with default CE in SQL Server 2017 and 2019 Q4538497 KB4538497 October 23, 2020
4538495 FIX: Access violation occurs when you create remote stored procedure with one of the system variable (@@servername, @@servicename) in SQL Server 2019 Q4538495 KB4538495 October 23, 2020
4538481 FIX: Exception occurs when you run UNION ALL+ORDER BY/MERGE UNION ALL queries on table that contains randomized encrypted data in SQL Server 2019 Q4538481 KB4538481 October 23, 2020
4538378 FIX: The "is_media_read_only" value remains unchanged for a SQL Server data file even though the media is no longer read-only Q4538378 KB4538378 October 23, 2020
4538377 FIX: Non-yielding scheduler condition occurs when you run batch mode query with multiple joins in SQL Server 2017 and 2019 Q4538377 KB4538377 October 23, 2020
4538365 FIX: Change Tracking cleanup does not work when invalid cleanup and hardened cleanup version are negative in SQL Server 2017 and 2019 Q4538365 KB4538365 October 23, 2020
4538344 FIX: Passwords are masked in audit logs in SQL Server 2019 Q4538344 KB4538344 October 23, 2020
4538342 FIX: Latest drivers fail to work with in-memory compiled queries in SQL Server 2019 Q4538342 KB4538342 October 23, 2020
4538268 FIX: "Expired BLOB handle" error occurs when cross-database transaction involves communication with MSDTC in SQL Server 2017 and 2019 Q4538268 KB4538268 October 23, 2020
4538174 FIX: Error occurs and AG will be in non-synchronizing state when failover happens in primary AG of Distributed Availability Group in SQL Server 2017 and 2019 on Linux Q4538174 KB4538174 October 23, 2020
4538164 FIX: Error occurs when you run the same PolyBase query multiple times in SQL Server 2019 Q4538164 KB4538164 October 23, 2020
4538163 FIX: PolyBase may fail to generate dumps if an error occurs during the distributed query optimization phase in SQL Server 2019 Q4538163 KB4538163 October 23, 2020
4538162 FIX: Unable to start PolyBase services when TCP/IP is not enabled in SQL Server 2019 Developer Edition Q4538162 KB4538162 October 23, 2020
4538161 FIX: Error occurs when you run queries in PolyBase scale-out groups in SQL Server 2019 Q4538161 KB4538161 October 23, 2020
4538159 FIX: Calculation with summarizecolumn returns unexpected results after upgrading to SSAS 2019 with compatibility level 1500 Q4538159 KB4538159 October 23, 2020
4538036 FIX: Error occurs when you query storage pool external table that contains column with money data type in SQL Server 2019 BDC Q4538036 KB4538036 October 23, 2020
4537869 FIX: Log shipping agent is not able to log history and error information to SQL Server 2019 Q4537869 KB4537869 October 23, 2020
4537751 FIX: Error due to explicit transaction isolation level hint when accessing Memory-Optimized Tempdb catalog views in SQL Server 2019 Q4537751 KB4537751 October 23, 2020
4537710 FIX: SOS_BLOCKALLOCPARTIALLIST spin lock contention may occur when TF 834 is enabled in SQL Server 2019 Q4537710 KB4537710 October 23, 2020
4537452 FIX: Logreader doesn't execute when you upgrade from SQL Server 2017 to 2019 Q4537452 KB4537452 October 23, 2020
4537401 FIX: Custom date format with time doesn't work properly in SQL Server 2019 Master Data Services Q4537401 KB4537401 October 23, 2020
4537350 FIX: Access Violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server Q4537350 KB4537350 October 23, 2020
4537347 FIX: Error 544 occurs when you use SET IDENTITY_INSERT on temp table in SQL Server 2019 Q4537347 KB4537347 October 23, 2020
4537072 FIX: Creating an external table against an Oracle database in SQL Server 2019 may fail if using Oracle database 12.2 or later versions Q4537072 KB4537072 October 23, 2020
4536841 FIX: Error occurs while creating External Data Source for Data Pool that has nondefault name for LOCATION in SQL Server 2019 Q4536841 KB4536841 October 23, 2020
4536684 FIX: Error occurs when QDS is turned on or you generate query plan for Polybase queries in SQL Server 2019 Q4536684 KB4536684 October 23, 2020
4536077 FIX: Dump is generated when you create an AG with more than 122 characters in SQL Server 2019 Q4536077 KB4536077 October 23, 2020
4534981 FIX: Additional cluster resources are removed by the "azdata bdc delete" command Q4534981 KB4534981 October 23, 2020
4534249 FIX: Unable to execute sys.dm_exec_requests when you install SQL Server 2019 or when you upgrade from prior versions of SQL Server Q4534249 KB4534249 October 23, 2020
4534148 FIX: PolyBase query may hang if you cancel the query after it is started in SQL Server 2019 Q4534148 KB4534148 October 23, 2020
4533497 FIX: External satellite process scripts like R, Python are unable to access any directories outside of their working directory in SQL Server 2019 Q4533497 KB4533497 October 23, 2020
4533251 FIX: Upgrading FCI passive node from SQL Server 2019 RC1 to RTM fails when you try to access the MSSQL\JOBS which is on the shared drive Q4533251 KB4533251 October 23, 2020
4531384 FIX: Queries may fail in SQL Server 2019 when PolyBase is under stress and heavy cancellations Q4531384 KB4531384 October 23, 2020
4531349 FIX: DMVs fail when Big Data Cluster has multiple compute nodes in SQL Server 2019 Q4531349 KB4531349 October 23, 2020
4531238 FIX: Heap corruption occurs when ADR is disabled and aborted transactions are present in SQL Server 2019 database Q4531238 KB4531238 October 23, 2020
4531232 FIX: PolyBase Engine Service may dump if an error occurs during retrieval of Data Pool metadata in SQL Server 2019 Q4531232 KB4531232 October 23, 2020
4531226 FIX: Error occurs when you select from storage pool table and insert into another external table in SQL Server 2019 Q4531226 KB4531226 October 23, 2020
4531225 FIX: PolyBase query may hang when DMS restarts in SQL Server 2019 Q4531225 KB4531225 October 23, 2020
4531224 FIX: Spurious lines may be added to the SQL Server error log at each initialization in SQL Server 2019 Q4531224 KB4531224 October 23, 2020
4531049 FIX: Access violation occurs when you set database containment to NONE in SQL Server 2019 Q4531049 KB4531049 October 23, 2020
4531029 FIX: Query may fail when you join a storage pool table with a data pool table in SQL Server 2019 Q4531029 KB4531029 October 23, 2020
4531026 FIX: NullPointerException occurs when the name node is not active and the HTTP request has other failures in SQL Server 2019 Q4531026 KB4531026 October 23, 2020
4531010 FIX: CREATE INDEX with new CE reads the partition table and results in huge row count higher than the total table row count in SQL Server Q4531010 KB4531010 October 23, 2020
4530827 FIX: Two issues with remote Hadoop bridge process in SQL Server 2019 Q4530827 KB4530827 October 23, 2020
4530769 FIX: FSM may be called when you create a database in SQL Server 2019 Big Data Clusters Q4530769 KB4530769 October 23, 2020
4530720 FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server Q4530720 KB4530720 October 23, 2020
4530500 FIX: Assertion dump occurs when sp_cdc_disable_db is executed to disable CDC or when distributed transaction is committed after ROLLBACK SAVEPOINT in SQL Server Q4530500 KB4530500 October 23, 2020
4530499 FIX: Non-yielding scheduler error when Polybase function call to shared memory takes long time in SQL Server 2019 Q4530499 KB4530499 October 23, 2020
4530496 FIX: Data pool database may be deleted if you fail to drop database on master in SQL Server 2019 Q4530496 KB4530496 October 23, 2020
4530475 FIX: IsError function fails to detect error in Excel XIRR function when MDX query is executed from SSIS Q4530475 KB4530475 October 23, 2020
4530468 FIX: PolyBase Hadoop queries may fail when the launchpadd service is restarted or killed in SQL Server 2019 Q4530468 KB4530468 October 23, 2020
4530443 FIX: Non-yielding scheduler issue occurs in SQL Server when you run an online build for an index that's not partition-aligned Q4530443 KB4530443 October 23, 2020
4530427 FIX: sp_describe_parameter_encryption returns different results with different parameter positions in SQL Server 2019 Q4530427 KB4530427 October 23, 2020
4530303 FIX: Data masking of user-defined functions may result in crashes in SQL Server 2019 Q4530303 KB4530303 October 23, 2020
4530281 FIX: Typo in error message for Columnstore indexes on temporary tables in SQL Server 2019 Q4530281 KB4530281 October 23, 2020
4530259 FIX: Scripts generated by SSMS collect different wait types after you install SQL Server Q4530259 KB4530259 October 23, 2020
4530251 FIX: Error 8601 occurs when you run a query with partition function in SQL Server Q4530251 KB4530251 October 23, 2020
4530212 FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server Q4530212 KB4530212 October 23, 2020
4530097 FIX: Package execution may be impacted in SQL Server 2019 Integration Services Q4530097 KB4530097 October 23, 2020
4530084 FIX: Error occurs when you try to install SQL Server 2019 on a low power CPU Q4530084 KB4530084 October 23, 2020
4530055 FIX: Access violation occurs when worker stealing is enabled and CPU capacity reaches maximal configured value in SQL Server 2019 Q4530055 KB4530055 October 23, 2020
4530054 FIX: Worker stealing stops working when AG contains one or more encrypted databases in SQL Server 2019 Q4530054 KB4530054 October 23, 2020
4529944 FIX: Unsigned files are installed through the Microsoft MPI in SQL Server 2019 Q4529944 KB4529944 October 23, 2020
4529942 FIX: Restore fails when you try to restore compressed TDE backups prior to SQL Server 2016 SP2 CU4 on SQL Server 2016 SP2 CU8 Q4529942 KB4529942 October 23, 2020
4529927 FIX: .NET Framework DbDataAdapter.FillSchema method returns NULL on database with compatibility level 140 in SQL Server 2019 and 2017 Q4529927 KB4529927 October 23, 2020
4529893 FIX: Audit of batch may be skipped when the batch causes a failure that closes the session in SQL Server 2019 Q4529893 KB4529893 October 23, 2020
4529848 FIX: PolyBase DMVs may return unexpected results after changing PolyBase enabled setting in SQL Server 2019 Q4529848 KB4529848 October 23, 2020
4529833 FIX: sp_describe_parameter_encryption returns different results if you switch parameter positions in SQL Server 2017 and 2019 Q4529833 KB4529833 October 23, 2020
4528492 FIX: DTC transaction scenario reports unsupported transaction error when HkTempdb transaction is used in SQL Server 2019 Q4528492 KB4528492 October 23, 2020
4528491 FIX: Access violation occurs when you call HkError.Throw() in SQL Server 2019 Q4528491 KB4528491 October 23, 2020
4528490 FIX: Access violation occurs when attempting to fetch the IAM page of the table in SQL Server 2019 Q4528490 KB4528490 October 23, 2020
4528337 FIX: Assertion error when you run internal query in batch mode for populating full-text index on computed LOB in SQL Server 2019 Q4528337 KB4528337 October 23, 2020
4528250 FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server Q4528250 KB4528250 October 23, 2020
4528168 FIX: Using temporary tables across multiple scopes may cause Error 213 or access violation in SQL Server 2019 Q4528168 KB4528168 October 23, 2020
4528139 FIX: "Debug Assertion Failed" error if you create objects that are not hashed by name in SQL Server 2019 Q4528139 KB4528139 October 23, 2020
4528097 FIX: Access violation occurs when you query sys.dm_db_persisted_sku_features DMV in SQL Server 2019 Q4528097 KB4528097 October 23, 2020
4528067 FIX: Error 8959 may occur on IAM page when you query sys.dm_db_index_physical_stats against partitioned columnstore table after partition switch in SQL Server Q4528067 KB4528067 October 23, 2020
4528066 FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 and 2019 because of NCCI Q4528066 KB4528066 October 23, 2020
4527916 FIX: You may receive incorrect object_id after you switch a partition in SQL Server 2017 and 2019 Q4527916 KB4527916 October 23, 2020
4527716 FIX: You may encounter a non-yielding scheduler condition when you run query with parallel batch-mode sort operator in SQL Server Q4527716 KB4527716 October 23, 2020
4527538 FIX: "A system assertion check has failed" error when a procedure call is made from CLR with an OUTPUT large object argument Q4527538 KB4527538 October 23, 2020
4527510 FIX: User hierarchy is not hidden when you run DISCOVER_CSDL_METADATA in SQL Server Q4527510 KB4527510 October 23, 2020
4527355 FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server Q4527355 KB4527355 October 23, 2020
4527229 FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server Q4527229 KB4527229 October 23, 2020
4527165 FIX: SQL Server Browser doesn't respond through clustered IP address from a SQL Server 2019 Failover Clustered Instance (FCI) Q4527165 KB4527165 October 23, 2020
4526315 FIX: Database cannot recover and reports error 5243 in SQL Server Q4526315 KB4526315 October 23, 2020
4525483 FIX: Exception error 3628 may occur when you run stored procedure in SQL Server Q4525483 KB4525483 October 23, 2020
4524542 FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU Q4524542 KB4524542 October 23, 2020
4524191 FIX: Menu and scroll bar are missing in "Changes" section when large number of changesets are added in Excel add-in for MDS in SQL Server 2017 and 2019 Q4524191 KB4524191 October 23, 2020
4523102 FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS Q4523102 KB4523102 October 23, 2020
4522002 FIX: SQL Server 2017 and 2019 on Linux fails with an Assertion error Q4522002 KB4522002 October 23, 2020
4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 Q4521960 KB4521960 October 23, 2020
4521702 FIX: ObjectPropertyEx Cardinality property for columnstore table doesn't include rows in delta store rowset or account rows in deleted bitmap rowset in SQL Server 2019 Q4521702 KB4521702 October 23, 2020
4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019 Q4521659 KB4521659 October 23, 2020
4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 Q4519796 KB4519796 October 23, 2020
4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019 Q4519668 KB4519668 October 23, 2020
4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server Q4519366 KB4519366 October 23, 2020
4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019 Q4518364 KB4518364 October 23, 2020
4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server Q4517771 KB4517771 October 23, 2020
4516999 FIX: File content is sent twice when copied to HDFS using Hadoop File System Task in SQL Server 2017 and 2019 Q4516999 KB4516999 October 23, 2020
4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 October 23, 2020
4540343 FIX: Contained AG master database dependency creates deadlock during replica restart at certain condition in SQL Server 2019 Q4540343 KB4540343 February 14, 2020
4538685 FIX: SQL Server 2019 Express SLT incorrectly states that Express is not allowed for production use Q4538685 KB4538685 February 14, 2020
4538661 FIX: New sandbox is created unexpectedly when sandbox cleanup fails and child process is still alive Q4538661 KB4538661 February 14, 2020
4538515 FIX: Concurrent PFS update in SQL Server 2019 may cause corruption of ADR Q4538515 KB4538515 February 14, 2020
4537300 FIX: Change the NuGet that's used for Polaris in SQL Server 2019 Q4537300 KB4537300 February 14, 2020
4531702 FIX: Assertion occurs when TF 831 is turned ON/OFF multiple times in SQL Server 2019 Q4531702 KB4531702 February 14, 2020

SQL Server 2019 articles, fixes and updates - letter F