One of the more essential SQL Server tools is its trace utility. With it you can view the activity occurring against a SQL Server for diagnostic, informational, and other purposes. Because it lets you ...

First, the QA’s overall usability has been enhanced. It’s easier to use, partly because more information is now readily available. For example, you no longer need to query for the current connection’s ...

With best-in-class ease of use on the Windows platform, Microsoft SQL Server 2000 SP2 combines strong administration abilities with leading-edge XML support. Though it's still Windows-centric, ...

The analyzer can determine how many IOs each approach will take and choose the fastest way to do it.<BR><BR>Basically the estimated execution plan is mostly what the query optimizer does when it's ...