Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Data Warehousing Rss

Search for any content tagged data warehousing

Add a script

   Items 1 to 20 of 67    Next 20 >>
 

Table-Column Data Profiler

Profile all of a table's columns using Transact-SQL.  Read more...
By Todd Owens 2013/01/25 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 885 reads

Kimball ETL (subsystem 1) – Data Profiling via TSQL

This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)  Read more...
By Ira Whiteside 2012/06/11 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 2,169 reads

Populate partition

Fill a specified partition of a table with a specific query, working on staging table   Read more...
By Federico Iori 2010/03/25 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 676 reads

Rebuild partition

Rebuilds online a table partition with all indexes   Read more...
By Federico Iori 2010/03/12 | Source: SQLServerCentral.com | Category: rebuild
Rating: |  Discuss |   Briefcase | 1,563 reads

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...
By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,149 reads

Functions for using the keys from the Date and Time Dimensions

Three functions for obtaining the date and time dimension keys with a date or the date from the keys  Read more...
By Joshua A. Walker 2011/05/03 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 3,796 reads

Function to Add Leading 0's (Zeros) to an INT

Very simple function code to add leading zeros to a passed in int for a length also passed.  Read more...
By Joshua A. Walker 2009/03/05 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,540 reads

Date and Time dimension creation and population T-SQL

Dim_Date and Dim_Time. Date and Time dimensions. Creation, population with holidays, indexing and use script.  Read more...
By Joshua A. Walker 2011/03/08 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 19,974 reads

Date Dimension

Here is a simple script that I use to create a Date Dimension table.  Read more...
By Satish Jayanthi 2012/01/11 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 4,388 reads

How to insert and update from remote linked server

Please read the how to use. unfortunately the orignal document i submitted was truncated :( and i dont have time to remember what i said  Read more...
By Chris Morton 2007/10/30 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,512 reads
   Items 1 to 20 of 67    Next 20 >>