Questions tagged [sql-server]
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
35,016 questions
0
votes
1
answer
39
views
Strange CheckDB Results
I think I have a failing disk sub-system on a Proxmox VM running Microsoft SQL Server 2019 (RTM-CU32-GDR) (KB5065222) - 15.0.4445.1 (X64) Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 ...
- 430
-2
votes
2
answers
38
views
Maintenance Plan Wizard on 2025 (R1)
I’m experiencing issues with Microsoft SQL Server 2025 (RC1) because there are no maintenance plans. It’s not a problem — I can create a job instead. However, I’d like to know how to install or enable ...
0
votes
2
answers
74
views
xEvent Not Capturing Events for Large Memory Grants in SQL Server
I want to capture SQL Server queries with a memory grant over 10 GB so those queries and the tables they touch can be tuned to reduce the memory grants. I created an extended events session and a test ...
- 416
0
votes
0
answers
34
views
SQL Server 2022 CU11: Specific CPU Cores Constantly Spiking After Plan Cache Fills
We have observed an unusual CPU behavior on our SQL Server 2022 (Core Edition) starting from a specific date.
The issue is that a few specific CPU cores — particularly cores 1, 7, 14, and 21 — ...
1
vote
1
answer
81
views
Non clustered index including all columns smaller than the clustered index
While messing around in SQL Server to get a better grasp on indices, I'm quite surprised to see that if I create an index (on another column than the PK) that includes all columns, it is still lighter ...
- 227
-1
votes
0
answers
30
views
Commvault Backups For SQL Server [closed]
Is anyone using the Commvault agent for SQL backups please? If so what are your thoughts/experiences?
As a DBA I would prefer to use native SQL backups, but I am trying to keep an open mind......
- 74
0
votes
0
answers
47
views
SQL Server Error 4011: The incoming tabular data stream (TDS) protocol stream is incorrect. The MARS TDS header contained errors
I was told I would have more luck here so this is a clone of https://stackoverflow.com/questions/79783222/sql-server-error-4011-the-incoming-tabular-data-stream-tds-protocol-stream-is?noredirect=1#...
- 1
-1
votes
0
answers
52
views
Migrating SSIS from using Microsoft Connector for Oracle to ADO.NET
With Microsoft's notice back in January that SSIS in SQL Server 2025 no longer being supported, we're looking to move from the Microsoft Connector for Oracle (prev known as Attunity) over to the ADO....
Shawn Guillemette
0
votes
0
answers
46
views
Emptying partition, Sch-M locks
I'm trying to find a good way of refilling partition of the table without locking other partitions.
Essentially, I have partitioned clustered columnstore table, which I query often and need to refill ...
- 394
3
votes
1
answer
116
views
The specified value for setting 'SAPWD' is invalid. The expected value type is SqlSecureString
I am trying to configure a process for Installing SQL Server 2022 (DEv edition) Silently. I have created the .ini file as follows:
; SQL Server 2022 Developer Edition Silent Installation ...
- 75
0
votes
1
answer
65
views
Can not start Server after run out of space transaction
Environment
Database: Microsoft SQL Server 2014
Host: Virtual Machine
Disk layout:
C: drive -> 150 GB (system, SQL data/logs)
D: drive -> 500 GB
I ran script against the database which was ...
shi
0
votes
0
answers
50
views
Best approach to sync preprod from prod without breaking transactional replication
I’m seeking recommendations on the best way to synchronize our preproduction environment from production without disrupting the existing transactional replication.
Currently, both our production and ...
0
votes
1
answer
124
views
SQL Server 2022 CPU usage with no workload
I have a little application using a SQL Server 2022 Express database running in Docker.
This is my configuration:
mssql:
image: mcr.microsoft.com/mssql/server:2022-latest
deploy:
labels:
...
Sierrodc
0
votes
0
answers
70
views
DBCC CHECKDB DATABASENAME ERROR TIMEOUT
I am on SQL Server 2019 and running into the following error. The database in question is in SINGLE_USER mode.
DBCC results for 'CourierComplete'.
Msg -2, Level 11, State 0, Line 0
Execution Timeout ...
4
votes
2
answers
358
views
Best solution to prevent loop between tables for granular relations
I'm having difficulty to chose a table design for my situation.
We need to be able to declare animators on a course, and then we reserve dates for sessions on the said course.
At first, the tables ...
- 227