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
Scripts with tag
Data Warehousing
Search for
any
content tagged
data warehousing
Add a script
Items 1 to 20 of 65
Next 20 >>
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
|
604 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,234 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 2008
Rating:
|
Discuss
|
Briefcase
|
1,777 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
data warehousing
Rating:
|
Discuss
|
Briefcase
|
3,474 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,478 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
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
data warehousing
Rating:
|
Discuss
|
Briefcase
|
18,278 reads
Date Dimension
Here is a simple script that I use to create a Date Dimension table.
Read more...
By
Satish Jayanthi
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
data warehousing
Rating:
|
Discuss
|
Briefcase
|
3,863 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,456 reads
Function to Split a Delimited String into a Table
Read more...
By
Andy Brown
0001/01/01
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
4,843 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
13,457 reads
Chunk Transfer
Read more...
By
Richard S. Hale
2007/08/13
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
716 reads
How to Find Beginning and End of Week
Read more...
By
Al Siks
2007/08/06
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,059 reads
Format Value To Currency
Read more...
By
Al Siks
2006/01/10
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
757 reads
MEDIAN sp for SQL 2000
Read more...
By
Lukas Botha
0001/01/01
|
Category:
t-sql aids
Rating:
|
Discuss
|
Briefcase
|
606 reads
Stored Proc to List Columns for a Primary Key
Read more...
By
Charles Hawkins
2006/09/14
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
631 reads
relatively simple mode, median, mean
Read more...
By
Oblio Leitch
2006/08/17
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
852 reads
Script to get total rows and space used
Read more...
By
Felix Garcia Cruz
2006/08/18
|
Category:
t-sql aids
Rating:
|
Discuss
|
Briefcase
|
1,033 reads
Function to return the SQL Version Number
Read more...
By
Andy Brown
0001/01/01
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
1,170 reads
Function to return the SQL Build Number
Read more...
By
Andy Brown
0001/01/01
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
926 reads
UDF: Estimating the size of a table
Read more...
By
Jason-
2006/06/21
|
Category:
data warehousing
Rating:
|
Discuss
|
Briefcase
|
465 reads
Items 1 to 20 of 65
Next 20 >>
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.