Questions tagged [sql-server]
Questions related to Microsoft SQL Server 2016 through 2022. Questions for older versions are off topic. If your question is version specific please tag it specifically for that version. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.
13 questions from the last 365 days
Score of 2
0 answers
93 views
Microsoft SQL Server on NVMe drive
I'd like to install MSSQL 2025 on top of Windows Server 2025 Standard. There is nice tweak which switch from SCSI drivers to native NVMe and gives significant storage boost.
reg add HKEY_LOCAL_MACHINE\...
Score of 1
2 answers
263 views
Why does a SQL Server stored procedure generate different execution plans depending on the parameter value?
I am testing query execution plan behavior in Microsoft SQL Server 2022 Developer Edition and SSMS 20.2.1
Table:
CREATE TABLE Orders
(
OrderID INT,
CustomerID INT,
OrderAmount INT
);
...
Score of 0
0 answers
119 views
No Endpoints Available Error When Trying to Setup Distributed Transactions (DTC) Between Domain and Non-Domain SQL Servers
We have a primary database SQL Server 2022 Enterprise cluster using Always-On Activation Groups running in our domain and a small SQL Express 2022 running on a standalone Windows Server 2022 non-...
Score of 1
0 answers
35 views
Large discrepances on plan for a SQLServer query
I enabled QueryStore on a SQL Server database and I see 1 specific query taking a lot of time. But this seems to be specific to a few calls (with specific parameters maybe?).
This is a call to a ...
Score of 0
1 answer
146 views
How would I add a catalog to a linked server in Microsoft SQL?
This is a common question that I cannot seem to find anything on.
How do I add an existing catalog to a linked server?
I have read through the "you have to add a login to the catalog you need to ...
Score of 2
2 answers
245 views
Can Transact-SQL snapshot backups be done with commodity hardware in Docker?
My preferred SQL Server home lab is in Docker on a low grade Linux laptop. I want to see how availability group secondaries react to application-aware snapshots. Transact-SQL snapshot backups make ...
Score of 0
0 answers
92 views
SQL Server 2019 - Intermittent Service Freezes and "State 23" Authentication Failures on Windows Server 2022
Environment:
SQL Server: 2019 Enterprise (15.0.4430.1)
OS: Windows Server 2022 Standard (Build 20348)
Virtualization: QEMU/KVM (Standard PC Q35 + ICH9)
Security: Bitdefender GravityZone
...
Score of 6
1 answer
813 views
sqlservr.exe writing to System Volume Information folder
Our Microsoft SQL Server sometimes has performance issues due to extensive I/O being triggered.
We may have insufficient (in terms of performance) storage, but I noticed that during this behavior ...
Score of 2
1 answer
356 views
How Does my WIndows Cluster Computer Object have permission to Create other AD Computers
I have a SQL Server Availability group which sits atop of a WSFC on a Windows Domain. There are two nodes in the cluster, both of which are SQL Server availability group replicas
My SQL Server ...
Score of 0
1 answer
208 views
MS SQL Server login failed
I installed MS SQL Server on a Google Compute VM using standard image.
I can connect to the VM via RDP.
I open Microsoft SQL Server Management Studio and can see the database instance running.
When I ...
Score of 1
1 answer
565 views
PHP-fpm (v 8.3) not using sqlsrv or pdo_sqlsrv on Ubuntu 24.04
My VM running Ubuntu 24.04 is giving an error that it cannot find the driver for SQLServer (aka MSSQL-Server aka sqlsrv). Sure enough, a page with phpinfo(); shows no sqlsrv or pdo_sqlsrv.
Here were ...
Score of 1
2 answers
311 views
Azure "Run Command Script" Invoke SQL on new SQL Server VM using "NT AUTHORITY\SYSTEM"
I deploy SQL Server 2022 Azure VM's on a regular basis. I want them to be pre-configured with a series of company standards (the details are not that important just know that this involves restoring ...
Score of 3
1 answer
321 views
How to fix Powershell script when it says "mdf, ndf and ldf already exist"
I have a PowerShell script producing the error below:
Set-DbatoolsInsecureConnection -SessionOnly
Get-ChildItem "F:\WH_BEE\FULL\WH_BEE_FULL_$(Get-Date -Format "yyyyMMdd")_*.bak" | ...