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.
For further reading do watch the below interview preparation videos and step by step video series.
