April 7, 2010 at 6:42 pm
Hi All,
can any one give me brief architecture difference of sqlserver 2005 and 2008 along with its new features.
Thanks
Shashi Kant Chauhan
April 8, 2010 at 1:07 am
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.
April 8, 2010 at 6:50 am
Why not just go right to the source?
"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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply