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.
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.