Editor's Note: Send your SQL Server questions and comments to SQL Server MVP Brian Moran at savvy@sqlmag.com.

What are the advantages of saving SQL Profiler trace information to a table instead of to a text file and vice versa?

SQL Profiler's trace information is the same regardless of whether you store it in a table or a file. However, I find saving the trace data to a file more convenient than saving the data to a table. Although you can more easily access the tr...