Do you know the feeling when someone gives you a flat file to import, without any schema information? You have to dump it in your database as-is, then spend …
Data Warehousing
- Home /
- Categories /
- Data warehousing
Notes from years of building and tuning data warehouses on SQL Server. Big tables, columnstore indexes and the scripts I wrote so I’d never have to do the boring parts by hand again.
Ahh, functions, the greatest tool at a programmer’s disposal, they make code reusable and easy to read, they’ve been essential since the first …
A conversation had me wondering about performance implications in SQL Server RLS feature, specifically on how to mitigate the performance impact; TL; DR; ? …
Columstore indexes are a “new” neat data structure that I like, even if technically they’ve been around for years, only recently they’ve …
A thing that can happen once in a while in a DW is the need to massively update a column in a table, let’s find out. I’ll be using the same table as …