What is the difference between sql server 2005 and 2008

It includes a single profiler. SQL Server Express has all security features offered in SQL Server including advanced auditing, authentication, authorization, built-in data encryption and Microsoft baseline security analyzer integration.

SQL Server Express can exchange messages with other editions, however messages between two instances must be sent through another edition. Express offers Merge and Transaction replication.

SQL Server Express is freely downloadable. Entity Data Services. Data Synchronizing. Development of frequently disconnected applications.

Large UDT. No size restriction on UDT. Dates and Times. File Stream. Table Value Parameters. The ability to pass an entire table to a stored procedure. Spatial Data. Full Text Search.

Native Indexes, thesaurus as metadata, and backup ability. Improved multiprocessor support and faster lookups. Stack improvements, faster block computations. Your Data files can be stored in Azure. There are enhancements in AlwaysOn, Columnstore Indexes. Business Intelligence edition for SQL Server was introduced; An edition that supports the most important features related to Business intelligence. The semantic search is a feature included in Full text search to search in unstructured documents.

Columnstore Indexes is another powerful feature to get faster query responses in tables like Data Warehouse tables. Online index creation is now supported. Data Collector was a feature to collect monitoring information in a Data Warehouse. SQL also offered compressed indexes and tables. In data types, it was introduced the hierarchyid data type and spatial data types.

Also, some new date and time data types and User-Defined data types. You can also implement in this version filtered indexes and statistics. This version introduced the SSMS that we use now. SQL Server included the Adventureworks database in the installer. JohnZ JohnZ 2 2 gold badges 8 8 silver badges 20 20 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. SqlACID 4, 19 19 silver badges 29 29 bronze badges.

Melanie Melanie 2, 6 6 gold badges 33 33 silver badges 53 53 bronze badges. Thank you. That is what I was looking for. I will mark it when I can. Hassan Voyeau Hassan Voyeau 3, 3 3 gold badges 21 21 silver badges 24 24 bronze badges.

Version control! Community Bot 1 1 1 silver badge. That site lists more the backbone, behind the scene differences.