SQLServerCentral.com Content tagged T-SQL, Indexing

Clustered Index

Tue, 05 Mar 2013 07:00:00 UT

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.

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

Altering a Column

Wed, 25 Apr 2012 06:00:00 UT

Tips to optimize your SQL statements

Fri, 10 Feb 2012 07:00:00 UT

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.

Script foreign keys

Tue, 10 Jan 2012 07:00:00 UT

Using this script you can create a list of sql commands for foreign keys manipulation.

Index Fragmentation

Fri, 21 Oct 2011 06:00:00 UT

This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.

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

Get all user def table info

Mon, 06 Jun 2011 06:00:00 UT

Get space for all user defined table information like size and row counts.

Stored procedure to script tables, has many options

Tue, 01 Feb 2011 07:00:00 UT

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.

Index Fragmentation Status (includes Partitioned Tables/Indexes)

Thu, 16 Dec 2010 07:00:00 UT

This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.

Creating indexes on computed columns

Thu, 30 Sep 2010 06:00:00 UT

Tips to optimize your SQL statements

Fri, 10 Feb 2012 07:00:00 UT

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.

Clustered indexes

Thu, 06 May 2010 06:00:00 UT

Index Fragmentation Status (includes Partitioned Tables/Indexes)

Thu, 16 Dec 2010 07:00:00 UT

This script reveals the state of your indexes. It breaks down the indexes where they are partitioned, matching the index to it’s partition and filegroup.

12 essential tools for database professionals
The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Data searches that leverage existing indexes

Thu, 07 Jan 2010 07:00:00 UT

Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on data searches, which leverage existing indexes, taking into account such features as noise words and thesaurus files.

An Un-indexed Foreign Key Gotcha

Mon, 09 Nov 2009 07:00:00 UT

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.

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.

Unique constraints

Wed, 29 Jul 2009 06:00:00 UT

view, index and schemabinding!

Mon, 29 Jun 2009 06:00:00 UT

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

SQL 2008 Indexes

Tue, 03 Feb 2009 07:00:00 UT

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

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.

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.

XML Index

Fri, 19 Sep 2008 06:00:00 UT

Checking XML indexs with a sample.

Index Fragmentation

Fri, 21 Oct 2011 06:00:00 UT

This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.