In sql server 2005,There is no option to compress backup files, but in sql server 2008,there you find it.
storing backup file takes 5 minutes without compression in sqlserver 2005,but it takes only 3 minutes in sql server 2008 for storing backup files with compression.
CPU is used to compress the data before it is written to disk,so less data is written to disk.
There are many new features, so it depends on what you need. If you store large files in SQL Server, migrated from Oracle and want to use date and time data types, need to encrypt your databases, etc you will definitely want to look at 2008. The nice thing is that it upgrading should be much easier from 2005 to 2008 than it was from 2000 to 2005.
Server 2008 also added CMS which is Central Management Server. It only works with Windows Authentication but it allows you to management multiple SQL Servers at once. If SQL Server systems are popping up like weeds it will appear in the CMS provided that they point to the CMS via SSMS. Its a really cool feature.
PBM Policy-Based Management is another added feature introduced with SQL Server 2008. PBM allows you to define and enforce policies for configuring and managing SQL Server across your enterprise. It goes hand-in-hand with CMS.
One of my favorite is that fact that Reporting Services no longer requires IIS as it makes direct calls to HTTP.SYS.
As Rajiv mentioned there are many improvements to performance, data handling, security, administration, etc...
there is not much difference... just higher version but still companies develop projects in 2005 only
SQL2008 has support for additional datatypes:
date
time
geospatial
timestamp with internal timezone
in additon it has geospatial functions so it can compute differences based on GPS co-ordinates
when we write select * from --- it ask to for table name (2008)
but 2005 does not ask.
storing backup file takes 5 minutes without compression in sqlserver 2005,but it takes only 3 minutes in sql server 2008 for storing backup files with compression.
CPU is used to compress the data before it is written to disk,so less data is written to disk.
There are many new features, so it depends on what you need. If you store large files in SQL Server, migrated from Oracle and want to use date and time data types, need to encrypt your databases, etc you will definitely want to look at 2008. The nice thing is that it upgrading should be much easier from 2005 to 2008 than it was from 2000 to 2005.
Server 2008 also added CMS which is Central Management Server. It only works with Windows Authentication but it allows you to management multiple SQL Servers at once. If SQL Server systems are popping up like weeds it will appear in the CMS provided that they point to the CMS via SSMS. Its a really cool feature.
PBM Policy-Based Management is another added feature introduced with SQL Server 2008. PBM allows you to define and enforce policies for configuring and managing SQL Server across your enterprise. It goes hand-in-hand with CMS.
One of my favorite is that fact that Reporting Services no longer requires IIS as it makes direct calls to HTTP.SYS.
As Rajiv mentioned there are many improvements to performance, data handling, security, administration, etc...
there is not much difference... just higher version but still companies develop projects in 2005 only
SQL2008 has support for additional datatypes:
date
time
geospatial
timestamp with internal timezone
in additon it has geospatial functions so it can compute differences based on GPS co-ordinates
when we write select * from --- it ask to for table name (2008)
but 2005 does not ask.
No comments:
Post a Comment