Just a quick thought, if one uses ISNULL one can lessen the internal cardinality from the NOT IN subquery that are pushed into the nested loop.

😎

Here is an example:

            
December 18, 2022 at 1:54 pm
            
#4127131

            
            
                                                
        

We will need your help in order to be able to help you, so please help us!

😎

It would be greatly appreciated if you could provide the DDL (create table) script,...

Simple test harness to demonstrate the inefficiency of the string_split method 😉

😎

USE TEEST;
GO
SET NOCOUNT ON;
GO
DECLARE @SAMPLE_SIZE BIGINT      = 1000000;
DECLARE @STR_BUCKET  VARCHAR(20)...

Here is a slightly different approach that performs quite well given that only the two delimiter positions needed are used in the output.

😎

USE TEEST;
GO
SET NOCOUNT ON;
GO
DECLARE @TMP...

Quick question, are you consistently looking for the third value in the string?

😎

Here is a quick suggestion, mind you that there is no guarantee that the ordinals are correct 😉

YAT

😎

Yust Another Test 😉

Is the OS 32 or 64 bit and is the installer for the 2012 SQL Express the same architecture?

😎

The only time I use SQL Server 2012 Express these days is...

It is always...

You need to rewrite the trigger, get rid of the variables and make it set-based!

😎

What you have here is a SOROW (pronounced Sorrow), Single Only Row trigger, it can only...

My first question would be if the IT director had any connection to the local cloud provider 😉

😎

Actually around 5.000 tenants. Based on kind of application number of tenants in the worst scenario can reach 10.000.

Scope of application is related only to a very specific kind...

RTM is an interesting TLA, in my books it normally means Return To Manufacturer 😉

😎

Joking apart, there are some interesting changes in this version, now let us see how...

Quick question, how many tenants are you hosting and will that number change in the foreseeable future?

😎

Quick suggestion, use the appropriate geography spatial data type rather than long/lat columns, makes the calculation a lot easier 😉

😎

Quick question, do the affected reports' queries have anything particular in common?

😎

So far you have done what I would do in such a situation, next step is to look at...