Hi All,
How to do performance tuning in SQL server other than profiler and index tuning wizard.
Suppose one SP is running very very slow and there are 5000+ line of code inside that SP. What will be my first approach to rectify issue. What steps should i follow to accomplish.