SQLServerCentral - Scripts by Sean Smith

Unused Input Parameters

Identify all objects containing unused input parameters. Read more...

By Sean Smith 2012/12/19 | Source: SQLServerCentral.com | Category: unused

Rating:

|

Discuss |

Briefcase | 715 reads

String Search

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML. Read more...

By Sean Smith 2012/04/09 | Source: SQLServerCentral.com | Category: string

Rating:

|

Discuss |

Briefcase | 1,766 reads

Report to keep you abreast of various details of an instance, including: general properties, uptime, drive space, db size allocation, growth stats, backups, jobs, unused indexes, & more... Read more...

By Sean Smith 2010/06/17 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 6,596 reads

E-Mail Validator

This script includes a basic E-Mail Address Validation Routine. Read more...

By Sean Smith 2009/12/09 | Source: SQLServerCentral.com | Category: email

Rating:

|

Discuss |

Briefcase | 1,704 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures. Read more...

By Sean Smith 2011/08/25 | Source: SQLServerCentral.com | Category: sp_who

Rating:

|

Discuss |

Briefcase | 5,929 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria. Read more...

By Sean Smith 2010/07/21 | Source: SQLServerCentral.com | Category: date

Rating:

|

Discuss |

Briefcase | 5,178 reads

Monty Hall Paradox

Script to test outcome probabilities of the "Monty Hall Paradox". Read more...

By Sean Smith 2009/09/09 | Source: SQLServerCentral.com | Category: monty

Rating:

|

Discuss |

Briefcase | 1,067 reads

Object Search

Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions. Read more...

By Sean Smith 2011/10/19 | Source: SQLServerCentral.com | Category: object

Rating:

|

Discuss |

Briefcase | 2,466 reads

Case Cleanup Function

Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify). Read more...

By Sean Smith 2013/05/21 | Source: SQLServerCentral.com | Category: capitalize

Rating:

|

Discuss |

Briefcase | 190 reads