Whenever a performance tuning task involves changes to T-sql code, I aim to ensure that whilst the execution time of the query decreases significantly, the code still produces the same results. 538 more words
Tags » Intersect
Comparing Two Tables to Finding Missing Rows & Matching Rows
Find rows in one table that are missing from the other.
You can used MINUS operator to compare the two sets of data or Select queries and show data missing from one table. 214 more words