SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
3 answers
One of the answers was accepted by the question author.
SQL connection failed with SSMS on workgroup when using FQDN
Hello, When I try to connect locally (or remotely) with SSMS on my SQL server with hostname "localhost" or "hostname" it works fine. However, if I try with "hostname.domain.com" it doesn't work I have error 18452 (Login…
SQL Server Database Engine
![](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(182.40000000000003, 32%, 27%)' 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)
1 answer
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
764 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
0
Reputation points
answered 2026-08-21T18:10:16.4066667+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
2 answers
Clarification on SQL Server License Compliance during FCI Migration (VMware to Hyper-V)
Hello everyone, I am currently executing an internal infrastructure migration project moving our environment from VMware to Microsoft Hyper-V, and I need some clarification on SQL Server licensing compliance during the transition phase. Current…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-30T16:48:14.3766667+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(140.8, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Sang. Truong Tan
0
Reputation points
edited an answer 2026-08-21T12:07:05.3766667+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
4 answers
One of the answers was accepted by the question author.
What are the best practices for improving SQL Server database performance?
I’m learning SQL Server and would like to understand the most important practices for keeping a database performant . Which areas should I focus on first, such as indexing, query optimization, statistics, execution plans, and database configuration?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-19T09:46:58.73+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(259.20000000000005, 40%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Steve John
20
Reputation points
accepted 2026-08-21T10:32:36.46+00:00
Steve John
20
Reputation points
1 answer
AG instance not in sync
We have 8 databases in an instance. All 8 databases are members of Availability Group. On the secondary replica, the whole instance is not synchronizing . Could you please advise how to bring the secondary instance as synchronized Thanks, Chaitanya
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-23T11:50:51.2733333+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(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
841
Reputation points
answered 2026-08-21T00:13:15.9866667+00:00
Ben Miller-(DBADuck)
285
Reputation points MVP
3 answers
Database refresh from Production to Dev
We want to restore some databases from Production server to Dev server. We want to create a job that automatically restores a fresh copy of these databases to Dev server on 10th of each month. Could you please advise on how to do this.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-06T19:39:45.92+00:00
Chaitanya Kiran
841
Reputation points
answered 2026-08-20T23:59:01.75+00:00
Ben Miller-(DBADuck)
285
Reputation points MVP
1 answer
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
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
answered 2026-08-20T21:05:09.9766667+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
2 answers
On-prem SQL server needs a Trust certificate
Hello Team, We have on-prem SQL Server which is running from Azure VM. From same Azure VM, we have Gateway running as well. However, we are facing an issue while connecting SQL server with PowerBI desktop and Services. For this issue, PowerBI team has…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-19T18:34:42.8+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(86.4, 34%, 18%)' 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)
Hemant
61
Reputation points Microsoft External Staff
answered 2026-08-19T19:35:18.43+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
4 answers
Clarification on MSOLEDBSQL19 Behavior with TrustServerCertificate=True
Hello Team, We are currently using the MSOLEDBSQL19 driver on Windows systems and would like to better understand its connection behavior related to encryption and certificate validation. While testing SQL Server connectivity, we observed that a…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-13T09:22:07.6666667+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, 77%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Modi (amodi)
20
Reputation points
answered 2026-08-19T13:31:03.5966667+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(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
sudhir kumar
0
Reputation points
2 answers
services.exe D:\MSSQL\MSSQL17.MSSQLSERVER\MSSQL\Binn\SQLAGENT.EXE ACCESS DENIED
I've been getting failed installs with SQL Server Developer Standard Edition on Windows 2025 Standard edition, error has been: services.exe 1000 QueryOpen D:\MSSQL\MSSQL17.MSSQLSERVER\MSSQL\Binn\sqlceip.exe ACCESS…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-26T15:48:06.9966667+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(313.6, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIB%3C/text%3E%3C/svg%3E)
Iain Barnetson
106
Reputation points
commented 2026-08-13T20:56:16.0866667+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
2 answers
2022 express edition and i have 2025 license
We currently have SQL Server 2022 Express installed on our server while waiting for the SQL Server Standard license. Our application only supports up to SQL Server 2022, and the license provided is also for SQL Server 2022. However, when we performed an…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-13T07:50:47.6733333+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(156.8, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
Kenneth Lapuz
0
Reputation points
answered 2026-08-13T14:51:35.7+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)
84,951
Reputation points
1 answer
keep getting random errors everytime i try to restore a database
Hello, I would love to have some remote assistance with my issue. I'm trying to restore a database from an old computer to a new one, but the old computer is on version 12 and any new computer I try to use wants me to upgrade to version 22, and I keep…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-10T15:54:44.6833333+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(121.6, 18%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Alex Negrich
0
Reputation points
edited an answer 2026-08-10T18:43:54.4133333+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
835
Reputation points
2 answers
AUTOMATIC_TUNING
i got this error when run the alter statement in sql server standard edition 2017 and above version on-premises environment, Note that querystore already enabled without any issues ALTER DATABASE current SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN =…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-10T11:28:43.99+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(156.8, 63%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Alagarsamy Sundararajan
0
Reputation points
edited the question 2026-08-10T12:16:51.6766667+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
2 answers
How to find and replace table name changes in stored procedures
I have create a SQL database with several tables and some stored procedures. Now I want to change the name of some of the tables. How can I get it to find and replace the changed table name in the stoed procedures
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-10T03:21:27.73+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(121.6, 40%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Michael Boahene
0
Reputation points
answered 2026-08-10T06:59:47.63+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
2 answers
sql server management studio 2018 user setup
how to set up user account and login for sql server management studio 2018 and connect to database
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-06T22:12:14.9133333+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(44.800000000000004, 30%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Candace Snipes
20
Reputation points
commented 2026-08-09T02:25:21.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(118.4, 51%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Ganesh Chelluri
190
Reputation points Microsoft External Staff
Moderator
1 answer
SQL server 2025 training
Hi Team, We are looking for SQL Server 2025 training for our Database Administration team. Could you please share: Available SQL Server 2025 training programs Course content and duration Virtual and instructor-led options Team pricing for…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-04T14:05:26.3633333+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(144, 28.000000000000004%, 23%)' 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)
ashutosh
0
Reputation points
recommended 2026-08-07T20:59:04.0133333+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
3 answers
Issue in the Installing the SQL Server
Hi Team, I'm using the Window 11 OS and the Processor - Intel(R) Core(TM) i3-10110U CPU @ 2.10GHz, 2592 Mhz, 2 Core(s), 4 Logical Processor(s). When i tried to install Microsoft SQL I was getting this error, please help me to resolve the issue.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-30T17:17:19.8333333+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(16, 59%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dhivya Krishnan
0
Reputation points
commented 2026-08-06T10:07:23.5733333+00:00
Dhivya Krishnan
0
Reputation points
6 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
764 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
30
Reputation points
commented 2026-08-04T16:52:30.9366667+00:00
Steve Margolis
30
Reputation points
4 answers
SQL Server 2022 Database Engine Recovery Handle Failed on Clean Windows 11 Installation
Hello, I am unable to install SQL Server 2022 (Express and Developer) on my Windows 11 Home laptop. Every installation fails with the following error: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-08-03T02:16:40.6166667+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(86.4, 82%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kiara Keys
0
Reputation points
answered 2026-08-03T08:33:09.4966667+00:00
Erland Sommarskog
136.7K
Reputation points MVP
Volunteer Moderator
1 answer
SQL Server 2019 Express installation fails on Windows 11 with SQLWriter service and Windows Installer DLL errors
I am trying to install Microsoft SQL Server 2019 Express on Windows 11 (64-bit). The installation fails with the following errors: Service 'SQL Server VSS Writer' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
764 questions
asked 2026-07-23T08:25:34.99+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(214.4, 91%, 30%)' 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)
sagar miroliya
0
Reputation points
edited an answer 2026-07-30T20:38:58.7566667+00:00
Deepesh Dhake
835
Reputation points