Data Warehouses

Learn about how those Foreign Keys can impact your performance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2026-03-04

3,595 reads

Combining Silver Tables into a Model – Data Engineering with Fabric

This next article in the series creates objects at the gold layer for consumption by combining tables from the silver layer of the lake house.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2024-05-15

3,804 reads

This is an interesting invitation this month. Jeff Ianucci is a new host, and...

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

The first version of my accounting assistant could not find a single purchase of...

Comments posted to this topic are about the item Pay for Performance, which is...

Hi I have this slow query that is pulling data from a linked server....

Comments posted to this topic are about the item Too Many Choices

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;