Time to take a look at the performance of the queries I wrote when looking at the new TSQL clauses EXCEPT and INTERSECT in SQL Server 2005.
EXCEPT query performance
Lets start with query 3, the query that used EXCEPT and had the highest performance. Here’s the xml sqlplan, I’ve altered the original SQL slightly to [...]
SET STATISTICS IO ON is an option that shows, at the page level, the physical and logical IO that goes on for each statement in a batch. Its not the most detailed inspection of a the query performance but it gives a nice insight into whats going in when the query is executing. I’m going [...]
There are a myriad of statistics SET options in sql 2005 but it looks like the first one I looked at is the simplest and the possibly the oldest: STATISTICS TIME.
It does little more than show the cpu and total time required to both parse and compile the batch and to execute it. When performance [...]