SQLServerCentral - Scripts by Jesse McLain

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 2009/04/28 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,637 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,294 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,082 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 2011/03/11 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 7,100 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,049 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,097 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 | 6,843 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,713 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,089 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,084 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,938 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,526 reads