The Clustered Index Debate

Tech*Ed Conference Session, 75 minutes
Written/Presented by Kimberly L. Tripp, SQLskills.com

On what type of column(s) should the clustered index be placed? What's really impacted by the column choice of the clustered index? Is having a clustered index really necessary? Is your strategy more proactive toward attaining better performance or are you always rebuilding tables and negatively impacting performance? Whether your system is 24x7x365 or a small system just trying to setup for future growth and long term performance this session is for you! In this session, we will cover the often overlooked impacts of poorly chosen clustered indexes, where/why clustered indexes help the most and how the type of table and the type/frequency of your queries affect your decisions.