nice article

Keep in mind, the modif % for filtered indexes is calculated based on the full tables number of rows !!

If needed, schedule a sqlagent job to update ( the wanted...

If your domain admins alsomigrated the SIDs to the new domain's SIDHistory, this should keep on working

This cannot be done on Azure SQL Db

Never give up ...

So, for Cross-DB ownership chaining to work, it is mandatory all involved schemas and objects have the same owner !

If not, the chain breaks, and it all...

BTW There are 20 columns nvarchar(256) = 20 * 512bytes ! due to Nvarchar .

So max 10240 bytes + the length of the other columns + nulls indicators.

I've tested with...

Did you check the actual consumption stats

SELECT
    OBJECT_SCHEMA_NAME(ips.object_id) AS schema_name,
    OBJECT_NAME(ips.object_id) AS table_name,
    ips.index_id,
    ips.partition_number,
...

Keep in mind columns actual data consumption may vary (insert vs update), so your columns length may actually be needed during the process.

Once it uses row_overflow_data, chances are your data...

Thank you for all that you, Andy and Steve did.

You didn't only build a great resource for may to use.

You guys really built a great foundation for people to grow...

No problem over here.

No extensions installed.

It should be available and incorporated in a decent development and maintenance process.

That being said, I join Phil's experience.

I'm happy to confirm that statement 🙂

Congratulations !

I've been enjoying it for nearly that whole era 🙂

We are using a partition function based on month number and have filegroups per month.

Best ref is the one Steve mentioned.

You can add filegroups as you want.

You need to map...

will there be concurrent activities?