Thomas Franz

Forum Replies Created

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

Reply To: What is OneLake in Microsoft Fabric?
Nice advertising article, but I (as SQL but no BI guy) have still absolute no idea, what it is for and how I could use it (or for what).
Can I...
- This reply was modified 3 years, 1 months ago by Thomas Franz.
God is real, unless declared integer.
July 27, 2023 at 2:48 pm

#4246041
Reply To: Get the Most Current Row From a Detail Table

I agree, that it could be a valid solution too (depending on your real workload).
But you should change your query a bit to make it faster (place alias of the...
God is real, unless declared integer.

July 12, 2023 at 11:47 am

#4233175
Reply To: Get the Most Current Row From a Detail Table

this may work for a customer + the last order but there are tons of other scenarios where the updates comes much more often or it is not worth the...
God is real, unless declared integer.

July 12, 2023 at 7:35 am

#4233030
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, 4 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...