FIX: Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000

Consider the following scenario: • In Microsoft SQL Server 2000, you execute a single query, or you execute multiple concurrent queries. • Each query returns several levels of nested derived tables. • Each derived table contains aggregations.

Read More - Register for Free Membership