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 | 918 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,023 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 | 918 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 2009/03/26 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Discuss |

Briefcase | 4,262 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 2009/03/18 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Discuss |

Briefcase | 1,013 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 2009/03/10 | Source: SQLServerCentral.com | Category: T-SQL

Rating: (not yet rated) |

Discuss |

Briefcase | 1,082 reads

Comparing Stored Procedures, Part 1

Provides quantifiable comparison of two stored procedures Read more...

By Jesse McLain 2009/02/23 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Discuss |

Briefcase | 4,447 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 2008/04/16 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Discuss |

Briefcase | 796 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 | 1,402 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 | 1,293 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,385 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 | 1,345 reads