How would you use a SQL profiler to optimize the database?
Anonymous
Look for bottlenecks and opportunities to index data, use views, or other things based on the trace. (From this question, I'm not sure the delineation between DBA and Software Dev when it comes to performance tuning.)
Check out your Company Bowl for anonymous work chats.