SQLTeam.com | Weblogs | Forums

Approaches for the slow query

tsql
sql2008r2

#1

This is an interview question.
How do you start working on a slowness of a query or a stored procedure?
What are the step by step processes you follow for that?
Is it better to use DBCC FREEPROCCACHE command to flush the cache and then debug on the slowness?
Please help on this. Thank You