by Ian Bachman-Sanders | Jul 22, 2026 | Tips, Uncategorized
Last issue did a comparison of two implementations of the Rot13 algorithm. As part of the experimental design the data that they worked with was pinned into memory with the DBCC PINTABLE command. Once the table was pinned and the contents forced into memory by a...
by nsadmin | Aug 13, 2014 | Tips
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...
