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,086 questions
3
votes
0
answers
67
views
SQL Server 2022 - Deadlock graph anomaly
I've come across what appears to be a strange deadlock graph/XML anomaly. As shown in the image below, a typical deadlock is shown (bottom), but then a completely isolated process graph is shown (top)....
- 31
2
votes
1
answer
244
views
sp_executeSQL does not appear to work for this table update
I've got this table:
CREATE TABLE [dbo].[CommitteeAssignments](
[sChamber] [char](1) NOT NULL,
[nBillNumber] [int] NOT NULL,
[nComNum] [int] NOT NULL,
[nSeqNum] [int] NOT NULL,
...
- 39
0
votes
1
answer
32
views
Is there any benefit to placing a Failover Cluster Instance in an Availability Group with cluster type WSFC, rather than none?
Suppose that I have a Failover Cluster Instance and I wish to add it to an Availability Group. Since I already have a Windows Server Failover Cluster, using a cluster type of WSFC should not be ...
- 1,340
-3
votes
0
answers
70
views
Handle 4000 upserts per second on Sql Server (MSSQL)
I have a 6 vCore Azure MSSQL database where I'm consuming from a Kafka topic at 4000 messages per second. No matter what I try it seems that this is pushing the limits of what's possible with this ...
0
votes
0
answers
59
views
Can't Create Schema with Entra Group in SQL Database
SQL server has the default principals public and dbo. We also have a an Entra group in which our users are assigned so that they can login and can only do what permissions the group has. With this ...
- 13
0
votes
1
answer
64
views
Easiest way to pull data nightly from multiple SQL Server 2012 servers into a central database?
We’re on SQL Server 2012 (ugh), and I’m trying to figure out the simplest and most reliable way to set up a nightly consolidation process on a tight timeline.
We have multiple databases on different ...
0
votes
0
answers
39
views
Ag listener fail to offline in 2 node always on without AD
Let me describe my env first:
Two nodes always on without AD (with witness share file)
Both node is sql server 2022 and windows server 2022
Both node is in same subnet
Set DNS server for these two ...
- 21
-3
votes
1
answer
116
views
Maintenance Plan Wizard jobs all error in SQL Server 2025 RTM
Maintenance wizard jobs such as DB Integrity* or DB Reindex* or "Misc Cleanup" all error as of production RTM version of SS 2025. I know - 2 of the above jobs can also be Ola H jobs but ...
- 25
-3
votes
0
answers
55
views
Monitoring tools [closed]
Currently, we use SolarWinds DPA as our database monitoring tool, but SolarWinds recently changed its billing model, making DPA very expensive. Any suggestions for a monitoring tool? We need to ...
0
votes
0
answers
85
views
Generic Replacement for xp_cmdshell That Supports More than 8000 Characters
Ok this restriction drives me crazy (and has driven me crazy for years):
xp_cmdshell -> input command_string is varchar(8000) or nvarchar(4000)
Understood it's not best practice to be using it in ...
- 215
10
votes
1
answer
774
views
Why doesn't SQL Server match computed column to an index when the expression is trivial?
I have a table with two computed columns (indexed, but not persisted). The first computed column matches an existing column exactly. The second computed column is an expression that adds 0 to the ...
- 2,337
0
votes
0
answers
58
views
Kerberos double hop issue from tenant joined laptops
We have laptops that are joined to an Azure tenant via intune. I would like to be able to do a double hop from SSMS on the laptop, over a linked server. The correct SPNs and delegations are set up on ...
- 53
0
votes
1
answer
56
views
Migrate availability group to new domain keep ip addresses
We need to move our Always On Availability Group (in SQL Server 2019) from one domain to another while still retaining the same computer names and IP addresses. I see that Server 2019 now supports ...
- 1
2
votes
1
answer
153
views
SQL Server: Sessions blocked on LCK_M_SCH_M by a session waiting on SLEEP_TASK
This morning, while checking the monitoring tool, I noticed an abnormally high LCK_M_SCH_M wait time on our testing SQL Server.
Looking at the WhoIsActive table (which logs the result of ...
- 375
0
votes
1
answer
65
views
What benefits does Log Shipping offer over cluster-less Availability Groups?
The documentation compares Log Shipping and Availability Groups with a Cluster Type of NONE.
In SQL Server 2017 (14.x) and later versions, you can create a near-real time, read-only solution with AGs ...
- 1,340
