SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
2 answers
How to prevent auto-update of SQL Server 2025 Engine?
Hi. I am convinced of a JSON bug introduced somewhere between CU4 and CU6. I want to reinstall my instances so I can troubleshoot and then post the bug if it exists. I have repeatedly uninstalled my SQL Server 2025 instances. I have reinstalled 3 RTM…
SQL Server Database Engine
asked
2026-08-20T16:21:39.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jeff Foushee
96
Reputation points
commented
2026-10-30T16:05:19.6233333+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
2 answers
How to install transactional replication when publisher is 2022, distributor is 2022, and subscriber is 2019.
How to install transactional replication when publisher is 2022, distributor is 2022, and subscriber is 2019. Publisher uses Always On Distributor uses Always On Subscriber uses Always On SQL Server service_account is different for publisher,…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-29T19:44:27.57+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hickson, Melvin
0
Reputation points
answered
2026-10-30T01:10:32.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepesh Dhake
1,325
Reputation points
3 answers
SQLCLR scalar function spins on DIAG_OBJECT at high DOP: CPU per call 36 times higher at DOP 24 than at DOP 4
On SQL Server 2025 CU10 (17.0.5035.5, KB5125471, also seen on CU4), on Linux with 24 schedulers, a trivial SQLCLR scalar function called once per row in a parallel plan costs far more CPU per call as DOP rises, and the query is slower at DOP 24 than at…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-25T16:16:45.3366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 42%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Brien Send
0
Reputation points
answered
2026-10-29T16:50:59.29+00:00
Deepesh Dhake
1,325
Reputation points
2 answers
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-09-30T16:28:53.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 79%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOW%3C/text%3E%3C/svg%3E)
orville wright
0
Reputation points
edited an answer
2026-10-27T16:26:07.43+00:00
Alison A
5,320
Reputation points Microsoft External Staff
Admin
2 answers
SQL Server 2022 - Why does a DELETE using a clustered index scan block on an uncommitted INSERT’s key lock when its predicate excludes that row?
I have a single-column table (Number, bigint, PK, clustered, unique) that is usually small (always under 5,000 rows, typically 1,000 or fewer). Service A frequently INSERTs rows inside long-running transactions. A row is inserted but not committed…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-22T22:05:10.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 13%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Seth
0
Reputation points
commented
2026-10-26T14:21:00.4566667+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
how to fix this error
TITLE: Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-23T19:03:36.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
Ujwala Desai
20
Reputation points
accepted
2026-10-26T11:59:38.87+00:00
Ujwala Desai
20
Reputation points
2 answers
Error 1639 al instalar SQL Server 2025 Express en Windows 11
Estoy intentando instalar SQL Server 2025 Express en Windows 11 Home Single Language. La instalación falla con el error 1639 y el mensaje "MSINEWINSTANCE requires a new instance that is not installed". El informe de descubrimiento no muestra…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-25T03:48:55.5133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 98%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFF%3C/text%3E%3C/svg%3E)
FABRIZIO FIGUEROA
0
Reputation points
answered
2026-10-25T10:58:22.5233333+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
2 answers
How to download ss developer edition 2022
I want to load a developer copy of MSSS. I would prefer 2022 version as I am looking to work with an existing production system using 2022.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-25T03:06:07.3833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 82%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Colin Helliwell
0
Reputation points
answered
2026-10-25T10:42:09.19+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
1 answer
How to get audit details from sys.fn_get_audit_file, sys.dm_audit_class_type_map and sys.dm_audit_actions ?
Hi, I want to extract audit details by using following dmvs SELECT distinct event_time, succeeded, server_principal_name, database_name, object_name, statement,fng.action_id ,da.name,fng.class_type FROM sys.fn_get_audit_file('C:\Audit*.sqlaudit',…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2025-04-30T10:31:00.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 26%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
Yasir Anis Janjua
0
Reputation points
answered
2026-10-20T04:41:17.67+00:00
Rukshan edirisinghe
2,365
Reputation points
7 answers
One of the answers was accepted by the question author.
Where are the SQL Server developer edition downloads
Where are the developer edition download files for SQL Server 2022, SQL Server 2019, and SQL Server 2017?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-03-24T22:21:49.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 35%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Steve Margolis
35
Reputation points
answered
2026-10-19T15:24:38.8833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 92%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Reich, Christian
0
Reputation points
1 answer
One of the answers was accepted by the question author.
New CE ignores statistics for LIKE predicates on varchar columns with UTF-8 collations — fixed 9% guess (partially fixed in CE 170, `%x%` still affected, no backport)
SUMMARY For varchar columns using any UTF-8 collation (collation name ending in _UTF8), the modern cardinality estimator (CE model 120 to 160) never consults the histogram or string statistics for LIKE predicates. Every "LIKE 'prefix%'" and…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-08-21T14:07:13.2433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 98%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hubert
20
Reputation points
commented
2026-10-17T20:34:38.23+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server connect error with SSL Cert
Hello, I get this error when logging in to an SQL Server instance: ssl provider error 0 an existing connection was forcibly closed by the remote host error 10054 That happened after I added a certificate to that instance. The same certificate works…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-14T13:28:50.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 52%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
David Spenner
5
Reputation points
recommended
2026-10-17T10:42:50.32+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
3 answers
Resolve Deadlocks on Transaction Tables
I configured high-traffic transaction tables for our corporate workstation applications and enterprise services. Not only was I not able to maintain normal query performance during peak business hours due to parallel execution deadlocks, I have been…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-13T16:34:07.7866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 62%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFD%3C/text%3E%3C/svg%3E)
Freya Davies
5
Reputation points
commented
2026-10-16T15:52:30.89+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
1 answer
where to download sql server express 2022
Try to upgrade an older version of sql express 2017 to 2022. Where to download sql server express 2022, thanks
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-13T19:03:52.4166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 87%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AnneW
86
Reputation points
answered
2026-10-13T19:07:46.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 69%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Mark Woods
10
Reputation points
1 answer
One of the answers was accepted by the question author.
Rebuild Indexes vs Update Statistics
I have a 165TB database on SQL2022 server and is part of a DAG. ETL (load/delete) is done every night on 35k tables and the largest table average load is 5-6 million rows. The largest table is 6.5TB (30 tables over 1TB) and has six Non-Clustered indexes…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-13T16:13:04.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 15%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Parsons, Tim
20
Reputation points
commented
2026-10-13T18:44:49+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
1 answer
Performance Regression Observed on SQL Server 2025 Running on Windows Server 2025
A reproducible performance degradation is observed when executing an identical SQL workload through SQL Server Management Studio (SSMS) on SQL Server 2025 running on Windows Server 2025. The workload consists of inserting 200,000 records into a table…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-07T08:59:45.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 48%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
V, Priyadharshini (FT D AA IN SB PRO SEC)
5
Reputation points
answered
2026-10-08T15:41:38.89+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Server: Index creation and conversion issues with columnstore indexes — Encountering internal query processor errors
Problem description I am experiencing issues when creating or converting indexes on a table with existing data in SQL Server running on an Azure VM. Specifically, when I attempt to create or modify clustered columnstore indexes with options like…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-07T14:22:11.1166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 6%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nacho Cotanda Portoles
0
Reputation points
answered
2026-10-08T15:06:12.8666667+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Server 2022 Always On metadata calls slow after patching
Following recent patching of our on-premises SQL Server 2022 environment, transaction log backups have become significantly slower than before the patch. The servers are configured with SQL Server Always On Availability Groups. The issue affects…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-01T15:56:58.9866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 93%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jagadeesh Vadivel
0
Reputation points
commented
2026-10-08T10:17:50.0166667+00:00
Jagadeesh Vadivel
0
Reputation points
2 answers
Cannot successfully install SQL Server 2025 Developer Standard Edition due to Engine Services Feature failure
Attempted to install SQL Server 2025, but was provided with the error details listed below. It should be noted that previous versions of SQL Server, 2019 and 2022, were installed in the past, but are now removed from the device. Attempted repair resulted…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-07T13:48:11.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 10%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Richard Phu
0
Reputation points
answered
2026-10-07T16:28:12.69+00:00
Erland Sommarskog
138.5K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server new Python version?
We are running SQL Server 2022 with machine learning services to execute python scripts. At the moment we are using the supported Python version 3.10 but this version is End Of Life. Microsoft is not supporting a new version? What is the path to take on…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
799 questions
asked
2026-10-07T09:27:11.5166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 65%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Matthew
5
Reputation points
answered
2026-10-07T14:45:50.4466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
85,786
Reputation points