Datawarehouse
- Home /
- Categories /
- Datawarehouse
A SQL script to automatically infer the data types of data that someone just dumped in your DB with no effort
Do you know the feeling when someone gives you a flat file to import, without any schema information?
Read MoreHow to lose hundreds of thousands of dollars by using functions in SQL Server
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 function call was made in the last century…
Read MoreRow Level Security Performance Implications
A conversation had me wondering about performance implications in SQL Server RLS feature, specifically on how to mitigate the performance impact;
Read MoreA script to automatically align columnstore indexes to enhance segment elimination (and hence performances)
Columstore indexes are a “new” neat data structure that I like, even if technically they’ve been around for years, only recently they’ve become usable by most customers.
Read MoreWhat's the best way to massively update a big table?
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.
Read More