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 10 months, 4 weeks 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 12 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, 2 months ago by Thomas Franz.

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

• This reply was modified 1 years, 3 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...

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...