Raghavendra Mudugal (8/24/2012)
Good question, thank you Lokesh-ji.Initially I checked the cb-3 box where it stores the poor query details - considering the trace tables from the server-wide catalog tables, but later I unchecked it with doubt (After reading the cb3 several times and the type of information stored in the trace table, this was a lucky guess.)
Finally got it right. 🙂
(This QtoD is a great way of learning the SQL bits, one question at a time, thank you SSC)
Glad to know that you like it very much.
I personally feel that QotD is the best way to learn/refresh our knowledge 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter