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.
4,853 questions
1
vote
2
answers
164
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
);
...
- 189
0
votes
0
answers
90
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-...
- 580
1
vote
0
answers
26
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 ...
- 483
0
votes
1
answer
98
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 ...
- 101
2
votes
2
answers
237
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 ...
- 47
0
votes
0
answers
53
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
...
6
votes
1
answer
770
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 ...
- 163
2
votes
1
answer
291
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 ...
- 145
0
votes
1
answer
179
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 ...
- 1
0
votes
1
answer
433
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 ...
1
vote
2
answers
277
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 ...
- 235
3
votes
1
answer
302
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" | ...
- 131
0
votes
0
answers
151
views
How to mount(/bind) a host folder for the database files for a Docker-ized SQL Server Express instance?
I'm executing the following command line on MS Windows 11:
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Pass@word" -e "MSSQL_PID=Express"
-p 1433:1433 --...
- 101
0
votes
1
answer
119
views
Power BI Report Server Database Login Password Change Issue
Facing an issue while attempting to change the database login password for Power BI Report Server.
After updating the password in the database and in the Report Configuration Manager, the following ...
-1
votes
1
answer
149
views
Can SSMS 21 run on VMware Fusion running on Apple Silicon?
I was able to install it without errors, but then when I launch the app from taskbar or start menu, nothing happens. I can still launch the older version SSMS 20 in VMware fusion just fine.
I've tried ...
- 36