Re-Indexing - The quest of ultimate automation

Share on:

On 27th Sep 03.15 PM EST, I will be speaking on “Re-Indexing - The quest of ultimate automation”@ SQLSaturday, Orlando, If you are in the area I hope to see you!!

PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Whether you’re attending a SQLSaturday or thinking about hosting your own, I think you’ll find it’s a great way to spend a Saturday - or any day.

Event Schedule

Session details

Register here

You will learn a dynamic index optimization process which…

  1. Do selective re-indexing
  2. Handles blocking efficiently
  3. Avoid system downtime due to log disk full
  4. Automatically stop itself beyond a threshold
  5. Can be implemented across all sql servers regardless of application type or data size

In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems."