FIX: Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column

After you upgrade to Microsoft SQL Server 2000 from SQL Server 7.0, query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column. For example, a query that is similar to the following may perform slower after you upgrade to SQL Server 2000:

Read More - Register for Free Membership