Questions tagged [sql-server-2022]
SQL Server 2022 (major build version 16.00.xxxx). Please also tag sql-server.
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 ...
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.) ...
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 ...
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 ...
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 ...
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,...
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 ...
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: ...
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, ...
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>].[<...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...