Indexing

Stabilize Index

  • Script

This sp is used to update index in a database.  This sp has got three optional varchar parameters.  First parameter will take the tablename. Second parameter will take the indexname.  Third parameter will take the fillfactor.  The following option we can execute the sp in a user database.1.    exec StabilizeIndexIt will update all index in […]

1 (1)

2003-10-29

274 reads

Find Duplicate Indexes - Episode 1 (The Early SQL Versions)

  • Script

The excellent script contributed by G.R. Preethiviraj Kulasingham (Preethi) Sri Lanka (contributed 2/20/03, modified 5/22/03) identifies duplicate indexes for the database on which the script is run.  It requires User Defined Functions, a feature restricted to SQL Server 2000.This version achieves similar results without using UDFs or creating any other permanent objects. It therefore works […]

4 (1)

2003-05-28

739 reads

DB Reindex all Databases

  • Script

This script reindexes all tables in all databases.  Execute the script with the desired fill factor and it will do the rest.  There is an option to exclude databases from the reindex. This makes it easy to reindex all newly created databases. Great for the Development environment when Developers are creating database all the time.

2003-03-23

1,471 reads

Blogs

ASF 029: Tomaz Kastrun interview

By

Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...

Schema Filtering in SQL Prompt

By

I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...

Information Measurement with SQL Server Part 4.8: The Intersection Family of Distances

By

By Steve Bolton …………Each group of distance measures surveyed in this segment of the...

Read the latest Blogs

Forums

SSRS SQL account to connect install

By Siten0308

Hello, I am installing SSRS, and I want to use SSRS for the credentials...

using the same logic across multiple servers/dbs

By jonathan.crawford

We have five different report servers, with 13 or so different databases, all with...

How to see the source SELECT statement of views?

By imani_technology

I don't have permissions to right click\design views or to script the views.  Is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers