More Changes for the Dimension Merge SCD?
A while back, I ran a contest to find a new name for the SCD component hosted on CodePlex. The results were the best "lemons into lemonade" situation I could...
2011-03-14
4 reads
A while back, I ran a contest to find a new name for the SCD component hosted on CodePlex. The results were the best "lemons into lemonade" situation I could...
2011-03-14
4 reads
A while back, I ran a contest to find a new name for the SCD component hosted on CodePlex. The results were the best "lemons into lemonade" situation I could...
2011-03-14
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over 300 attendees watching five tracks of local speakers...
2011-03-09
2 reads
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over...
2011-03-09
1,028 reads
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over 300 attendees watching five tracks of local speakers...
2011-03-09
Probably not the kind of change you're expecting. I've recently been contacted by the Kimball Group, and they've asked me...
2011-03-03
2,559 reads
Probably not the kind of change you're expecting. I've recently been contacted by the Kimball Group, and they've asked me...
2011-02-25
3,245 reads
When I first started down the business intelligence and data warehousing road, I needed to learn the foundations of dimensional...
2011-02-16
1,279 reads
There are a few times where you might want to perform a cross join/cartesian join/cartesian product operation in SSIS. One of...
2010-09-28
4,204 reads
This question just came up in the forums, and it highlights how difficult it can be to try to optimize...
2010-09-06
2,096 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers