Core component of SQL Server for storing, processing, and securing data
SQL Server 2022 performance degradation (2x slower) with increased Context Switches/sec under Compatibility Level 110 after migration
Hi, Please note that this message was translated using Generative AI. I apologize in advance for any unnatural phrasing or translation errors. We recently migrated our database from SQL Server 2017 to SQL Server 2022 on a new virtual machine. After the…
SQL Server Database Engine
SQL 2016 to 2022 AG migration on Azure VMs: how to keep the existing DNN listener name working for apps that cache DNS and can't be restarted?
Environment Source: 2-node SQL Server 2016 AG on Azure VMs, using a DNN listener Target: new 2-node SQL Server 2022 AG on Azure VMs, Database: about 4 TB, to be migrated using a distributed AG Clients: many applications and reports that use the…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Geography STDistance() and ShortestLineTo() overestimate polygon-to-polygon distance in SRID 104001 (unit sphere)
(Microsoft SQL Server 2022) In SRID 104001 (unit sphere), STDistance() between two non-intersecting polygons returns values that are too large. In the cases tested, the error was up to about 63 km (converted with R = 6371 km) for polygons 200–500 km…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
KB5126149 cause SnowFlakeID broken in MS SQL Server
Below windows update package caused SnowFlakeID broken in MS SQL SERVER, this issue is very serious, caused all transactions cannot record, below are the KB and mapping windows version: OS .NET Update KB Vulnerabilities Addressed Win11 24H2 / 25H2…
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
firewall rule preventing user login
I have a sql database "LIMLdb" running on "apgsystems01" sql server running on a virtual machine. I need to be able to have my users log in from different locations. When they try the are assigned a new ip and cannot log in until I…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Can the date format in SQL Server 2022 Agent notification emails be changed?
SQL Server Agent’s standard notification emails on several SQL Server 2022 instances display timestamps in US format:9/30/2026 at 10:15:54 AM Windows regional settings and the SQL Server Agent service-account profile are configured for English (United…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL SERVER SUPPORT
How can I get sql server support from microsoft?
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Fabric Lakehouse: T-SQL write support, Spark vs T-SQL performance, and views in semantic models
Can T-SQL notebooks write to a Fabric Lakehouse, or is write capability limited to a Fabric Warehouse? If limited, is that a Lakehouse architecture constraint or a T-SQL constraint? For large-scale data engineering and transformation, does Spark SQL…
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
SQL Server 2025 Enterprise – Do I need additional core licenses to run Power BI Report Server on a separate server/VM?
Hello, We are planning to purchase Microsoft SQL Server 2025 Enterprise Edition and would like to use the Power BI Report Server (PBIRS) rights included with the SQL Server 2025 license. Our planned deployment is: Server A: SQL Server 2025 Enterprise…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Need to delete Millions of records from table which is part of Transaction Replication
I have transaction replication on a table. I have to delete millions of records from it. I want to create a SP to delete rows & replicate execution of SP. A few records mismatch might be there between Publisher & Subscriber. Will it cause issue.…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
how to Configure or Set query execution timeout from transact SQL
my execution timeout is always show 90, but i need to set it 0
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
Master Data Services web app renders empty after SQL Server CU26 update
Hi everyone, SQL Server 2022 CU26 appears to break Master Data Services web application. After patching to CU26 (16.0.4265.3), the MDS web application loads, but is completely empty. The MDS database and data remain intact and are visible through SQL…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Server 2022 MDS not showing data on portal after update
Hi After installing an updates on SQL Server 2022 i have problem with MDS. When i go to website and open a model I do not see data in it. Data are avaiable in views and by Excel addin. Is this some bug or I could have broke sth? Daniel
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
How to Export Text file without CRLF on very last data record
I have a data-driven subscription that writes a text file to a shared file area. Everything is fine. However, I added custom code in VB to see if I could strip the very last CRLF at the end of the file (EOF). The report ran, but it didn't remove CRLF. I…
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
SQL Server patching and Windows Server security patching
Could you please confirm whether SQL Server patching and Windows Server security patching can be performed during the same maintenance window, followed by a single reboot? Is this the recommended approach?
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Server 2022 Express download page (ID 104781) returns 404 – Is SQL Server 2022 Express still available?
Hello, We are trying to obtain the official installation media for Microsoft SQL Server 2022 Express, but we have found that the historical Microsoft Download Center page associated with SQL Server 2022 Express (Download ID 104781) is currently returning…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
sys.fn_hadr_backup_is_preferred_replica() are taking much longer than expected since the patch
We’ve noticed that SQL transaction log backups have become significantly slower following the recent SQL Server 2022 patching. The issue appears to be affecting multiple Availability Groups rather than a single database. For example, even checks such as…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
D365 Finance & Operations SSRS Report Deployment Failed – Unable to Retrieve SSRS Server IP Address / BiReporting.PersistentVirtualMachineIPAddress
Hello Microsoft Community, I am developing an SSRS report in Microsoft Dynamics 365 Finance & Operations using Visual Studio. I am able to build the report successfully, but when I try to deploy the report, the deployment fails with the following…
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
Error 8624, Severity 16: Internal Query Processor Error: The query processor could not produce a query plan.
Hi, Environrment : SQL Server 2022, build 16.0.4252.3 (CU24 + GDR, May 2026) We are experiencing an intermittent issue on Microsoft SQL Server 2022 Enterprise Edition running in an Always On Availability Group environment.A specific stored procedure…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
How to enable Microsoft Entra authentication for SQL Server 2025 Express enabled by Azure Arc?
Environment Windows Server 2025 Standard SQL Server 2025 Express 17.0.1135.8 Azure Arc enabled server Azure SQL Extension version 1.1.3518.465 Region: Germany West Central Background The server was originally onboarded in Poland Central, where…
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories