Thank you, Scott and Frederico, for the helpful advice!

I’ll take a closer look at the query plan tomorrow to verify whether it’s performing a seek or just a scan. I’ll...

Thank you for the detailed reply - it’s very helpful!

Just to clarify, the queries themselves don’t specify TENANTID in the WHERE clause. Instead, row-level security handles tenant filtering through

            
November 12, 2024 at 7:05 pm
            
#4480757

            
            
                                                
        

Thank you, Scott, for the helpful advice! I’d like to dive a bit deeper into point (2) to better understand how partitioning impacts performance in a multi-tenant setup. I’m new...

Here you are courtesy of ChatGPT:

Yes, it’s possible to run specific stored procedures (SP1 and SP2) in parallel and then have SP3 and SP4 execute in series within a main...

I would use EXISTS instead of IN

update m 
   set val = 'TEST' 
  from #MDM m
 where exists(SELECT 1
    ...

Try running the data transfer in multiple parallel sessions in SSMS, using chunked INSERT INTO ... SELECT queries. Open two or three SSMS windows, and in each, execute a separate...

Jeff,

The "url" link to the excellent article at the beginning of this discussion isn't working. I believe it should point to https://www.sqlservercentral.com/articles/hidden-rbar-triangular-joins, but only you have the ability...

First and foremost, stop dropping and rebuilding indexes, I don't care how bad the fragmentation is.  Even 90% logical fragmentation makes little difference.  What DOES make a difference is...

I think it is a typo, they probably meant to type '-- = inv.tblSoftware'

Which would mean that inv.tblSoftware is just a comment for clarity, describing something about the...

I think it is a typo, they probably meant to type '-- = inv.tblSoftware'

Which would mean that inv.tblSoftware is just a comment for clarity, describing something about the insert operation.

Setup some test data

CREATE TABLE TestCardData (
    s_Result NVARCHAR(255),
    s_credit_card_type NVARCHAR(50),
    s_credit_tran_type NVARCHAR(50),
    c_amount DECIMAL(18,...

.

• This reply was modified 2 months, 1 week ago by  Jonathan AC Roberts. Reason: duplicate deleted

You could use NULLIF or SET ARITHABORT OFF; SET ANSI_WARNINGS OFF;

SET ARITHABORT OFF;
SET ANSI_WARNINGS OFF;

DECLARE @x as int = 1, 
      ...

I used to be a front-end Developer... that's why I don't rebuild indexes all the time   ... The page splits that came after the rebuilds would slow down the...

I've written the script in the link above query and am using it. I've found that for a few of the of the rows it occasionally reports negative statistics. i.e....