SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Scripts by Jesse McLain

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Discover Unique Columns

Tool to automatically query combinations of columns in your table to determine candidate for unique key.  Read more...
By Jesse McLain 2008/04/16 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 429 reads

Identify Large Tables

Reports on physical size of tables in your database to identify largest.  Read more...
By Jesse McLain 2008/03/13 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 753 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object  Read more...
By Jesse McLain 2008/02/26 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 791 reads

Trim Trailing Blanks in SQL Queries

Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.  Read more...
By Jesse McLain 2008/03/10 | Source: SQLServerCentral.com | Category: T-SQL Aids
Rating: |  Discuss |  Briefcase | 1,105 reads

Generate INSERT for table with IDENTITY column

Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.  Read more...
By Jesse McLain 2008/03/07 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 776 reads
   Items 1 to 5 of 5