Many times, developers think hard on which columns to create clustered indexes and non-clustered indexes. Below is a quick video tip which will help you get index suggestions using profiler and tuning advisor.http://youtu.be/AaPaIVI-yyI?hd=1
It's a 3 step process:
- Get your load file using the SQL server profiler.
- Pass this load file to the tuning advisor.
- Finally implement the suggestion given by tuning advisor using your own thought process.
Do watch the above video for full practical details.