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

Scripts by Sean Smith

SQLServerCentral.com profile

   Items 1 to 11 of 11   
 

SQL Battleship

It's you versus the computer in the classic game of Battleship, completely playable from the SQL Server Management Studio interface!  Read more...
By Sean Smith 2014/05/26 | Source: SQLServerCentral.com | Category: ai
Rating: |  Discuss |   Briefcase | 1,810 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/04/11 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 2,591 reads

Unused Input Parameters

Identify all objects containing unused input parameters.  Read more...
By Sean Smith 2014/02/26 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 1,564 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 2013/11/28 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 3,068 reads

SQL Server System Report

Report to keep you abreast of various details of an instance, including: general properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more...  Read more...
By Sean Smith 2013/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,934 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,798 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,859 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 2014/06/13 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 8,041 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,141 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2014/06/20 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 3,879 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 2008/08/14 | Source: SQLServerCentral.com | Category: capitalize
Rating: |  Discuss |   Briefcase | 255 reads
   Items 1 to 11 of 11