April 7, 2012 at 3:39 am
I am a newbie!!!!
CAN ANY ONE EXPLAIN EXACT DEFERENCES BETWEEN SQL 2005 ,2008 AND 2008R2
April 7, 2012 at 4:36 am
Hey Hi,
Main Difference is over 2000,2005,2008 is
1. XML integration
2. Exception Handling
3. CLR ( common language runtime) integration
4. Varchar(Max) data type
5. DDL Triggers
6. DataBase Mirroring
7. RowNumber function for paging
8. Table fragmentation
9. Full Text Search
10. Easy User Interface
11. Versions
12. Bulk Copy Update
13.PBM(SQL server 2008)
you can refer also
http://blog.discountasp.net/sql-server-2008-r2-vs-2005/
http://www.sqlservercentral.com/Forums/Topic459626-146-1.aspx
http://en.wikipedia.org/wiki/Microsoft_SQL_Server#SQL_Server_2005
SQL server DBA
April 7, 2012 at 5:24 am
Go to the source, Microsoft: Each release of SQL Server has a "What's New" page in the books online. Go to this location in the Books Online and you can pick different versions of SQL Server to see what you need.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply