Using EXCEPT and INTERSECT to Validate SQL Server Query Tuning
By Jeffry Schwartz | Query Tuning , SQL Server
This article explains how the EXCEPT and INTERSECT T-SQL operators can help compare query results when tuning SQL Server queries, stored procedures, and views. Recently, a customer requested that I optimize several SSRS financial reports that frequently took between one and three minutes to complete. These reports were driven by complex code involving user-defined functions, […]
Continue reading