From the conclusion in the original article:

Keep in mind to delete all existing target backup files before you launch the next backup statement or backup job using a new compression...

Use the OUTPUT Inserted.* INTO #tmp on an INSERT when you need the IDENTITY / NEW_ID / SEQUENCE values for the new records (e.g. for further processing / creating referencing...

Before you all add now 16 other columns to your PK, please remind that you still must not have more than 900 bytes in a clustered index 🙂

Clustered Index:

Msg 1944,...

I'm not sure, if a check for >= @start_lsn would work, when there are multiple parallel inserts, each within its own session

E.g.

• session 1 uses 0x001 and  is very slow...

Well, MSSQL has several mechanics that can do something similar.

If you want to run a huge SELECT but don't care about the results open the Query Options  go to Results...

When you want it 100% correct, you should use ORIGINAL_LOGIN().

A sysadmin has the privilege to inpersonate another account (I use this sometimes to check permissions).

And only ORIGINAL_LOGIN() would return my...

• This reply was modified 1 years ago by Thomas Franz.

When you need to change an old procedure for the first time and decide to format it or make some other cosmetic changes, to this stuff first and check it...

• This reply was modified 1 years ago by Thomas Franz.

IS DISTINCT FROM or its counterpart IS NOT DISTINCT FROM are added in SQL 2022 and are very handy when comparing columns that may contain NULL

So instead of a slow

WHERE...

I doubt that anybody (besides some old, long retired boomer nerds that implented it decades ago) are using COLUMNS_UPDATED(), particularly since

• you could write  UPDATE(col1) OR UPDATE(col2) OR UPDATE(col3) to...

• This reply was modified 1 years, 1 months ago by Thomas Franz.

Seems to be an article based primary on the output of an AI - and even the caption of the article is wrong, since SSMS is just the GUI but...

The question is incorrectly formulated.

An INSERT on the end of a table (as with a clustered identity column) would usually just add new pages, while inserting into a table with...

I wonder, if someone is really using the COLUMNS_UPDATED() function - it is way to complex for 99% of the scenarios particularly when you need to shuffle bits and had...

• This reply was modified 1 years, 3 months ago by Thomas Franz.

No, you really don't want this...

• This reply was modified 1 years, 5 months ago by Thomas Franz.

I really wonder, why nobody ever has tried (or better was sucessfull) of running...

How can something be called feature complete, when it has a feature, but it is still clumsy? Is a person with a crippled limb "feature complete"?

Examples: see Brent Ozars 1st...