Questions tagged [sql-server-2022]
SQL Server 2022 (major build version 16.00.xxxx). Please also tag sql-server.
122
questions
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 &
...
- 1
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 ...
- 314
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
...
- 3,476
0
votes
0
answers
17
views
Restoring of OLTP In-Memory DBs in SQL 2022 on Ubuntu really slow
We've started using OLTP In-Memory tables (schema durability only) in a small DB (DB properties show 137 MB of Row data, 1GB of In-Memory data, BAK size of 152MB) and the recovery times (either ...
0
votes
0
answers
39
views
Use cases for APPLYs [closed]
Which is the most common use cases of CROSS APPLY and OUTER APPLY?
I've read about these so much but every use cases and example queries looks like that can also be done by regular JOINs.
I know that ...
- 11
0
votes
1
answer
42
views
import extended properties of sql server database from xls file
I have a list of extended properties for all databases in an excel file. How can I import that into extended properties of each database in sql server.
- 1
0
votes
0
answers
54
views
Unable to select "other data source" when creating linked server
I am unable to select the option for Other data source when creating a linked server in SSMS, because the option is completely grayed out. I have installed Microsoft OLE DB Driver (MSOLEDBSQL) for SQL ...
0
votes
1
answer
17
views
Login via SQLServer AlwaysOn "Listener" Failed (Error: 18456, Severity: 14, State: 5)
I have setup an AlwaysOn Availability Group on SQLServer 2022.
I have created a login on both replicas with same SID.
But I could not login via listener IP or DomainName via SSMS.
I could login ...
- 9
0
votes
1
answer
43
views
Error "No catalog entry found for partition ID ..."
When trying to delete disabled index or enable the same disabled index on one heavily utilised table, I am getting an error:
No catalog entry found for partition ID 72057594967228416 in database 6. ...
- 360
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 ...
- 45
0
votes
0
answers
82
views
Restore SQL Server database - getting error Msg 3287
I am restoring a .bak file to a local database for the data received from a vendor. The .bak file is around 75+ GB in size.
I do NOT know the server version using which backup is created. I do NOT ...
8
votes
3
answers
887
views
View doesn't recognise a change to an underlying table when an existing column is dropped and replaced with one with the same name but as computed
My understanding here is that when a View is created, the definition is stored in metadata sys.tables. i.e. sys.views.
Also, that if you use SELECT * FROM it will store the exact column names e.g. ...
- 513
2
votes
3
answers
231
views
High Memory Usage for SqlBulkCopy
I've started to use the QueryStore to monitor my App and one of the things I noticed is the unexpected high memory usage for what I thought a simple operation:
Which would mean the statement uses ...
- 27
1
vote
1
answer
49
views
How to configure listener when using read scale AG?
I have a cluster-less AG (read scale AG) without a listener.
Our network admin has set DNS entry to point to primary node. All applications use that DNS name for database connections.
Post failover ...
- 3,476
3
votes
3
answers
466
views
Enforce non-unique combination of columns, where combination is required
I have the following (and more non-related) columns in my MSSQL database table: Id, ImageUrl and ImageId.
The combination of ImageUrl and ImageId can occur multiple times. ImageUrl belongs to ImageId ...
- 141