SQLServerCentral.com Scripts tagged Utility

Generate Column Metadata

Tue, 12 Feb 2013 07:00:00 UT

This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Backup all Filegroups

Wed, 29 Jun 2011 06:00:00 UT

A short script to backup all filegroups, for those who utilise filegroups within a database.

Linked Server Connectivity Test

Tue, 28 Dec 2010 07:00:00 UT

A short procedure for your tools database. Use it to test connectivity to linked servers.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Column Size Checker

Thu, 30 Dec 2010 07:00:00 UT

A T-SQL script that reveals how appropriate your choice of column sizes is.

View Errors in the Default Trace

Thu, 12 Nov 2009 07:00:00 UT

Returns records with errors from the default trace ordered by most recent first

The Ultimate Index-Less Foreign-Key Finder

Thu, 15 Oct 2009 06:00:00 UT

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.

The Ultimate Object Searcher

Tue, 06 Oct 2009 06:00:00 UT

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.

Find Missing Foreign Keys

Mon, 24 Aug 2009 06:00:00 UT

Find missing foreign keys in your database schema based on naming conventions.

BCP Format File Builder

Fri, 14 Aug 2009 06:00:00 UT

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.

Three Sample reports for the Automated DBA: Space Usage SnapShotter

Mon, 13 Jul 2009 06:00:00 UT

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

Fri, 19 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver

Mon, 22 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL 2000 Version

Thu, 25 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL 2005 Version

Tue, 23 Jun 2009 06:00:00 UT

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

The Automated DBA: Space Usage Snapshotter Lite (non-sysadmin dbo)

Mon, 15 Jun 2009 06:00:00 UT

Records snapshots of space usage stats by partition, index, table, schema, filegroup, and database. Stats include Reserved, Used, and Data for row, lob, and overflow.

The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)

Wed, 17 Jun 2009 06:00:00 UT

Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.

The Ultimate Dupe Finder & Performance Test Parameter Set Researcher

Fri, 29 May 2009 06:00:00 UT

Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!

The Ultimate Running Requests Reporter

Mon, 24 May 2010 06:00:00 UT

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.

The Ultimate Index Width Stats Reporter

Wed, 28 Jan 2009 07:00:00 UT

Reports index length stats for indexes who's lengths exceeding parametrized thresholds (defaults to 0 - get all) for total length and seek length, optionally filtering schemas and tables.

The Ultimate PK-Less / CLIDX-Less Table Finder

Fri, 02 Oct 2009 06:00:00 UT

Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

The Ultimate Table Searcher Mk2

Tue, 20 Oct 2009 06:00:00 UT

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.

The Ultimate Connection Summarizer and Trouble Finder

Thu, 22 Oct 2009 06:00:00 UT

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.

The Ultimate Missing Index Finder

Mon, 07 Jan 2013 07:00:00 UT

Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.

The Ultimate Prospective-Index Column(s) Selectivity Analyzer

Fri, 24 Oct 2008 06:00:00 UT

Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.

The Ultimate Duplicate Index Finder

Fri, 17 Oct 2008 06:00:00 UT

Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.

The Ultimate Index Usage Reporter

Thu, 27 Dec 2012 07:00:00 UT

Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.

The Ultimate Index Lister (Non-Pivoted)

Tue, 07 Oct 2008 06:00:00 UT

Lists details for all indexes on one or more tables / schemas, including row count and size. The non-pivot version also gives data type and other details for the columns.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

The Ultimate Index Lister (Pivoted)

Thu, 09 Oct 2008 06:00:00 UT

Lists details for all indexes on one or more tables / schemas, including row count and size. This version outputs the member seek + include columns as two comma separated output columns.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

The Ultimate Table Searcher

Wed, 14 Oct 2009 06:00:00 UT

Searches for tables who's names contain the search string. Gives Size and Rows information as well.

The Ultimate Column Searcher

Fri, 16 Oct 2009 06:00:00 UT

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.