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/10/17 | Source: SQLServerCentral.com | Category: ai
Rating: |  Discuss |   Briefcase | 3,393 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,674 reads

Unused Input Parameters

Identify all objects containing unused input parameters.  Read more...
By Sean Smith 2014/10/09 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 2,256 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 2014/10/22 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 4,116 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: 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 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,636 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,816 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,916 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/10/03 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 9,147 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,147 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,947 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 | 262 reads
   Items 1 to 11 of 11