开发者

SQL Server 2000 vs SQL Server 2008 Query Performance

开发者 https://www.devze.com 2022-12-12 06:18 出处：网络

I\'m working with a client who had a SQL Server 2008 converted from a SQL Server 2000 DB and one of the queries has quite dramatically increased in time since it was on SQ开发者_如何学JAVAL Server 200

相关专题：sql sql-server-2000 sql-server-2008

I'm working with a client who had a SQL Server 2008 converted from a SQL Server 2000 DB and one of the queries has quite dramatically increased in time since it was on SQ开发者_如何学JAVAL Server 2000.

However, if I change the compatibility level to 2008 in the DB, the query goes like a rocket (40-50 times faster).

The query does use a number of UDFs.

My questions: - are there issues with running SQL2000 compatibility in SQL Server 2008 - has SQL Server 2008 improved the performance when using UDFs?

There are some other things you might want to do after upgrading. See the "After upgrading..." section here: http://msdn.microsoft.com/en-us/library/bb933942.aspx