I am having big performance problems afters applying SP3 for SQL Server 2000 Enterprise Edition.
We have a large query generated by Crystal Reports involving about 20 tables and views with joins and outer joins.
The largest table have 100000 rows and is 20 Mb large.
If I run this query on SQL server without service pack, it takes less than 1 second, with SP3 it takes more than 2 minutes!
I found a workaround, copying all data selectes by the larger view into a table and using the table instead of the view in the query.
I looked at execution plans and it seems an optimizer bug of SP3.
Someone could help me, please?