This article provides different SQL Server index rebuild scripts.
Script 1: Rebuild all indexes in a SQL Server database with specifying the Fill Factor:
--Rebuild all indexes in a database
--Note: You need to specify the fill factor
USE [DatabaseName]
GO
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 90)";
GO
Script 2: Rebuild specific index online
ALTER INDEX [IndexName] ON [TableName]
REBUILD WITH (ONLINE=ON);
GO
Script 3: Rebuild specific index offline (with default fill factor)
ALTER INDEX [IndexName] ON [TableName]
REBUILD WITH (ONLINE=OFF);
GO
Strengthen your SQL Server Administration Skills – Enroll to our Online Course!
Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!
(Lifetime Access/ Live Demos / Downloadable Resources and more!)
Artemakis Artemiou is a Senior SQL Server Architect, Author, a 9 Times Microsoft Data Platform MVP (2009-2018) and a Udemy Instructor. He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Moreover, Artemakis teaches on Udemy, you can check his courses here.
Views: 2,826
Online Course Offer | “SQL Server 2019: What’s New – New and Enhanced Features“
Learn about the exciting new features and enhancements in SQL Server 2019.
Many live demonstrations on Windows and Linux included!
Available on: Udemy (* also available in the Udemy for Business Collection)
This site uses cookies for personalized content and the best possible experience. By continuing to browse this site, you agree to this use. Find out more.