Here is an example - modifying Jeff Moden's code:

--===== This could be a parameter that you pass to an iTVF (Inline Table Valued Function)
DECLARE @pJSON NVARCHAR(MAX) =...

Damn!  Awesome catch,...

You may want to validate the return value from OPENJSON - I believe it returns an NVARCHAR and that could have a significant impact on performance.

As I responded on SQL team forum:

You don't need to remove the database from the AG to shrink the log.  You should just issue DBCC SHRINKFILE and follow that up...

I am with Grant - I don't see any reason to be splitting a table.  No matter what - all development groups will still need access to the original table...

Backup and Restore history is kept in the MSDB database and there are plenty of code examples of pulling that information.  Instead of trying to pull that information from the...

Heh... you're seriously going to export SSNs to a file in an unencrypted manner along with all that nice PII.  What company did you say you work...

Just curious...

If you are referring to a Failover Cluster Instance (FCI) in the cluster - where that instance has been installed in the cluster using shared storage, then yes - the...

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-823-database-engine-error?view=sql-server-ver16

Looks like you have a problem with the storage that needs to be corrected.

Consider enabling query store and/or setup an extended event to identify long running queries.  If the performance is actually related to something in SQL Server - it will almost certainly...

I don't believe an SPN would be created for those accounts - they are local to that machine only.

The simplest would be to add a where clause - but I am guessing that you want all voucher's with the 'latest' transaction type available for that voucher.

If that is...

There are many factors to how long it will take SQL Server to deliver the results to a client - including network time and processing time from the client.  If...

Okay, point taken and thank you for teaching me that. However, this query is very simple. It is literally just select column one column two column 3 from table...