SQLServerCentral.com Scripts tagged Data Warehousehttp://www.sqlservercentral.com/Scripts tagged Data Warehouse posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Date DimensionHere is a simple script that I use to create a Date Dimension table.http://www.sqlservercentral.com/scripts/Data+Warehouse/62844/2008/06/04http://www.sqlservercentral.com/scripts/Data+Warehouse/62844/How to insert and update from remote linked serverhttp://www.sqlservercentral.com/scripts/Replication/31977/2007/10/30http://www.sqlservercentral.com/scripts/Replication/31977/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/Send SMS from a triggerhttp://www.sqlservercentral.com/scripts/Miscellaneous/31899/2007/04/16http://www.sqlservercentral.com/scripts/Miscellaneous/31899/Chunk Transferhttp://www.sqlservercentral.com/scripts/Replication/31863/2007/08/13http://www.sqlservercentral.com/scripts/Replication/31863/How to Find Beginning and End of Weekhttp://www.sqlservercentral.com/scripts/Miscellaneous/31841/2007/08/06http://www.sqlservercentral.com/scripts/Miscellaneous/31841/Format Value To Currencyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31840/2006/01/10http://www.sqlservercentral.com/scripts/Miscellaneous/31840/MEDIAN sp for SQL 2000http://www.sqlservercentral.com/scripts/T-SQL+Aids/31826/2007/02/23http://www.sqlservercentral.com/scripts/T-SQL+Aids/31826/Stored Proc to List Columns for a Primary Keyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31794/2006/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/31794/relatively simple mode, median, mean http://www.sqlservercentral.com/scripts/Miscellaneous/31775/2006/08/17http://www.sqlservercentral.com/scripts/Miscellaneous/31775/Script to get total rows and space usedhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31774/2006/08/18http://www.sqlservercentral.com/scripts/T-SQL+Aids/31774/Function to return the SQL Version Numberhttp://www.sqlservercentral.com/scripts/Replication/31754/2006/08/08http://www.sqlservercentral.com/scripts/Replication/31754/Function to return the SQL Build Numberhttp://www.sqlservercentral.com/scripts/Replication/31753/2006/08/09http://www.sqlservercentral.com/scripts/Replication/31753/UDF: Estimating the size of a tablehttp://www.sqlservercentral.com/scripts/Data+Warehouse/31749/2006/06/21http://www.sqlservercentral.com/scripts/Data+Warehouse/31749/Pagination in stored procedurehttp://www.sqlservercentral.com/scripts/Data+Warehouse/31738/2006/05/31http://www.sqlservercentral.com/scripts/Data+Warehouse/31738/Display Person Initials http://www.sqlservercentral.com/scripts/Miscellaneous/31686/2006/05/15http://www.sqlservercentral.com/scripts/Miscellaneous/31686/Automate renaming columnshttp://www.sqlservercentral.com/scripts/Miscellaneous/31663/2006/04/12http://www.sqlservercentral.com/scripts/Miscellaneous/31663/Time Hour Dimensionhttp://www.sqlservercentral.com/scripts/Miscellaneous/31595/2005/10/13http://www.sqlservercentral.com/scripts/Miscellaneous/31595/Generate Add Foreign Keys statements for the tablehttp://www.sqlservercentral.com/scripts/Data+Warehouse/31548/2006/06/08http://www.sqlservercentral.com/scripts/Data+Warehouse/31548/Find Nth Max-Min Record - The Efficient Way!http://www.sqlservercentral.com/scripts/Miscellaneous/31538/2005/07/22http://www.sqlservercentral.com/scripts/Miscellaneous/31538/Source system pre-integration analysishttp://www.sqlservercentral.com/scripts/Data+Warehouse/31521/2005/06/07http://www.sqlservercentral.com/scripts/Data+Warehouse/31521/Handle Divide by Zero in SQL Reporting Services http://www.sqlservercentral.com/scripts/Data+Warehouse/31510/2006/07/28http://www.sqlservercentral.com/scripts/Data+Warehouse/31510/Drop foreign keys from a databasehttp://www.sqlservercentral.com/scripts/Data+Warehouse/31506/2005/06/22http://www.sqlservercentral.com/scripts/Data+Warehouse/31506/Analyze a Table Contentshttp://www.sqlservercentral.com/scripts/Miscellaneous/31462/2005/03/22http://www.sqlservercentral.com/scripts/Miscellaneous/31462/Table Function For Data Warehouse Time Dimensionhttp://www.sqlservercentral.com/scripts/Data+Warehouse/31453/2005/03/04http://www.sqlservercentral.com/scripts/Data+Warehouse/31453/Random Populate a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31296/2004/12/06http://www.sqlservercentral.com/scripts/Miscellaneous/31296/Drop all foreign keyshttp://www.sqlservercentral.com/scripts/Index+Management/31285/2004/11/30http://www.sqlservercentral.com/scripts/Index+Management/31285/Return a Subset of Data from a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31233/2004/11/01http://www.sqlservercentral.com/scripts/Miscellaneous/31233/Get Table Count without using COUNThttp://www.sqlservercentral.com/scripts/Miscellaneous/31040/2004/10/04http://www.sqlservercentral.com/scripts/Miscellaneous/31040/Proper Case the data in the Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/30981/2003/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/30981/