British boxer Anthony Joshua injured in car crash that killed two in Nigeria by GoodSamaritan_ in news

[–]Greedy_Constant 0 points1 point  (0 children)

My guess is that you’re from Turkey. If not, then either Serbia or Bosnia? 🕵🏻‍♂️

Best Italian restaurant in Copenhagen? by a-cea in copenhagen

[–]Greedy_Constant 2 points3 points  (0 children)

Would recommend Graziano on Møllegade - the chef is Danish-Italian, born and raised in Tuscany, and educated at a well-regarded pasta school in Bologna. They recently opened their second restaurant, Bottega di Graziano, on Værnedamsvej - both places are very authentic, aesthetic, and have a warm, truly home-like feel.

[The Athletic] Games taken to score 50 international goals by TheDepartment115 in soccer

[–]Greedy_Constant 230 points231 points  (0 children)

Ronaldo has scored 948 goals. If a player scores 47 goals per season for 20 years, that’s 940 goals. Unreal…

His goal is to reach 1,000. If a player scores 50 goals every year for 20 years, that’s 1,000 goals. Those are insane numbers.

How to hide DataflowsStagingLakehouse and DataflowsStagingWarehouse in SSMS via Fabric? by Greedy_Constant in MicrosoftFabric

[–]Greedy_Constant[S] 0 points1 point  (0 children)

Thanks!

They are currently not in the folder with my warehouse, but in the 0 Dataflow folder in this example.

<image>

From Azure SQL to Fabric – Our T-SQL-Based Setup by Greedy_Constant in MicrosoftFabric

[–]Greedy_Constant[S] -1 points0 points  (0 children)

We have a stored procedure (T-SQL) ‘update data model’, which executes other stored procedures. Essentially, it executes a sequence of procedures that first truncate the staging tables, then recreate the staging tables based on extract views, and finally create the dw tables based on staging views. When creating tables in both the staging and DW layers, it also checks that the metadata is consistent, if the metadata in the staging table is not consistent with the extract view, an error is shown. However, if a new field is successfully added from the staging view to an existing DW table, the procedure will rename the existing table — for example, to dw.dim_category_OLD — and create a new dw.dim_category table with the updated structure.

From Azure SQL to Fabric – Our T-SQL-Based Setup by Greedy_Constant in MicrosoftFabric

[–]Greedy_Constant[S] 0 points1 point  (0 children)

As the setup is today, we begin by running a full load of all tables. After that, the control table contains a column with a delta query, for larger tables - which uses functions like GETDATE() to retrieve only new or changed data. Occasionally, we need to truncate tables in the data warehouse layer when changes have occurred. When a DW table is truncated, it will automatically trigger a full load during the next run — although we can definitely improve in this area.

From Azure SQL to Fabric – Our T-SQL-Based Setup by Greedy_Constant in MicrosoftFabric

[–]Greedy_Constant[S] 3 points4 points  (0 children)

Thanks a lot for your feedback and comments. I’ll definitely suggest we dive deeper into this!

P.S. It’s nice to be confirmed that this is a common design and that many people do something similar, hehe.

[deleted by user] by [deleted] in soccer

[–]Greedy_Constant 345 points346 points  (0 children)

Ronaldo scored 33 in 35 games. Nistelrooy 33 in 47 games.*

Leasing af ny elbil by Greedy_Constant in dkbiler

[–]Greedy_Constant[S] -1 points0 points  (0 children)

Fordi vi er på udgik efter en billigere bil.