Are remote databases fragmented? Let's Defrag.

This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).

Useful when rebuilding indexes online.

Page split - 2

Speeding Up Database Access Part 3 - Fixing Missing Indexes

Learn how to add those indexes you need in part 3 of Matt Perdeck's 8 part series on improving data access. This is based on the book ASP.NET Site Performance Secrets.

Speeding up Data Access Part 1 - Missing Indexes

In the first part of this series, learn how to pinpoint missing indexes in your databases.

Reindex - Reorganize or Rebuild

In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.

Finding all Columns of an Index

This script helps to find all columns of an index on a table. Include columns covered (include)

SQL Server Index Maintenance Performance Tuning for Large Tables

This article describes a real-world example of performance tuning index maintenance for a large table of approximately 1 billion rows.

Heaps