What is architecture difference in SQL 2005 & SQL 2008 Database Engine

• shashi kant

  SSCommitted

  Points: 1659

  More actions

  April 7, 2010 at 6:42 pm

  #221001

  Hi All,

  can any one give me brief architecture difference of sqlserver 2005 and 2008 along with its new features.

  Thanks

  Shashi Kant Chauhan

• David Baffaleuf

  SSCrazy

  Points: 2159

  More actions

  April 8, 2010 at 1:07 am

  #1148056

  Hi,

  top of my head, what you should focus on:

  STORAGE:

  - page and row compression.

  - filestream storage.

  - sparse columns.

  - spatial datatypes.

  - Partition-level lock escalation.

  MAINTENANCE:

  - backup compression.

  HA:

  - compressed log streams through DBM.

  - Automatic page repair in DBM.

  SECURITY / AUDITING:

  - TDE

  - CHANGE TRACKING

  - CHANGE DATA CAPTURE

  PERFORMANCE FACILITIES:

  - Extended events

  TOOLS:

  - resource governor.

  Now there is no real gap in architecture and internals between 2005 and 2008.

  HTH David B.

  David B.

• Grant Fritchey

  SSC Guru

  Points: 397721

  More actions

  April 8, 2010 at 6:50 am

  #1148215

  Why not just go right to the source?

  What's New in SQL Server 2008

  ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software