Richard and Greg talk to Bill Graziano about performance tuning in SQL Server. Bill digs into using SQL Profiler to focus on where the problems lie. The discussion digs into the procedure cache and how you can optimize your queries for caching. He also talks about ClearTrace, a free tool he distributes to help understand trace data. Check it out at http://www.cleardata.biz.
