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 3 weeks, 4 days 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 3 months, 1 week ago by Thomas Franz.

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

• This reply was modified 4 months, 3 weeks 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...

Vote for DB-First too - as long it are additions to the database, e.g. new columns or tables etc. As long you provide good default values (for new columns), the...

I think this is an AI generated article that contains lots of failures posted by a person with no real knowledge that was not even willing to test the results...

you can speed your WHILE loops up, when you simply do

WHILE 1 = 1 -- endless loop
BEGIN
    UPDATE TOP (@batchsize) ... WHERE ...

 ...

Regarding to the costs of local storage:

On "my" SQL Server we bought four 16 TB SSD drives last year (there were no more internal spots free) that can store the...

Querying for GETDATE() BETWEEN valid_from AND ISNULL(valid_to, '20991231')  is...

Allowing no NULL in valid_from / valid_to seems to be a good idea. But implement it with a DEFAULT = '18991231'  on BOTH columns (as at one of my previous...

I don't see the need for this undocumented command for this case (attaching a file). In reality it would cause more problems that it solves.

The command for attaching a database...