Questions tagged [sql-server-2022]
SQL Server 2022 (major build version 16.00.xxxx). Please also tag sql-server.
17
questions
0
votes
1
answer
45
views
Using "sp_execute_external_script" as alternative of "sp_invoke_external_rest_endpoint" in SQL Server
We have a business requirement to be able to request an HTTP end-point when certain events occur in the database (an SQL Server database). We have a catalog of end-points which we control. We use both ...
- 3,721
1
vote
1
answer
99
views
TRY_CAST fails when fed very long string... but only from column or variable
I've recently encountered this weird behavior of TRY_CAST function, and I wonder what's going on here. (It feels like bug, but most of such bugs I have encountered in past were actually intentional.)
...
- 130
3
votes
0
answers
56
views
A hint changes query results. Why is this OK? [duplicate]
I have a query where OPTION(NO_PERFORMANCE_SPOOL) changes the resultset. I understood that hints affected the physical operations, not the values returned. I'd like help understanding why this is ...
- 24.1k
-1
votes
1
answer
37
views
Does running dbcc checkdb on the restored backup file be an alternative to running dbcc checkdb on that server? [duplicate]
I have 2 node AG server.
Say db name is TestDb.
Dbcc checkdb is run on TestDb weekly on both servers.
Daily full and hourly log backups run on secondary server. After backup th, db is restored and ...
- 3,153
2
votes
1
answer
67
views
AWS to Azure Degraded Performance With "Hash Match (Aggregate) Step"/"Temporary Disk" TempDB Performance Issue
Ok, so I have a series of AWS VM's, mostly using the z1d.3xlarge server class with built in SQL Server 2019, these servers each contain a NVMe of various size. (Not surprisingly) I've placed my SQL ...
- 205
11
votes
1
answer
320
views
Why does sys.fn_xe_file_target_read_file require an explicit cast on datetime2 column?
According to the documentation the returned column timestamp_utc should be of type datetime2(7)
But when I query like this
SELECT
*
FROM sys.fn_xe_file_target_read_file('system_health*.xel', null,...
- 3,286
2
votes
0
answers
161
views
MS SQL Server 2022 High CPU Usage Spikes Every Minute under no Load (Dual Processor)
Brand new MS SQL Server Standard 2022 Installation on a Dual Xeon 3416 system doing nothing and configured to do nothing fancy.
Every minute, on the minute for about 6 seconds there is a massive CPU ...
- 121
3
votes
1
answer
146
views
Extraordinarily inconsistent behavior from Sql Server regarding cached table definitions
Pre-warning: This question may not make sense at first blush, hopefully though anyone can play along by trying this out on their local Sql Server instance.
With all that in mind, consider two scripts:
...
- 232
-1
votes
1
answer
39
views
Remove Databases from HA Group using TSQL - SQL Server
I am trying to automate following steps using TSQL (It is currently working fine using Manual -GUI interface of SQLServer), working on SQLServer 2022
Create a table, with columns to store DBName, ...
5
votes
1
answer
413
views
Update fails on linked server after upgrading to SQL Server 2022
After upgrading SQL Server from 2019 to 2022 the following query with linked server has started to fail (I've omitted some column names and details for simplicity):
UPDATE [<remote server>].[<...
- 165
0
votes
1
answer
348
views
New SQL 2022 Servers won't register SPN
I've just built 2 new Win/SQL 2022 Servers. Everything went ok, and I could connect with SSMS.
I then changed both SQL engine services to use a domain acct (my standard practice), I can connect ...
- 3,145
0
votes
0
answers
218
views
Upgrading to developer edition from SQL Server 2022 Evaluation edition
I ran an inplace upgrade of a SQL Server 2019 Developer to SQL Server 2022 Evaluation on our dev environment in June. The evaluation period now has expired, so I tried to run an edition upgrade via ...
6
votes
2
answers
953
views
Does Instant File Initialization work for manual log file growths?
SQL Server 2022 introduced Instant File Initialization for transaction log file growth events. In the What's New in 2022 page, Microsoft notes:
In general, transaction log files cannot benefit from ...
- 42.4k
1
vote
1
answer
273
views
Can't Connect to WMI Provider on New SQL 2022 Install
I have a fresh installation of Microsoft SQL Server 2022 on Windows Server 2022 Standard. I'm attempting to enable Always On Availability Groups with the Enable-SqlAlwaysOn PowerShell commandlet but ...
- 111
0
votes
1
answer
84
views
SQL Server 2022 setup silently closes with no clue
When trying to install SQL Server 2022 from iso, I can't get setup wizard doing a single (visible) action when I click the "New SQL Server standalone installation" link.
Everything seems ...
- 11
0
votes
1
answer
425
views
How to create alias in SQL Server 2022
As per https://learn.microsoft.com/en-us/sql/relational-databases/native-client/sql-server-native-client?view=sql-server-ver16:
The SQL Server Native Client (often abbreviated SNAC) has been removed ...
- 343
16
votes
2
answers
2k
views
Why is SQL Server setup recommending MAXDOP 8 here?
I'm running SQL Server 2022 RC1 setup on an AWS i3.16xlarge with 2 sockets, 2 NUMA nodes, 32 logical processors per node, 64 logical processors altogether.
Setup is recommending MAXDOP 8:
But if you ...
- 42.4k