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,076 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,076 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
22 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
719 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
8 reads
This post contains the following queries that support development and operational tasks within a Microsoft Parallel Data Warehousing (PDW) Appliance...
2013-04-20
6,829 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
920 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
5 reads
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,888 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
78 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,233 reads
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Comments posted to this topic are about the item Create an HTML Report on...
While doing some housekeeping activity on several old but large production databases, I come...
How important to SQL Server is the speed of the SSD and network latency?...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers