SQL Server 2008 Integration Services ships with the wonderful new Data Profiling Task. Much as the name implies, it profiles the data in a given table and returns a ton of useful information. The task ...

It gives you a variety of information about the long running query, including the most important factor -- duration. With SQL Server Profiler, you can filter the data capture, called a trace ...

here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have richer features (which you’ll pay for); but a SQL Server licence allows you to ...

A common SQL habit is ... statement in the query to set the column value, during the insert operation itself. This way, you handle both the initial insert and the modified data in a single pass.

You can then use the trace data as input to the Database Engine ... all you have to do is right-click and choose “Trace Query in SQL Server Profiler”. SQL Profiler is launched and a trace ...

It gives you a variety of information about the long running query, including the most important factor -- duration. With SQL Server Profiler, you can filter the data capture, called a trace ...