FIX: Regression: Specific Inner Join Slower with Service Pack 1 Applied

A specific query involving an inner join with multiple search clauses and a HAVING clause has been found to run slower on SQL Server 7.0 after Service Pack 1 was installed.

The workaround in this case was to reduce the number of search clauses.

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:For more information, contact your primary support provider.

The specific scenario that was involved is too complex to include here.