Indexing

Technical Article

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)

You rated this post out of 5. Change rating

2003-10-29

278 reads

Technical Article

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)

You rated this post out of 5. Change rating

2003-05-28

759 reads

Technical Article

Unattended Reindexing of all user tables

  • Script

I see scripts all the time on how to reindex all the tables in a db but they are usually too generic and may cause issues.  For instance they typically cause the log file to grow very large and may even fill the hard drive.  This is intended to be run off hours when db […]

You rated this post out of 5. Change rating

2003-04-24

640 reads

Blogs

Learning Database Design and Power BI Performance

By

I spend my days working on and managing SQL Server instances—working days at least,...

Free SQL Training: Dive into Databases This December!

By

Want to learn SQL and get some real practice this December? Check out the...

Monday Monitor Tips: CIS Compliant

By

A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...

Read the latest Blogs

Forums

Testing whether TRY_CONVERT is losing precision

By Chrissy321

Hello All, I am using TRY_CONVERT to parse character data into a decimal column....

need help with assigning a value to a variable

By water490

Hi I am trying to assign the value of the  variable using the output...

Merry Christmas 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Merry Christmas 2025

Visit the forum

Question of the Day

The Reindeer Count

How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.

See possible answers