SQLServerCentral - Scripts by Sean Smith

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,223 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,124 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,620 reads

usp_who5

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

By Sean Smith 0001/01/01 | Source: SQLServerCentral.com | Category: sp_who

Rating:

|

Discuss |

Briefcase | 5,745 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 0001/01/01 | Source: SQLServerCentral.com | Category: date

Rating:

|

Discuss |

Briefcase | 4,632 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,025 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 0001/01/01 | Source: SQLServerCentral.com | Category: object

Rating:

|

Discuss |

Briefcase | 2,353 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 | Source: SQLServerCentral.com | Category: capitalize

Rating:

|

Discuss |

Briefcase | 171 reads