Sometimes back we remember having used one feature within SSMS whereby after running a query, we can right click and get an option that recommends what index need to built for the query to perform faster. But as far as we can recall it is
not 'Analyze query in database engine tuning adviser'. We are unable to recall what option was enabled or used. Can some help in finding that option. Thank you.
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
View Complete Post