A DBA’s role is critical, because a production environment has to run 24×7, hence maintenance, trouble shooting, and quick resolutions are the need of the hour. The first baby step into any performance tuning exercise in SQL Server involves creating, analyzing, and maintaining indexes.
Though we have learnt indexing concepts from our college days, indexing implementation inside SQL Server can vary. Understanding this behavior and designing our applications appropriately will make sure the application is performed to its highest potential.
Vinod Kumar and myself we often thought about this and realized that practical understanding of the indexes is very important. One can not master every single aspects of the index. However there are some minimum expertise one should gain if performance is one of the concern.
More on Indexes:
I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can. Here is the interview of Vinod Kumar by myself.
Reference: Pinal Dave (http://blog.sqlauthority.com)