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,040 reads
Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence
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 ,however, it does not process large dimensional datasets...
2013-09-11
9 reads
Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle...
2013-09-11
704 reads
Data Warehousing Tip: T-SQL Script to Create DEFAULT Constraints by Data Type
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
2 reads
Parallel Data Warehouse (PDW) Tip: Useful Appliance Queries
This post contains the following queries that support development and operational tasks within a Microsoft Parallel Data Warehousing (PDW) Appliance...
2013-04-20
6,240 reads
Data Warehousing Tip: Surrogate Key Generation
If IDENTITY insert is disabled or simply not available in a particular database or a database architecture, you’ll want to...
2013-04-12
915 reads
Data Warehousing Tip: Surrogate Key Generation
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
2 reads
SSAS How-To: Create Dynamic Time Calculations To Reuse Over Any Measure
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,874 reads
SSAS How-To: Create Dynamic Time Calculations To Reuse Over Any Measure
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
10 reads
SSRS How-To: Simple Method to Pass MDX Multi-Select Parameters to MDX Datasets
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,222 reads
Blogs
Data Modeling at your fingertips
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
Daily Coping 30 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Migrate SQL Sever 2012 Database To Server 2014 and Subsequent Versions
Hi Guys, I have an SQL Server 2012 Express database that I would like...
Deploying SQL Server Automatically
Comments posted to this topic are about the item Deploying SQL Server Automatically
Setting data compression on a database or even server level possible?
I well realize data compression is a subject to a few variables, such as...
Ask SSC