I was reviewing my index rebuild and recreate activities. Some index rebuilding tasks are scheduled once or twice a week. I followed the best practices for the activities. However, it was not yielding expected performance gain. So, wondering what could be going wrong! Are there any hidden issues hindering the performance? I kept searching for potential clues in my favourite SQL Server gurus writing and compiled the hidden facts. Let's share my findings with you.
[More]