Apr 1st 2.45 pm, I will be presenting “Re-Indexing – The quest of ultimate automation” @ sqlsaturday, Orange County, if you are in the area I hope to see you…

location:
Golden West College, 15744 Goldenwest St,
Orange County, California, 92647, USA

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

download scripts and presentation from github

Session Evaluation

SQL Saturday Session Evaluation

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.