Home > IT Answers > SQL Server > Differences between SQL Server 2005 and SQL Server 2008 R2
ITKE
16,755 pts.
 Differences between SQL Server 2005 and SQL Server 2008 R2
SQL Server 2005, SQL Server 2005 and SQL Server 2008 R2, SQL Server 2008 R2
Can you explain the key differences between SQL 2005 and the latest 2008?

Software/Hardware used:
ASKED: May 3, 2010  10:09 PM
UPDATED: May 5, 2010  2:00 PM
RELATED QUESTIONS
Answer Wiki:
Moving from SQL Server 2005 to SQL Server 2008 provides you with: Resource Governor, Transparent Data Encryption, Enhanced BI Sync Framework, Data Compression/Backup Compression, Policy-Based Management, New Data Types (spatial, dates and time), new-highly scalable SSRS architecture (removal of IIS dependency). These are the key improvements for 2008 + the enhancements to R2 that I described earlier.
Last Wiki Answer Submitted:  May 3, 2010  10:10 pm  by  MicrosoftExpert   975 pts.
All Answer Wiki Contributors:  MicrosoftExpert   975 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

difference between 2005 & 2008? the answer is 3. :-)

Meandyou
 5,205 pts.
 

Difference between 2005 and 2008 R(evision) 2? The answer is 3.2

Petecee
 80 pts.