In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server.

Discover how to limit the size of the trace file in SQL Server Profiler and how to specify whether the file rolls over when it reaches maximum size. [!INCLUDE SQL Server] Use the following procedure ...

Find out how to limit the size of a trace table. Use SQL Server Profiler to specify the maximum number of rows the table can have. In the Trace name box, type a name for the trace. In the Template ...

SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our ...