SQLServerCentral.com Content tagged Data Warehouse, Maintenance and Managementhttp://www.sqlservercentral.com/Content tagged Data Warehouse, Maintenance and Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)How to insert and update from remote linked serverPlease read the how to use. unfortunately the orignal document i submitted was truncated :( and i dont have time to remember what i saidhttp://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/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/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/Stored Proc to List Columns for a Primary Keyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31794/2006/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/31794/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 Build Numberhttp://www.sqlservercentral.com/scripts/Replication/31753/2006/08/09http://www.sqlservercentral.com/scripts/Replication/31753/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/Function to return the SQL Version Numberhttp://www.sqlservercentral.com/scripts/Replication/31754/2006/08/08http://www.sqlservercentral.com/scripts/Replication/31754/UDF: Estimating the size of a tablehttp://www.sqlservercentral.com/scripts/Data+Warehouse/31749/2006/06/21http://www.sqlservercentral.com/scripts/Data+Warehouse/31749/Display Person Initials http://www.sqlservercentral.com/scripts/Miscellaneous/31686/2006/05/15http://www.sqlservercentral.com/scripts/Miscellaneous/31686/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/Format Value To Currencyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31840/2006/01/10http://www.sqlservercentral.com/scripts/Miscellaneous/31840/Analyze a Table Contentshttp://www.sqlservercentral.com/scripts/Miscellaneous/31462/2005/03/22http://www.sqlservercentral.com/scripts/Miscellaneous/31462/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/Count and display number of rows in all tableshttp://www.sqlservercentral.com/scripts/Data+Warehouse/30654/2003/01/02http://www.sqlservercentral.com/scripts/Data+Warehouse/30654/Drop Statisticshttp://www.sqlservercentral.com/scripts/Miscellaneous/30571/2002/11/01http://www.sqlservercentral.com/scripts/Miscellaneous/30571/Frequency of each field in tablehttp://www.sqlservercentral.com/scripts/Data+Warehouse/30501/2002/10/03http://www.sqlservercentral.com/scripts/Data+Warehouse/30501/Proc to Query MSDB..SYSJOBS and SYSJOBSTEPShttp://www.sqlservercentral.com/scripts/Miscellaneous/30367/2002/06/07http://www.sqlservercentral.com/scripts/Miscellaneous/30367/Proc to Query Syscomments and Sysobjectshttp://www.sqlservercentral.com/scripts/Miscellaneous/30366/2002/06/07http://www.sqlservercentral.com/scripts/Miscellaneous/30366/Get table sizes and rowcounts in MB (for VLDB)http://www.sqlservercentral.com/scripts/Data+Warehouse/30316/2002/05/03http://www.sqlservercentral.com/scripts/Data+Warehouse/30316/Disk usage for the databases and tempdb.http://www.sqlservercentral.com/scripts/Data+Warehouse/30298/2002/05/01http://www.sqlservercentral.com/scripts/Data+Warehouse/30298/DTS-Less and Jobless Approach to Table Freshnesshttp://www.sqlservercentral.com/scripts/Replication/30288/2002/04/23http://www.sqlservercentral.com/scripts/Replication/30288/Write Reports from SQL to Disk (Even HTML!)http://www.sqlservercentral.com/scripts/Miscellaneous/30277/2002/04/18http://www.sqlservercentral.com/scripts/Miscellaneous/30277/DATEMY - Covnerts and validates MM/YY, MM/YYYYhttp://www.sqlservercentral.com/scripts/Miscellaneous/30179/2002/02/15http://www.sqlservercentral.com/scripts/Miscellaneous/30179/Script to generate BCP Statements for a Databasehttp://www.sqlservercentral.com/scripts/Replication/30137/2002/01/07http://www.sqlservercentral.com/scripts/Replication/30137/