May 29, 2009 at 7:56 pm
DB from 2000 to 2005 it was recommended to change compatibility to 90 and then do full rebuild of the indexes and update all the statistics.
What is the recommendation for 2005 db to 2008.
February 6, 2013 at 1:42 pm
It depends on whats coded in your database scripts, application etc.
If you set it to 90 then it will use features of SQL 2005 and if set to 100 then it will function as SQL 2008 or SQL 2008 R2 database.
with setting the db at 90 you wont be able to use SQL 2008 features.
So there is no standards here. Its just what features of 2008 you want to use.
Regards
Satyen
February 6, 2013 at 3:27 pm
menon.satyen (2/6/2013)
It depends on whats coded in your database scripts, application etc.If you set it to 90 then it will use features of SQL 2005 and if set to 100 then it will function as SQL 2008 or SQL 2008 R2 database.
with setting the db at 90 you wont be able to use SQL 2008 features.
So there is no standards here. Its just what features of 2008 you want to use.
Regards
Satyen
It isn't quite that cut and dry. For example I have a database in 2008r2 set in 2000 compatability mode. I can still use varchar(max) and cte. Those are not available in 2000. It is not like suddenly the database is a 2000 database. There are a number of features that you can still use.
Unfortunately your response did not really relate to the original question.
It would be recommended to rebuild your indexes and update statistics again if switching from 2005 to 2008.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply