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.
34,418
questions
1
vote
1
answer
32
views
Does enabling backup compression in a Back Up Database Task enable checksums, no matter what setting you pick for them?
Observations
The documentation says
To enable backup checksums in a BACKUP (Transact-SQL) statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option....
0
votes
0
answers
22
views
SQL server granular control over auto update statistics
I wanted to know if we get more granular control over auto update statistics at the index level in SQL server.
One of my DBs with auto update stats enabled recently started to have some behavioral ...
2
votes
1
answer
59
views
What kinds of operations could cause a "Temp table changed" recompilation?
Frequent recompilation happens in one SP with 'Temp table changed' cause. What kinds of operations on temp table would trigger this? There are no alter and create index operations on temp table, just ...
0
votes
1
answer
28
views
Is DBCC CHECKFILEGROUP worthless if you already run DBCC CHECKDB on all databases?
DBCC CHECKDB makes many other integrity checks redundant, but I can't see anything in the documentation saying if it makes DBCC CHECKFILEGROUP redundant. Is DBCC CHECKFILEGROUP worthless if you ...
-2
votes
0
answers
27
views
SQL Server: Two MERGE statements are blocking each other on a large partitioned table
Have a large table partitioned on an INT column. When I run two different MERGE statements on two different partitions of this table, they seem to be blocking each other.
Example:
-- Large table ...
0
votes
1
answer
33
views
How do I consolidate the related mappings?
I have a table which has mappings coming from different sources (one row for each source) for three different identifier types (idtype1 to idtype3) with idtype1 having the highest priority and idtype3 ...
1
vote
1
answer
45
views
Need to add user and assign roles automatically, using DDL Trigger, when database is created
I am trying to create an automated process that will add a user and assign them the roles of db_datareader, db_datawriter and db_ddladmin whenever a database starting with PA is created. I have ...
0
votes
0
answers
1
view
Version incompatibility error between the SQL-Server database backup and the SQL Server running in the Docker container on my Ubuntu 20.04 VPS
I have installed Docker and run a container on my Ubuntu VPS for resolving the version incompatibility between SQL Server and the backup file but even docker has not solved. During restoring the ...
0
votes
0
answers
30
views
Transactional replication is trying to update a row that does not exist yet. Why?
I've been tinkering with SQL Server 2019 and transactional replication for a little while now and I've hit a wall. Looking at the replication monitor I'm seeing the error "The row was not found ...
-4
votes
1
answer
57
views
Reorganize or Rebuild Spatial Indexes
Will there ever be a way to exclude or only include spatial indexes from the IndexOptimize tool?
0
votes
0
answers
54
views
Problem with many connections from RHEL 8.10 to SQL Server
I have simple script:
for i in {1..1000}
do
isql -v -k "Driver={ODBC Driver 17 for SQL Server};Server=mssqlserver,1282;Database=dbname;UID=user;PWD=xxx;Encrypt=no" >> aaa.log &
...
-2
votes
0
answers
72
views
Why would email alerts on severity 16 errors be desirable? [closed]
Errors for severities beyond 16 are standard. Such errors are signs of really serious problems. I've noticed that this script here includes alerts for severity 16. To my knowledge, severity 16 errors ...
2
votes
1
answer
130
views
Abnormal behavior in TempdB SQL Server 2019
We have recently migrated from a version of SQL Server 2014 to a SQL Server 2019 CU 26.
In all our tests everything went well before performing the migration but when we made the move to production ...
0
votes
0
answers
43
views
High CPU utilization on an idle SQL Server instance without user traffic
We have an SQL Server 2022 CU13 Enterprise on a Windows 2022 VM with 8 vCPU. The sqlserver.exe process shows a high CPU utilization between 10-15% even when there is no user generated load (meaning ...
1
vote
0
answers
23
views
How to audit server settings configuration changes other than view server state?
I want to capture the audit of server configuration settings changes.
For this I setup the SERVER_OPERATION_GROUP audit event.
This event is raised when Security Audit operations such as altering
...