Loading SQL Profiler trace (.trc) files into a table

Problem:   How to load SQL Profiler trace (.trc) files into a table? Server traces can produce a large amount of trace data that is stored in multiple trace (.trc) files.  They can be loaded into a table by going through SQL Profiler (2005 or 2000) but that’s a...

The Biggest Loser – Database Edition

Fat! That’s how you’d have to describe most databases these days. Gigabytes piled on megabytes until the terabytes add up and up. In one way, we think of disk space as cheap. After all you can go down to the local office supply store or on-line and buy a terabyte...
Andy has a new web site: AndyNovick.com