Consequences to setting the db compatibility level to SQL Server 2000
in [Programming SQL]
|
Prev: DataSet Tables to SQL Server database
Next: How to create SQL logins in FIPS compliant environment ?
From: Uri Dimant on 28 Jan 2010 04:14 Frank No, it does not relate to performance, it does to the new features such as ROW_NUMBER() function that won't work "Frank Rizzo" <none(a)none.net> wrote in message news:O7CsZS8nKHA.4648(a)TK2MSFTNGP06.phx.gbl... > We have a Sql Server 2005 DB. For whatever reason, the compatibility level > (e.g. via sp_dbcmptlevel) is set to 80 (which is Sql Server 2000). > > What are the consequences of that? Is there a performance penalty for my > apps because of the compatibility level? > > Regards
From: yssr83 on 28 Jan 2010 04:43
Hi Frank, Nops, there wont be any performance issue. But using the new features of SQL Server 2005 in your code and architecture will increase the performance of the database -- Sriram www.SQLLike.com |