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
44
views
Running into MSSQLSERVER_701 "insufficient memory in the resource pool to run the SQL queries" when Azure SQL backup runs
We have a VM that was on-prem, but we recently moved it into Azure. The VM hosts a SQL Server instance with a few databases on it.
After setting up a schedule of SQL database backups through Azure, we'...
-1
votes
1
answer
64
views
SQL Server comparison in VS does.. nothing?
I am using a script to copy data from a subset of tables in one server to a second server, such that the second server has fewer tables than the original. Data should otherwise be identical.
I ...
0
votes
1
answer
39
views
DLL switch over issue while AOAG automatic failover
We have configured AOAG in our environment, but when performing automatic failover from one node to another, the DLL is not enabled automatically in the second node. We are manually enabling the DLL ...
1
vote
2
answers
97
views
Understanding Recovery Forks in SQL Server: Meaning and Significance
I'm trying to understand the concept of recovery forks in SQL Server, particularly in relation to the sys.database_recovery_status view. The documentation mentions several columns related to recovery ...
1
vote
1
answer
86
views
What is the impact on an index when I am widening a key varchar column
One of the central tables in my database has a varchar(25) column named EmployeeID.
This column is used within a compound index and is likely the most used index in our system.
We got an enhancement ...
-2
votes
0
answers
30
views
Full text search with localization variants
I'm trying to update an old search function that used a lot of LIKE and REPLACE functions to get results with a lot of CPU time required, which is pretty much blocking most of the server it's running ...
0
votes
0
answers
43
views
SSRS - Microsoft.ReportingServices.Diagnostics.Utilities
I am troubleshooting an error in SSRS
we want to alter a subscription and set it to the next 5 min from now, but when it gets there it does not run.
other than that,
I see these error messages in the ...
0
votes
0
answers
29
views
Error Delete Distributor on sql Server 2019
I can't delete Distributor. The system shoew message error "Could not drop the Distributor 'Dis_name'. This Distributor has associated distribution database"
-1
votes
1
answer
90
views
What is choice between node drain versus role switching in WSFC FCI patching?
I'm learning about patching OS and SQL FCI.
I have a 2 node SQL FCI (active/passive). The SQL service exists on both nodes, but is running only on the active node. This is managed by the WSFC.
I also ...
-2
votes
3
answers
96
views
Why does killing a SQL Connection allow a reconnect with SSMS
I would like to kill connections for individuals using certain sql auth logins in SSMS that are reserved for our apps. They should have to go out of their way to reauthenticate into sql and at least ...
-1
votes
0
answers
38
views
SSMS doesn't list freshly installed instance of SQL Server, only previous deleted/uninstalled version
I uninstalled both SQL Server and SSMS on a Windows Server 2019 machine. I reinstalled SQL Server 2019 and created the default database MSSQL and installed SSMS 20. When I open SSMS, it only lists ...
5
votes
1
answer
173
views
How does sp_executesql interact with temporary tables?
I'm at a loss as to why some SQL leveraging sp_executesql is working the way it is when temporary tables are involved, along with INSERT and SELECT - INTO. I'm using SQL Server.
Here is the code in ...
1
vote
1
answer
63
views
Query Optimizer Auto-updating stats before executing stored proc?
All of the evidence is stating that this is correct, but I need someone check my math on this...
I have a stored procedure that does the following:
Insert a status record into a table
Table trigger ...
0
votes
0
answers
26
views
SQL Server replication latency issue
SQL Server 2019 patched a couple months ago. As of this morning my transactional replication is very far behind in latency. The distributor is on the replication box.
What I've ruled out:
resource ...
2
votes
1
answer
75
views
how to set in-transit encryption sql server?
today I had to check if in-transit Encryption was up and running in a particular server (sql server) and if not then set it up.
the way it is done is:
In SQL Server Configuration Manager, expand SQL ...