SQLServerCentral.com Content tagged T-SQL, Utility

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 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.

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.

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.

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.

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.

‘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 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.

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

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.

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.

‘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 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.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

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 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.

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

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.

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 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 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.

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.

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 - 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.

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 - 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: 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 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 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.

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.

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