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.
I am a Microsoft MVP for ASP/ASP.NET and currently a CEO of a small
E-learning company in India. We are very much active in making training videos ,
writing books and corporate trainings. Do visit my site for
.NET, C# , design pattern , WCF , Silverlight
, LINQ , ASP.NET , ADO.NET , Sharepoint , UML , SQL Server training
and Interview questions and answers
Submit an article or tip
Post your Blog
