<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Scripts with tag
Data Warehousing
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
Function to Split a Delimited String into a Table
Read more...
By
Andy B.
2007/05/25
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
5,156 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
13,582 reads
Chunk Transfer
Read more...
By
Richard S. Hale
2007/08/13
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
746 reads
How to Find Beginning and End of Week
Read more...
By
Al Siks
2007/08/06
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,084 reads
Format Value To Currency
Read more...
By
Al Siks
2006/01/10
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
781 reads
MEDIAN sp for SQL 2000
Read more...
By
Lukas Botha
2007/02/23
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
617 reads
Stored Proc to List Columns for a Primary Key
Read more...
By
Charles Hawkins
2006/09/14
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
634 reads
relatively simple mode, median, mean
Read more...
By
Oblio Leitch
2006/08/17
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
877 reads
Script to get total rows and space used
Read more...
By
Felix Garcia Cruz
2006/08/18
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,054 reads
Function to return the SQL Version Number
Read more...
By
Andy B.
2006/08/08
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
1,189 reads
Items 1 to 20 of 67
Next 20 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
