SQLServerCentral.com Scripts tagged T-SQL Aidshttp://www.sqlservercentral.com/Scripts tagged T-SQL Aids posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Proc to Rename a fileA simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.http://www.sqlservercentral.com/scripts/Miscellaneous/63094/2008/05/13http://www.sqlservercentral.com/scripts/Miscellaneous/63094/DBCC Reindex with Statistics Information and table name optionalReindex all tables, showing statistics before and after reindexing, table name optional.http://www.sqlservercentral.com/scripts/T-SQL+Aids/62106/2008/03/25http://www.sqlservercentral.com/scripts/T-SQL+Aids/62106/Trim Trailing Blanks in SQL QueriesReformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.http://www.sqlservercentral.com/scripts/T-SQL+Aids/61896/2008/03/10http://www.sqlservercentral.com/scripts/T-SQL+Aids/61896/Restore database with all necessary filesIt creates the script for restoring your database with all the backups (full, differential and transaction log) needed.http://www.sqlservercentral.com/scripts/Restore/61810/2008/02/12http://www.sqlservercentral.com/scripts/Restore/61810/Effectively mapping primary key – foreign key relationsThis script maps the primary key - foreign key relations regardless if the column names are the same or not.http://www.sqlservercentral.com/scripts/Miscellaneous/61481/2008/01/10http://www.sqlservercentral.com/scripts/Miscellaneous/61481/Check Instance InfoNamed or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.http://www.sqlservercentral.com/scripts/SQL+Server+2000/61297/2007/12/19http://www.sqlservercentral.com/scripts/SQL+Server+2000/61297/Get Splitted Value From the String Format Specifiehttp://www.sqlservercentral.com/scripts/T-SQL+Aids/32010/2007/09/21http://www.sqlservercentral.com/scripts/T-SQL+Aids/32010/Combine multiple rows into single outputhttp://www.sqlservercentral.com/scripts/Miscellaneous/32004/2007/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/32004/Restore 2000 DB to 2005http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/32003/2007/09/14http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/32003/LSTR() and RSTR(): Enhanced LEFT() and RIGHT()http://www.sqlservercentral.com/scripts/Miscellaneous/32002/2007/09/13http://www.sqlservercentral.com/scripts/Miscellaneous/32002/This SP will be create C# classes using all table http://www.sqlservercentral.com/scripts/Miscellaneous/31997/2007/11/13http://www.sqlservercentral.com/scripts/Miscellaneous/31997/create log tables and trigger modyfiedhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31996/2007/11/14http://www.sqlservercentral.com/scripts/T-SQL+Aids/31996/Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/Display disk space stats for each tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31988/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31988/Get Record Count for each table in a database.http://www.sqlservercentral.com/scripts/Miscellaneous/31987/2007/08/21http://www.sqlservercentral.com/scripts/Miscellaneous/31987/Table row count using 3 different wayshttp://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/Locate primary key - foreign key relationshttp://www.sqlservercentral.com/scripts/Miscellaneous/31983/2007/11/07http://www.sqlservercentral.com/scripts/Miscellaneous/31983/SSRS Multi-Select http://www.sqlservercentral.com/scripts/T-SQL+Aids/31981/2007/08/13http://www.sqlservercentral.com/scripts/T-SQL+Aids/31981/Create Log tables and Triggershttp://www.sqlservercentral.com/scripts/Miscellaneous/31979/2007/10/26http://www.sqlservercentral.com/scripts/Miscellaneous/31979/Function to Split Multivalued Parameterhttp://www.sqlservercentral.com/scripts/Miscellaneous/31971/2007/10/11http://www.sqlservercentral.com/scripts/Miscellaneous/31971/Row count of all tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/31965/2007/07/20http://www.sqlservercentral.com/scripts/Miscellaneous/31965/Find Column Name Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31964/2007/10/22http://www.sqlservercentral.com/scripts/Miscellaneous/31964/Find Column Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31963/2007/10/10http://www.sqlservercentral.com/scripts/Miscellaneous/31963/Delete Duplicate Records without using Cursorhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31962/2007/07/18http://www.sqlservercentral.com/scripts/T-SQL+Aids/31962/Performance problem in SQL Server 2005http://www.sqlservercentral.com/scripts/T-SQL+Aids/31960/2007/07/16http://www.sqlservercentral.com/scripts/T-SQL+Aids/31960/Script to simplify maintenance of syspropertieshttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31956/2007/07/04http://www.sqlservercentral.com/scripts/T-SQL+Aids/31956/Script to simplify maintenance of syspropertieshttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31955/2007/07/04http://www.sqlservercentral.com/scripts/T-SQL+Aids/31955/create an insert statement http://www.sqlservercentral.com/scripts/T-SQL+Aids/31948/2007/10/01http://www.sqlservercentral.com/scripts/T-SQL+Aids/31948/Extracting words with removal of punctuations http://www.sqlservercentral.com/scripts/T-SQL+Aids/31942/2007/09/26http://www.sqlservercentral.com/scripts/T-SQL+Aids/31942/_Select Updatehttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31936/2007/09/18http://www.sqlservercentral.com/scripts/T-SQL+Aids/31936/