SQL Clone
SQLServerCentral is supported by Redgate
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 2018/03/12 | Source: SQLServerCentral.com | Category: ai
Rating: |  Discuss |   Briefcase | 7,065 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 2015/12/31 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,779 reads

Unused Input Parameters

Identify all objects containing unused input parameters. 
By Sean Smith 2015/12/22 | Source: SQLServerCentral.com | Category: unused
Rating: |  Discuss |   Briefcase | 3,141 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 2015/12/24 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 5,812 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 2016/01/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,593 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,930 reads


Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2018/01/23 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 12,727 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 2018/04/26 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 11,425 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,226 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 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,878 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 | 305 reads
   Items 1 to 11 of 11