SQL Server 2019 articles, fixes and updates - letter F

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.

• 4538017 FIX: Severe contention on LOGCACHE_ACCESS spinlock in SQL Server 2019 Q4538017 KB4538017 November 16, 2020
• 4582558 FIX: SQL Server service fails to start in Linux operating system Q4582558 KB4582558 November 4, 2020
• 4580397 FIX: Incorrect results occur when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server Q4580397 KB4580397 November 4, 2020
• 4563007 FIX: VDI backup fails with error after applying SQL Server 2019 CU2/CU3/CU4 or SQL Server 2017 CU19/CU20/CU21 Q4563007 KB4563007 November 3, 2020
• 4581886 FIX: Joins not getting pushed down for PolyBase query that joins multiple external tables Q4581886 KB4581886 October 20, 2020
• 4581882 FIX: Restoring database fails due to backup command time-out in SQL Server 2019 Q4581882 KB4581882 October 20, 2020
• 4580949 FIX: Snapshot agent fails when you create Transactional Publication with all tables and UDFs in SQL Server 2019 Q4580949 KB4580949 October 20, 2020
• 4580915 FIX: SQL Server error log receives several ADR enabled/disabled messages even when ADR isn't explicitly enabled/disabled Q4580915 KB4580915 October 20, 2020
• 4580413 FIX: Deadlock occurs between Availability Group Configuration and Replica Transport State Lock in SQL Server 2019 Q4580413 KB4580413 October 20, 2020
• 4578395 FIX: Error occurs when using DBCC operations while TDE key change occurs in SQL Server 2019 Q4578395 KB4578395 October 20, 2020
• 4578267 FIX: Different result set for the same query using dm_sql_referenced_entities in SQL Server 2019 Q4578267 KB4578267 October 20, 2020
• 4578110 FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2017 and 2019 Q4578110 KB4578110 October 20, 2020
• 4578011 FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size Q4578011 KB4578011 October 20, 2020
• 4577836 FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset Q4577836 KB4577836 October 20, 2020
• 4577594 FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019 Q4577594 KB4577594 October 20, 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 20, 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 20, 2020
• 4577562 FIX: Istio proxy fails as automountServiceAccountToken is set to FALSE in CU5 for SQL Server 2019 Q4577562 KB4577562 October 20, 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 20, 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 20, 2020
• 4575453 FIX: SQL Server does not start when remote admin connections are enabled and IPV6 is disabled on the host Q4575453 KB4575453 October 20, 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 20, 2020
• 4574801 FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019 Q4574801 KB4574801 October 20, 2020
• 4570679 FIX: Remote Hadoop bridge fails when using Hadoop connectivity levels other than seven in SQL Server 2019 on Linux Q4570679 KB4570679 October 20, 2020
• 4570571 FIX: Query slowness may occur when CPU-intensive SQL Server system tasks run in SQL Server 2019 Q4570571 KB4570571 October 20, 2020
• 4570433 FIX: "Culture is not supported" error or wrong results occur when you run PolyBase query in SQL Server 2019 Q4570433 KB4570433 October 20, 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 20, 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 20, 2020
• 4569424 FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server Q4569424 KB4569424 October 20, 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 20, 2020
• 4568448 FIX: Support for REJECT_ROW_LOCATION parameter in CREATE EXTERNAL TABLE in SQL Server 2019 box product Q4568448 KB4568448 October 20, 2020
• 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 October 20, 2020
• 4564876 FIX: Unable to reconfigure Database mirroring when ADR is enabled and disabled in SQL Server 2019 Q4564876 KB4564876 October 20, 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 20, 2020
• 4563597 FIX: Assertion dump may occur when Implicit Transactions are enabled in SQL Server 2019, 2017, and 2016 Q4563597 KB4563597 October 20, 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 20, 2020
• 4563115 FIX: Upgrade script fails if you use Always On Failover Cluster Instance as a secondary replica in SQL Server Q4563115 KB4563115 October 20, 2020
• 4563044 FIX: Allow external resource pool to use more than one processor group in SQL Server 2019 on Windows Q4563044 KB4563044 October 20, 2020
• 4562618 FIX: Changes to firewall rules created when you install PolyBase in scale-out group configuration in SQL Server 2019 Q4562618 KB4562618 October 20, 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 20, 2020
• 4561305 FIX: Concurrent inserts against tables with columnstore indexes may cause queries to hang in SQL Server Q4561305 KB4561305 October 20, 2020
• 4560183 FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server Q4560183 KB4560183 October 20, 2020
• 4560051 FIX: SQL Server may still read data from secondary replica when ALLOW_CONNECTIONS is set to NO Q4560051 KB4560051 October 20, 2020
• 4556244 FIX: Credential update frequency option is added to mssql-conf option in SQL Server 2019 on Linux Q4556244 KB4556244 October 20, 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 20, 2020
• 4555232 FIX: Blocking may occur when Reduce Recompilations feature is enabled by default in SQL Server 2019 Q4555232 KB4555232 October 20, 2020
• 4552478 FIX: Distribution Agent "Parameterized values for above command" log message missing after SQL Server 2017 and 2019 upgrade Q4552478 KB4552478 October 20, 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 20, 2020
• 4552159 FIX: Error occurs when you apply a security policy on PolyBase external table in SQL Server 2019 Q4552159 KB4552159 October 20, 2020
• 4551838 FIX: Memory leak by Controller container in SQL Server 2019 BDC Q4551838 KB4551838 October 20, 2020
• 4551221 FIX: Error occurs when you try to create a differential backup on secondary replica in SQL Server Q4551221 KB4551221 October 20, 2020
• 4551220 FIX: Assertion error occurs when you run resumable index build statement in SQL Server Q4551220 KB4551220 October 20, 2020
• 4550657 FIX: Error occurs when you interact with SQL Server Agent in SQL Server 2019 Q4550657 KB4550657 October 20, 2020
• 4548523 FIX: Database creation to Azure blob storage from SQL Server 2017 or 2019 on Linux may fail with error Q4548523 KB4548523 October 20, 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 20, 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 20, 2020
• 4548103 FIX: Performance degradation occurs on PMEM devices with Hybrid Buffer Pool enabled in SQL Server 2019 Q4548103 KB4548103 October 20, 2020
• 4547890 FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server Q4547890 KB4547890 October 20, 2020
• 4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 October 20, 2020
• 4541770 FIX: Assertion failure occurs when persistent log buffer is used in SQL Server Q4541770 KB4541770 October 20, 2020
• 4541762 FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server Q4541762 KB4541762 October 20, 2020
• 4541724 FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server Q4541724 KB4541724 October 20, 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 20, 2020
• 4541435 FIX: Error occurs when you rename a column on temporal current table in SQL Server Q4541435 KB4541435 October 20, 2020
• 4541309 FIX: Missing log block may occur when you use Always On availability group in SQL Server Q4541309 KB4541309 October 20, 2020
• 4541303 FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server Q4541303 KB4541303 October 20, 2020
• 4541300 FIX: Fix incorrect values in auto seeding XEvents in SQL Server Q4541300 KB4541300 October 20, 2020
• 4541096 FIX: Access Violation occurs when you run query on computed columns in SQL Server Q4541096 KB4541096 October 20, 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 20, 2020
• 4540896 FIX: Access violation may occur when enumerating files in a FileTable in SQL Server Q4540896 KB4540896 October 20, 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 20, 2020
• 4540372 FIX: XML PATH queries in PolyBase fail with an error in SQL Server 2019 Q4540372 KB4540372 October 20, 2020
• 4540371 FIX: Query on Clustered Columnstore Index in SQL Server 2019 uses more CPU time than in SQL Server 2016 Q4540371 KB4540371 October 20, 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 20, 2020
• 4540342 FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server Q4540342 KB4540342 October 20, 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 20, 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 20, 2020
• 4539880 FIX: Access violation occurs with wait_info XEvent on busy SQL Server Q4539880 KB4539880 October 20, 2020
• 4539815 FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server Q4539815 KB4539815 October 20, 2020
• 4539340 FIX: Include support for Excel ODBC driver and Text ODBC driver from Microsoft Access Database Engine Redistributable package in PolyBase for SQL Server 2019 Q4539340 KB4539340 October 20, 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 20, 2020
• 4539201 FIX: XML queries in PolyBase fail with an unknown type error in SQL Server 2019 Q4539201 KB4539201 October 20, 2020
• 4539200 FIX: Internal DMS error when you use PolyBase Generic ODBC connector in SQL Server 2019 Q4539200 KB4539200 October 20, 2020
• 4539199 FIX: PolyBase defaults string mapping for Microsoft Spark ODBC driver in SQL Server 2019 Q4539199 KB4539199 October 20, 2020
• 4539198 FIX: Map large fixed width types to variable width types in PolyBase in SQL Server 2019 Q4539198 KB4539198 October 20, 2020
• 4539197 FIX: Null pointer exception error occurs when "latch_suspend_end" XEvent is enabled in SQL Server 2019 Q4539197 KB4539197 October 20, 2020
• 4539172 FIX: Launchpad services fails to start during failover in SQL Server 2019 Q4539172 KB4539172 October 20, 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 20, 2020
• 4539000 FIX: SSMS showplan error occurs for BDC query in SQL Server 2019 Q4539000 KB4539000 October 20, 2020
• 4538968 FIX: PolyBase query execution time may increase exponentially when you run concurrent queries in SQL Server 2019 Q4538968 KB4538968 October 20, 2020
• 4538858 FIX: Dumps occur because of OOM condition in SQL Server 2019 Q4538858 KB4538858 October 20, 2020
• 4538849 FIX: Transaction commit delay time is higher under low usage workloads in SQL Server 2017 and 2019 Q4538849 KB4538849 October 20, 2020
• 4538688 FIX: Severe spinlock contention occurs in SQL Server 2019 Q4538688 KB4538688 October 20, 2020
• 4538575 FIX: Login and logout failures occur while auditing data classification attributes in SQL Server 2019 Q4538575 KB4538575 October 20, 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 20, 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 20, 2020
• 4538496 FIX: Unable to encrypt data when using column encryption with symmetric keys in SQL Server 2019 Q4538496 KB4538496 October 20, 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 20, 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 20, 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 20, 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 20, 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 20, 2020
• 4538344 FIX: Passwords are masked in audit logs in SQL Server 2019 Q4538344 KB4538344 October 20, 2020
• 4538342 FIX: Latest drivers fail to work with in-memory compiled queries in SQL Server 2019 Q4538342 KB4538342 October 20, 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 20, 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 20, 2020
• 4538164 FIX: Error occurs when you run the same PolyBase query multiple times in SQL Server 2019 Q4538164 KB4538164 October 20, 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 20, 2020
• 4538162 FIX: Unable to start PolyBase services when TCP/IP is not enabled in SQL Server 2019 Developer Edition Q4538162 KB4538162 October 20, 2020
• 4538161 FIX: Error occurs when you run queries in PolyBase scale-out groups in SQL Server 2019 Q4538161 KB4538161 October 20, 2020
• 4538159 FIX: Calculation with summarizecolumn returns unexpected results after upgrading to SSAS 2019 with compatibility level 1500 Q4538159 KB4538159 October 20, 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 20, 2020
• 4537869 FIX: Log shipping agent is not able to log history and error information to SQL Server 2019 Q4537869 KB4537869 October 20, 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 20, 2020
• 4537710 FIX: SOS_BLOCKALLOCPARTIALLIST spin lock contention may occur when TF 834 is enabled in SQL Server 2019 Q4537710 KB4537710 October 20, 2020
• 4537452 FIX: Logreader doesn't execute when you upgrade from SQL Server 2017 to 2019 Q4537452 KB4537452 October 20, 2020
• 4537401 FIX: Custom date format with time doesn't work properly in SQL Server 2019 Master Data Services Q4537401 KB4537401 October 20, 2020
• 4537350 FIX: Access Violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server Q4537350 KB4537350 October 20, 2020
• 4537347 FIX: Error 544 occurs when you use SET IDENTITY_INSERT on temp table in SQL Server 2019 Q4537347 KB4537347 October 20, 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 20, 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 20, 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 20, 2020
• 4536077 FIX: Dump is generated when you create an AG with more than 122 characters in SQL Server 2019 Q4536077 KB4536077 October 20, 2020
• 4534981 FIX: Additional cluster resources are removed by the "azdata bdc delete" command Q4534981 KB4534981 October 20, 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 20, 2020
• 4534148 FIX: PolyBase query may hang if you cancel the query after it is started in SQL Server 2019 Q4534148 KB4534148 October 20, 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 20, 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 20, 2020
• 4531384 FIX: Queries may fail in SQL Server 2019 when PolyBase is under stress and heavy cancellations Q4531384 KB4531384 October 20, 2020
• 4531349 FIX: DMVs fail when Big Data Cluster has multiple compute nodes in SQL Server 2019 Q4531349 KB4531349 October 20, 2020
• 4531238 FIX: Heap corruption occurs when ADR is disabled and aborted transactions are present in SQL Server 2019 database Q4531238 KB4531238 October 20, 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 20, 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 20, 2020
• 4531225 FIX: PolyBase query may hang when DMS restarts in SQL Server 2019 Q4531225 KB4531225 October 20, 2020
• 4531224 FIX: Spurious lines may be added to the SQL Server error log at each initialization in SQL Server 2019 Q4531224 KB4531224 October 20, 2020
• 4531049 FIX: Access violation occurs when you set database containment to NONE in SQL Server 2019 Q4531049 KB4531049 October 20, 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 20, 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 20, 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 20, 2020
• 4530827 FIX: Two issues with remote Hadoop bridge process in SQL Server 2019 Q4530827 KB4530827 October 20, 2020
• 4530769 FIX: FSM may be called when you create a database in SQL Server 2019 Big Data Clusters Q4530769 KB4530769 October 20, 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 20, 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 20, 2020
• 4530499 FIX: Non-yielding scheduler error when Polybase function call to shared memory takes long time in SQL Server 2019 Q4530499 KB4530499 October 20, 2020
• 4530496 FIX: Data pool database may be deleted if you fail to drop database on master in SQL Server 2019 Q4530496 KB4530496 October 20, 2020
• 4530475 FIX: IsError function fails to detect error in Excel XIRR function when MDX query is executed from SSIS Q4530475 KB4530475 October 20, 2020
• 4530468 FIX: PolyBase Hadoop queries may fail when the launchpadd service is restarted or killed in SQL Server 2019 Q4530468 KB4530468 October 20, 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 20, 2020
• 4530427 FIX: sp_describe_parameter_encryption returns different results with different parameter positions in SQL Server 2019 Q4530427 KB4530427 October 20, 2020
• 4530303 FIX: Data masking of user-defined functions may result in crashes in SQL Server 2019 Q4530303 KB4530303 October 20, 2020
• 4530281 FIX: Typo in error message for Columnstore indexes on temporary tables in SQL Server 2019 Q4530281 KB4530281 October 20, 2020
• 4530259 FIX: Scripts generated by SSMS collect different wait types after you install SQL Server Q4530259 KB4530259 October 20, 2020
• 4530251 FIX: Error 8601 occurs when you run a query with partition function in SQL Server Q4530251 KB4530251 October 20, 2020
• 4530212 FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server Q4530212 KB4530212 October 20, 2020
• 4530097 FIX: Package execution may be impacted in SQL Server 2019 Integration Services Q4530097 KB4530097 October 20, 2020
• 4530084 FIX: Error occurs when you try to install SQL Server 2019 on a low power CPU Q4530084 KB4530084 October 20, 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 20, 2020
• 4530054 FIX: Worker stealing stops working when AG contains one or more encrypted databases in SQL Server 2019 Q4530054 KB4530054 October 20, 2020
• 4529944 FIX: Unsigned files are installed through the Microsoft MPI in SQL Server 2019 Q4529944 KB4529944 October 20, 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 20, 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 20, 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 20, 2020
• 4529876 FIX: Memory may not get released when you process partitions with data in SQL Server Q4529876 KB4529876 October 20, 2020
• 4529848 FIX: PolyBase DMVs may return unexpected results after changing PolyBase enabled setting in SQL Server 2019 Q4529848 KB4529848 October 20, 2020
• 4529833 FIX: sp_describe_parameter_encryption returns different results if you switch parameter positions in SQL Server 2017 and 2019 Q4529833 KB4529833 October 20, 2020
• 4528492 FIX: DTC transaction scenario reports unsupported transaction error when HkTempdb transaction is used in SQL Server 2019 Q4528492 KB4528492 October 20, 2020
• 4528491 FIX: Access violation occurs when you call HkError.Throw() in SQL Server 2019 Q4528491 KB4528491 October 20, 2020
• 4528490 FIX: Access violation occurs when attempting to fetch the IAM page of the table in SQL Server 2019 Q4528490 KB4528490 October 20, 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 20, 2020
• 4528250 FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server Q4528250 KB4528250 October 20, 2020
• 4528168 FIX: Using temporary tables across multiple scopes may cause Error 213 or access violation in SQL Server 2019 Q4528168 KB4528168 October 20, 2020
• 4528139 FIX: "Debug Assertion Failed" error if you create objects that are not hashed by name in SQL Server 2019 Q4528139 KB4528139 October 20, 2020
• 4528097 FIX: Access violation occurs when you query sys.dm_db_persisted_sku_features DMV in SQL Server 2019 Q4528097 KB4528097 October 20, 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 20, 2020
• 4528066 FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 and 2019 because of NCCI Q4528066 KB4528066 October 20, 2020
• 4527916 FIX: You may receive incorrect object_id after you switch a partition in SQL Server 2017 and 2019 Q4527916 KB4527916 October 20, 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 20, 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 20, 2020
• 4527510 FIX: User hierarchy is not hidden when you run DISCOVER_CSDL_METADATA in SQL Server Q4527510 KB4527510 October 20, 2020
• 4527355 FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server Q4527355 KB4527355 October 20, 2020
• 4527229 FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server Q4527229 KB4527229 October 20, 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 20, 2020
• 4526315 FIX: Database cannot recover and reports error 5243 in SQL Server Q4526315 KB4526315 October 20, 2020
• 4525483 FIX: Exception error 3628 may occur when you run stored procedure in SQL Server Q4525483 KB4525483 October 20, 2020
• 4524542 FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU Q4524542 KB4524542 October 20, 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 20, 2020
• 4523102 FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS Q4523102 KB4523102 October 20, 2020
• 4522405 FIX: Non-yielding scheduler error occurs when you run batch query with sort operation in SQL Server 2017 and 2019 Q4522405 KB4522405 October 20, 2020
• 4522002 FIX: SQL Server 2017 and 2019 on Linux fails with an Assertion error Q4522002 KB4522002 October 20, 2020
• 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 Q4521960 KB4521960 October 20, 2020
• 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 October 20, 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 20, 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 20, 2020
• 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 Q4519796 KB4519796 October 20, 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 20, 2020
• 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server Q4519366 KB4519366 October 20, 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 20, 2020
• 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server Q4517771 KB4517771 October 20, 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 20, 2020
• 4515772 FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server Q4515772 KB4515772 October 20, 2020
• 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 October 20, 2020
• 4034376 FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature in SQL Server Q4034376 KB4034376 October 20, 2020
• 4580648 FIX: Errors may occur or PolyBase services fail to start when you run PolyBase queries on a non-English OS Q4580648 KB4580648 October 19, 2020
• 4580639 FIX: PolyBase queries can now be run with EXECUTE AS impersonation context in SQL Server 2019 Q4580639 KB4580639 October 19, 2020
• 4579223 FIX: PolyBase processes delayed to avoid data dump during provisioning in SQL Server 2019 Q4579223 KB4579223 October 19, 2020
• 4578292 FIX: Error occurs when you try to deploy CU5 or CU6 for SQL Server 2019 BDC irrespective of the azdata version Q4578292 KB4578292 October 19, 2020
• 4577837 FIX: Queries fail if storage pool caching is enabled by default in SQL Server 2019 Big Data Cluster Q4577837 KB4577837 October 19, 2020
• 4538581 FIX: Scalar UDF Inlining issues in SQL Server 2019 Q4538581 KB4538581 October 7, 2020
• 4560494 FIX: MDX queries with calculated measure using the "/" operator run slow in SSAS Q4560494 KB4560494 May 15, 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