Hi…
Finally… the Complete Enterprise product sql server 2008 is a great product, it has everything includes features which other competitors (data base) and more. Here I made the change of my description as there is no major changes in sql server 2005 and 2008… Sql server 2008 has almost all the feature which Sql server 2005 has with added so many newly one. so here I am just listing things which is added in sql server 2008. I also mansion some of the this which is no longer exists in sql server 2008 ( e.g.. no support compatibility of sql server 7 and earlier)… Their is so much great information is already available online…
| Sql Server 2008 | Remark/Description | |
| Great Enhancement in architecture | ||
| Enterprise Data Platform | Policy-Based Management | for compliance… |
| Data collector | performance data collects disk usage,activity, query stats. | |
| Manageability Enhancements | Data Compression | improve disk Io and memory utilization |
| Backup Compression | ||
| Resource Governor | control resources. | |
| Transparent Data Encryption | complete database | |
| Security Enhancements | External Key Management | Security.-using third party |
| Data Auditing | audit -login, data access and modifications … | |
| Hot – Add — CPU and Memory | ||
| Server group management | Central Management Servers –e.g.. can run single query on multiple servers. | |
| Partition Aligned Indexed View | for very large partitioned tables | |
| Extended Events | like trace/troubleshooting … no UI | |
| Availability | ||
| Enhanced Mirroring… automatic page repair | ||
| Dynamic Development | ||
| Programmability Enhancements | Grouping Sets | similar to CUBE and Rollup and more |
| MERGE Operator | good for ‘UPSERT’ update -insert | |
| LINQ | Language Integrated Query can query from languages e.g.. C#, .net | |
| Change Data Capture (CDC) | Capture changes in your tables | |
| Table – Valued Parameters ( TVPs) | now we can pass tables into SP | |
| Conflict Detection in Peer-to-Peer Replication | ensures that data remains consistent | |
| Beyond Relational | ||
| New data types | GEOGRAPHY | Special data type |
| GEOMETRY | Special data type | |
| DATE | ||
| TIME | ||
| DATETIMEOFFSET | ||
| DATETIME2 | ||
| FILESTREAM data | External storage for BLOB in NTFS file system | |
| New Collations | 80 new collations are denoted by *_100 version references | |
| HIERARCHYID | ||
| SPARSE COLUMNS | efficient way to store NULL | |
| Hyper – V* | Support Virtualization | |
| Star Join Query optimization | for warehouses | |
| Filtered Indexes and Statistics | subset of rows in the table | |
| SQL Server Management Studio | T-Sql Debugger | |
| IntelliSense | ||
| Database Engine Error List Window | ||
| support PowerShell | Scripting language | |
| Removed in 2008 | Compatibility 60,65, and 70 | |
| Backup log with truncate only/no_log | ||
| LOAD & DUMP statement | old as backup/restore stmt | |
| Surface Area Configuration (SAC) is now SQL CM (Configuration Manager) | ||
|
There are five new dynamic management views to present memory information:
|
||
| sys.dm_os_memory_brokers (Transact-SQL) | ||
| sys.dm_os_memory_nodes (Transact-SQL) | ||
| sys.dm_os_nodes (Transact-SQL) | ||
| sys.dm_os_process_memory (Transact-SQL) | ||
| sys.dm_os_sys_memory (Transact-SQL)
|
(UPDATE ON 09082009)
*Virtualization : Added in support for Windows Server 2008 R2 with Hyper-V and Hyper-V Server 2008 R2
comparison between 2005 and 2008..
———
Arshad Ali… has written a series (5) of articles on sqlservercentral for what’s new in sql server 2008…
Thanx.
Vinay
Audio Webcast:
Reference:
http://msdn.microsoft.com/en-us/library/ms143729.aspx
http://msdn.microsoft.com/en-us/library/ms144262(printer).aspx
http://msdn.microsoft.com/en-us/library/cc645579.aspx
http://msdn.microsoft.com/en-us/library/bb510411.aspx
http://msdn.microsoft.com/en-us/library/cc645993.aspx
http://msdn.microsoft.com/en-us/library/ms144262(printer).aspx
http://msdn.microsoft.com/en-us/library/cc645579.aspx
http://msdn.microsoft.com/en-us/library/bb510411.aspx
http://msdn.microsoft.com/en-us/library/cc645993.aspx
added (10122009)
http://serverfault.com/questions/65660/improvement-not-new-features-between-sql-server-2005-and-2008
Webcast:
Vinay Thakur 