Why does normal execution resume after Raiserror in Catch block
When I execute the SP below, I get the output “error outer – INTERESTING THIS FIRES”. I do not get “error inner – INTERESTING THIS FIRES”
How to speed up SQL query with multiple joins
My MSSQL Server was upgraded over the last few days to 2019 version.
I don’t run this query often, so I don’t know whether it was faster before the migration.
CDC Capture job fails with ‘Cannot insert duplicate key row in object cdc.Table_CT’ with unique index ‘CT Clustered Index’
When the CDC Capture job runs it fails with ‘Cannot insert duplicate key row in object cdc.Table_CT’ with unique index ‘CT Clustered Index’.
This index is a sql server cdc created index (columns __start_lsn, __$command_id, __$seqval, __$operation)
Why does this SQL function return a “Subquery returned more than 1 value” error inconsistently?
I’m hitting a strange issue with a SQL Server query, whereby depending on the server I run it on, it might error, e.g. one server the query will always fail on, but another it never will. The error is the typical error where a subquery returns more than one result and assignment or comparison is used:
What does dollar sign $ mean in a view definition?
I wanted to see the definition of system view sys.configurations.