Is it worth to change my SQL Server compatibility level?
Posted on 2012-09-20
Before few months I upgrade my database from SQL 2005 to SQL 2008. I do this with deattach in SQL 2005 and attach in SQL 2008 R2. But just now I notice that compatibility level of my new DB 2008 is set to SQL 2005 /90/ . What are exactly real effects? I understand that this applies new T-SQL features, well actually I do not need them, but I’m interesting with speed improvements, reliability and etc.
I’m also the developer of all system, so I can change the level to 2008 and test everything, but I wonder is it worth? Please share your experience, I’m almost sorry that I do upgrade to SQL 2008 … it require Net 3.5 - HUGE installations on XP /still there many computers with XP/ and almost no additional benefits ...