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

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 67    Older >>
 

Table-Column Data Profiler

Profile all of a table's columns using Transact-SQL.  Read more...
By Todd Owens 2014/01/28 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 2,051 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 2014/02/12 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 3,594 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 | 708 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,697 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,355 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 | 4,235 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,572 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 2013/10/04 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 22,875 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,722 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,543 reads
   Items 1 to 20 of 67    Older >>