Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Jesse McLain

SQLServerCentral.com profile

   Items 1 to 12 of 12   
 

Insert Commas Into Number String

Function to take a number as a string and return it with commas separating thousands, millions, etc.  Read more...
By Jesse McLain 2013/06/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,257 reads

Comparing Stored Procedures, Part 6

Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures  Read more...
By Jesse McLain 2009/04/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,341 reads

Comparing Stored Procedures, Part 5

Fifth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures   Read more...
By Jesse McLain 2009/04/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,112 reads

Performance Testing Script

Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures  Read more...
By Jesse McLain 2013/10/31 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,704 reads

Comparing Stored Procedures, Part 3

Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures   Read more...
By Jesse McLain 2011/03/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,184 reads

Comparing Stored Procedures, Part 2

Second in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures  Read more...
By Jesse McLain 2011/03/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,152 reads

Comparing Stored Procedures, Part 1

Provides quantifiable comparison of two stored procedures  Read more...
By Jesse McLain 2011/03/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,011 reads

Identify Unique Columns

Tool to automatically query combinations of columns in your table to determine candidate for unique key.  Read more...
By Jesse McLain 2012/08/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,802 reads

Identify Large Tables

Reports on physical size of tables in your database to identify largest.  Read more...
By Jesse McLain 2012/03/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,144 reads

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.  Read more...
By Jesse McLain 2011/09/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,148 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
Rating: |  Discuss |   Briefcase | 1,992 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 2012/03/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,708 reads
   Items 1 to 12 of 12