What is the difference between sql server 2008 r2

Akash Garg Updated date Apr 10, Its have unlimited concurrent connections. Data visualization is available by which we can take snapshot of data. It Use 48 bit precision for Spatial Calculation. It makes a perfect backup storage for your information and can perform various functions that meet your needs, such as search, analysis, sharing, etc.

With this server you can use the Filestream data type to reference any file that you have stored on the system. This server was released in and has all the features of the regular version, but it has added features that make it much better than its predecessor. It has a Master Data Service, which is a server that manages many features such as all the different entities and hierarchies.

It has many more visual features and has a high level of support for a new system on the market. You must be logged in to reply to this topic. Login to reply. May 5, at pm May 6, at am Few of the features that i know 1. May 9, at pm November 28, at pm May 15, at pm Dear Friends Read this it may give your query answer.

Capitalize on Hardware Innovation There was always a demand from customers to increase the number of logical processors supported in SQL Server. Optimize Hardware Resources This is a great new feature for database administrators as it will provide a real time insight into Server Utilization, Policy Violations etc. This version introduced the SSMS that we use now. SQL Server included the Adventureworks database in the installer. This version introduced the Service Broker to handle message queue.

SSIS was introduced. In the past, it was used the Data Transformation Services with a different technology used which was completely changed. SQL Server 7. It was also introduced SQL Profiler, which is still in the last versions but will be removed soon. SQL Server 6. In this version, SQL Server was an important database in the market. This version was supported in Windows The main feature in this version was the replication.

SQL Server 4. Yes, there was no version 2 or 3. This version supports the use of structured and semi structured data, including digital media formats pictures, video, audio, etc….

Basically SQL server has the following features:.