<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
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
Data Warehousing
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(41)
Replication
(6)
DateTime
(2)
MERGE
(1)
Maintenance and Management
(29)
Index Management
(5)
Dimensions
(2)
SQL Server 2008
(1)
T-SQL Aids
(26)
Lock and Connection Management
(3)
Administration
(1)
T-SQL
(1)
SQLInsider Scripts
(12)
Mail
(3)
data
(1)
Warehouse
(1)
Backup / Restore
(6)
DataWarehouse
(2)
DBA
(1)
Search for
any
content tagged
Data Warehousing
Add a script
Items 1 to 20 of 63
Next 20 >>
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
2009/04/30
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2008
Rating:
|
Discuss
|
Briefcase
|
616 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
2009/03/12
|
Source:
SQLServerCentral.com
|
Category:
Data Warehousing
Rating:
|
Discuss
|
Briefcase
|
1,547 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,118 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
2009/02/13
|
Source:
SQLServerCentral.com
|
Category:
Data Warehousing
Rating:
|
Discuss
|
Briefcase
|
5,787 reads
Date Dimension
Here is a simple script that I use to create a Date Dimension table.
Read more...
By
Satish Jayanthi
2008/06/04
|
Source:
SQLServerCentral.com
|
Category:
Data Warehousing
Rating:
|
Discuss
|
Briefcase
|
2,033 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,200 reads
Function to Split a Delimited String into a Table
Read more...
By
Andy Brown
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,334 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
13,346 reads
Chunk Transfer
Read more...
By
Richard S. Hale
2007/08/13
|
Category:
Replication
Rating:
|
Discuss
|
Briefcase
|
588 reads
How to Find Beginning and End of Week
Read more...
By
Al Siks
2007/08/06
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
866 reads
Format Value To Currency
Read more...
By
Al Siks
2006/01/10
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
623 reads
MEDIAN sp for SQL 2000
Read more...
By
Lukas Botha
0001/01/01
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
496 reads
Stored Proc to List Columns for a Primary Key
Read more...
By
Charles Hawkins
2006/09/14
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
605 reads
relatively simple mode, median, mean
Read more...
By
Oblio Leitch
2006/08/17
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
679 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
|
923 reads
Function to return the SQL Version Number
Read more...
By
Andy Brown
0001/01/01
|
Category:
Replication
Rating:
|
Discuss
|
Briefcase
|
1,042 reads
Function to return the SQL Build Number
Read more...
By
Andy Brown
0001/01/01
|
Category:
Replication
Rating:
|
Discuss
|
Briefcase
|
808 reads
UDF: Estimating the size of a table
Read more...
By
Jason-279543
2006/06/21
|
Category:
Data Warehousing
Rating:
|
Discuss
|
Briefcase
|
372 reads
Pagination in stored procedure
Read more...
By
Chris Smith-266894
2006/05/31
|
Category:
Data Warehousing
Rating:
|
Discuss
|
Briefcase
|
957 reads
Display Person Initials
Read more...
By
Sean Robert Ceton Cooperman
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
388 reads
Items 1 to 20 of 63
Next 20 >>
Most popular
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
2009/02/13
|
Source:
SQLServerCentral.com
|
Category:
Data Warehousing
Rating:
|
Discuss
|
Briefcase
|
5,787 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
2009/03/12
|
Source:
SQLServerCentral.com
|
Category:
Data Warehousing
Rating:
|
Discuss
|
Briefcase
|
1,547 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
13,346 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
