Showing posts with label sql2005thanks. Show all posts
Showing posts with label sql2005thanks. Show all posts

Thursday, March 22, 2012

Difference between 2000 and 2005

Hello,
do you know defined performance differences between SQL 2000 and SQL
2005?
thanks in advance
I can't compare directly - there are loads of enhancements in the
architecture, some of which have no direct comparison eg a lot of what was
originally done in post snapshot scripts can now be done directly and merge
has unidirectional articles which aren't logged using triggers etc - also we
have different hardware between the installations.. For a quantitative
comparison where things are held constant as far as possible, have a look at
this article:
http://www.microsoft.com/technet/prodtechnol/sql/2005/mergrepl.mspx. If
applies to merge, but some of the snapshot details will equally apply to
transactional also.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .