Sql Server 2005 Advantages

Difference between Sql server 2000 and Sql server 2005 S No

Sql Server 2000

Sql Server 2005

Example

1

It doesn’t support MARS

It does support Multiple active result sets (MARS)

2

In sql server 2000, there exists no structured exception handling. We need to depend on @@ERROR for any errors that occur Performance of query execution is low as compare in Sql Server 2005 CLR integration is not there

It has been enhanced in such a way that developers program more powerful and error resistant SQL code with structured exception handling.

Sql server 2005 provides the ability to have more than one pending request per connection. In Sql Server 2000 while reading records with one reader we can update another record at the same time. We can use try/catch

3

4

5

It doesn’t support XML DataType

6

It does not provide

XML and MDX features

Performance of query execution is much faster as compared to sql server 2000 It supports Integration of the .NET common language runtime (CLR). By default it is off. we explicitly need to start from configuration setting It has a new XML data type as well as a new varbinary(max) data type Has features of XML, Multidimensional Expressions (MDX), and XML for Analysis (XMLA). Integration with the Visual Studio development environment provides more efficient development and debugging of line-of-business and business intelligence (BI) applications