For non-LOG files, IFI causes the grow to be 'instantly'...

Best is to prevent the autogrow !

Set the file to a size(s) you estimate will be needed to host the data for the next couple of months / years

Is this on an Azure Managed instance ? You need to put temporal tables in place to have access to job history.

• Have you rebuild all indexes and statistics after migration/upgrade ?
• Did you compare old vs new SQLplans ?
• How many indexes / indexed views are based on the target...

FWIW If you don't need sub second information in datetime2 values, just use datetime2(0) ( and you gain 2bytes storage )

done.

Now, send me the email 😎

How did you notice that?

Have you tested it?

Whas there an errormessage?

Why would you consider version 18?

Read Paul's documentation : https://www.sqlskills.com/help/waits/vdi_client_other/

thank God they are using varbinary(max) for every item in the tables, or at least Nvarchar(max)

Are you using identities or sequences to auto-increment the IDs?

did someone RESEED your identity values ?

if @tocheck=1

DROP TABLE IF EXISTS #partA

begin

insert into #partA (ID)  <- this table no longer exists here if @tocheck=1 !!! ( you are not using select ... into #partA )

select...

Indexes art there for two reasons:

• to enforce a constraint , needed for the data model ( unique - primary key )
• to support queries.
• Depending on the consumption pattern,...

Can you elaborate about your instance ? OS / SQLversion & cu

Are you monitoring I/O performance ?

Can you post the full details of the errors you get ?

Did you check...

my  bad. Sorry

You cannot.

Wait until the query finishes ( or cancel the query )

check the Lock compatibility matrix