SQL 2000 vs 2005 vs 2008
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Guys, A quick question for those more knowledgable about Sql Server than I. I am using SQL 2000 as the DB in my applications. By and large it consists of a bunch of tables, stored procs to read/write data and a little SQL processing of data. Some apps do move large chunks of data around and as there are lots of arrays to rebuild it can take a while. I have been wondering about the pros and cons of upgrading to 2005 or even 2008. Would I get an appreciable gain in speed in reading/writing? So, looking for thoughts on the pros and cons of upgrading. Many thanks, John.