As a database administrator or developer, you'll get into trouble fast if you try to force all your code and processes into a database shaped hole. You have to be creative when you problem solve -- and when you communicate! So how do you cultivate creativity?
The bigger your indexes are, the harder your index maintenance falls. Is it better to rebuild big indexes? Or should you reorganize? Learn the pros and cons of each command and other options.
Should you look at automatically created statistics on your tables in SQL Server to help you design better indexes?