There aren't any joins in the query...

Thank you Scott and Jonathan.

Hi Jonathan, question came into mind, if the batch size is specified as 1000 but assuming if the qualified rows based on where condition is...

DECLARE @BatchSize INT = 1000; -- Adjust batch size as needed
DECLARE @RowsAffected INT...

duplicate

• This reply was modified 8 months, 1 week ago by  Jonathan AC Roberts.

duplicate

• This reply was modified 8 months, 1 week ago by  Jonathan AC Roberts.

SELECT *
  FROM TableA A
 WHERE NOT EXISTS(SELECT *
                 ...

DROP TABLE IF EXISTS MemberDiagnosis;
go
-- Create the table
CREATE TABLE MemberDiagnosis (
    MemberNbr INT,
    dx VARCHAR(50),
    dx2 VARCHAR(50),
 ...

" If Table Scan (heap) does that exactly that, then what is the problem to use the index, which will actually be able to help finding those records quicker? Or...

Is there an explicit BEGIN TRANSACTION in the code with no COMMIT?

MY_ADV.Pub.value('(reference_number)[1]','varchar(10)')

We collect these statistics on a weekly basis. This way we persist runtime history for all monitored instances.

This comes in handy when provisioning for growth or planning migrations.

Devs and...

If you don't have all the columns that are included in the query in the index then SQL Server will have to read the index then go off to the...

Apart from saving space it is unlikely that rebuilding or reorganising the index will improve the performance of anything, in fact it might make it worse.

It sounds like the entire...

I am surprised that no one else answered the original question - and this just evolved into using temp tables and trying to solve the performance issue using a...

duplicate

• This reply was modified 8 months, 1 week ago by  Jonathan AC Roberts.