The script will be *SLOW*, because it uses a scalar function and will be called Row-By-Agonizing-Row, multiple million times on a real database.

UPDATE tbl SET name =...

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

watashiato - n. curiosity about the impact you’ve had on the lives of the people you know, wondering which of your harmless actions or long-forgotten words might have altered the plot...

The Social Security Number may be theoretical unique per natural person, but there are people without (e.g. foreign customers). And as in any systems there are "holes" where people got...

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

I'd think it is better to really recompile all the procedures / triggers / views / functions etc. instead to hope, that the sys.dependencies-table is always 100% correct.

            
March 13, 2023 at 9:13 am
            
#4160052

            
            
                                                
        

I use CONTEXT_INFO() regularly to "disable" triggers just for one session (e.g. migration scripts or bigger updates that should not touch the history tables  / updated_at / _by columns or...

I agree - there is no real reason, to avoid MERGE. And if it seems to difficult to understand, you may need just some practice 🙂

I use it very often...

Short question: WHY should I backup direct from my local server to cloud storage?

Wouldn't it be much better / faster to create the backup locally and copy it to the...

• Basic
• a tiny bit Redabas (east German version of dBase)
• DOS batch files (wrote batch based GUI to launch my favorit tools and games)
• Delphi
• Cobol
• VBA (Access); used...

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

@Eirikur: of course it is possible to do the calculation with bit shifting, reversing, converting to binary etc., but WHY? Just because it is possible and makes some old assembler...

Very nice and informative article, but I miss one important point:

Unix timestamps are based on the UTC timezone (this may be clear for you but not for a random junior...

I wonder, where it would really help me.

The usual business logic (as total = amount * single_price or gross_price = net_price * (1 + tax_rate)) does not really be needed...

This article was wrongly linked under the topic "Columnstore Indexes are Finally Sorted in SQL Server 2022" in the newsletter from 20th July 2022.

I didn't find Steve Jones article with...

@Emmit:

why do you not use

DATEFROMPARTS(YEAR(cd.BirthDate), MONTH(cd.BirthDate), ABS(CHECKSUM(NEWID())) % (DAY(EOMONTH(cd.BirthDate))) + 1) AS new_birth_date

It would return random dates from month first to the month's last day.

why should this a problem? Random is random and each rule you add reduces the "complexity". If I know, that it must not be the original birth date, there are...

Just to refer to the orginal problem:

The root problem of the big log file could be fixed / prevented, if you would partition your tables. Ola's script would in this...