Forum Replies Created

Viewing 15 posts - 61 through 75 (of 198 total)

  • Reply To: Simple script to de-identify data

    just did a small performance test (SQL 2022 Dev.):

    SET STATISTICS TIME, IO ON;
    DROP TABLE IF EXISTS #tmp1
    DROP TABLE IF EXISTS #tmp2

    SELECT TOP 2000000 o.name, LEFT(CAST(NEWID() AS VARCHAR(36)),...

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

    God is real, unless declared integer.

    May 24, 2023 at 12:58 pm

    #4196506

  • Reply To: Simple script to de-identify data

    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 3 years, 3 months ago by Thomas Franz.

    God is real, unless declared integer.

    May 24, 2023 at 12:10 pm

    #4196457

  • Reply To: Watashiato

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

    God is real, unless declared integer.

    May 19, 2023 at 1:28 pm

    #4193041

  • Reply To: How to Improve Database Design to Speed Up SQL Queries

    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 3 years, 3 months ago by Thomas Franz.

    God is real, unless declared integer.

    May 15, 2023 at 1:00 pm

    #4190084

  • Reply To: Find Invalid Objects in SQL Server

    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.

    God is real, unless declared integer.

    March 13, 2023 at 9:13 am

    #4160052

  • Reply To: Cross Database Context

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

    God is real, unless declared integer.

    March 3, 2023 at 9:44 am

    #4156384

  • Reply To: How To Avoid MERGE in SQL Server

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

    God is real, unless declared integer.

    February 20, 2023 at 11:07 am

    #4151910

  • Reply To: Backup Directly to a GCS Bucket in SQL Server 2022

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

    God is real, unless declared integer.

    January 30, 2023 at 9:28 am

    #4143177

  • Reply To: The Multilingual Programmer

    • 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 3 years, 8 months ago by Thomas Franz.

    God is real, unless declared integer.

    December 27, 2022 at 12:04 pm

    #4130641

  • Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

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

    God is real, unless declared integer.

    September 20, 2022 at 2:37 pm

    #4089858

  • Reply To: Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1

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

    God is real, unless declared integer.

    September 15, 2022 at 1:35 pm

    #4088091

  • Reply To: Manage Your Business Rules in T-SQL Query

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

    God is real, unless declared integer.

    September 2, 2022 at 2:08 pm

    #4083310

  • Reply To: Data Compression Double Take

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

    God is real, unless declared integer.

    July 20, 2022 at 10:17 am

    #4065846

  • Reply To: Randomizing the Day Inside a Month Using T-SQL

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

    God is real, unless declared integer.

    June 24, 2022 at 3:57 pm

    #4054470

  • Reply To: Randomizing the Day Inside a Month Using T-SQL

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

    God is real, unless declared integer.

    June 24, 2022 at 3:39 pm

    #4054466

    • Viewing 15 posts - 61 through 75 (of 198 total)