Home » Tutorials » SQL SERVER » Performance Improvement in SQL » Rebuild and Reorganize Indexing Sql Server Scripts

Rebuild and Reorganize Indexing Sql Server Scripts

Attach Console with WPF application
Get all installed fonts in your computer using C#

Rebuild and Reorganize Indexing Sql Server Scripts

Hello Folks, today I will explain regarding when and why we should Rebuild or Reorganize Index in Sql Server regularly.

There is a simple rule behind Rebuild and Reorganize indexes which is shown in MSDN as below:

 

Rebuild-Reorganize-Indexes-1

See as per MSDN when avg_fragmentation_in_percent’s value is in between 5 % to 30%, we have to do reorganize indexing, but when its more than 30% we should do Rebuild Index with (ONLINE = ON).

Below is the standard script for Rebuilding and Reorganizing Indexes:

You can also download Rebuild and Reorganize Indexing Sql Server Script.

About

Hello friends, My self Dhruv Sheth, I have more than 6 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Time limit is exhausted. Please reload CAPTCHA.




DISCLAIMER:
The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.