Data Warehousing Tip: Using T-SQL vs SSIS for Slowly Changing Dimension (SCD) Types 1 and 2
Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform...
2013-09-11
1,030 reads
Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform...
2013-09-11
1,030 reads
Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform ,however, it does not process large dimensional datasets...
2013-09-11
7 reads
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle...
2013-09-11
700 reads
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle Poolet summarizes it beautifully – “consider the data warehouse...
2013-09-11
This post contains the following queries that support development and operational tasks within a Microsoft Parallel Data Warehousing (PDW) Appliance...
2013-04-20
6,090 reads
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to...
2013-04-12
912 reads
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to do a table based surrogate key assignment or use...
2013-04-12
Rather than making individual time calculations for each measure in an SSAS cube (i.e. YTD, Prior YTD, YTD Variances, etc), one can...
2013-02-07
1,871 reads
Rather than making individual time calculations for each measure in an SSAS cube (i.e. YTD, Prior YTD, YTD Variances, etc), one can use a more dynamic approach to time calcs applicable to all...
2013-02-07
8 reads
SSRS Tip: Simplest Method to Pass MDX Multi-Select Parameters to MDX Datasets
I recently ran across a poorly covered topic in regards...
2013-02-07
3,220 reads
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Brian Kelley
Through high school and college, I carried deep wounds due to what was going...
Hi all, I have a table where I have 3 indexes (User Table): id_user...
I need to configure the below alerts manually for multiple servers Backup failure, disk...
Hi, I have a table of sites where the there are multiple site names...