Ep

Ep

Difference between MS SQL 2005 & SQL Server 2000 - SQL Server Tutorials

What is the Difference between SQL server 2000 & 2005


In my previous article I explained about What is SQL Server? - An Overview | SQL Server Tutorials. In this article I will explain the differences between MS Sql 2000 & 2005 Database.

What is the Difference between SQL server 2000 & 2005,  Advantages of SQL Server 2008 over SQL Server 2005? , Difference between MS SQL 2000 and MS SQL 2005

Microsoft SQL Server 2005 extends the performance, reliability, availability and ease-of-use of SQL Server 2000. There are following difference between MS SQL Server 2000 and MS SQL Server 2005 :- 

S.no
MS SQL Server 2000
MS SQL Server 2005
1
Query Analyser and Enterprise manager are separate.
Both are combined as SSMS (SQL Server Management Studio)
2
We can create maximum of 65,535 databases.
We can create 2(pow (20))-1 databases.
3
No XML data type is used.
.XML data type is introduced.
4
Exception Handling mechanism is not available
Exception Handling mechanism is available
5
There is no Varchar(Max) data type is not available.
Varchar(Max) data type is introduced.
6
DDL Triggers is not available
DDL Triggers is introduced
7
RowNumber function for paging is not available
RowNumber function for paging is introduced
8
DataBase Mirroring facility is not available.
DataBase Mirroring facility is introduced
9
Table fragmentation facility is not available.
Table fragmentation facility is introduced
10
Full Text Search facility is not available.
Full Text Search facility is introduced.
11
Bulk Copy Update facility is not available.
Bulk Copy Update facility is introduced
12
Data Encryption concept is not introduced.
Cannot encrypt the entire database
13
Cannot compress the tables and indexes.
Can Compress tables and indexes.(Introduced in 2005 SP2)
14
No varchar(max) or varbinary(max) is available.
Varchar(max) and varbinary(max) is used.
15
Data Transformation Services(DTS) is used as ETL tool
SQL Server Integration Services(SSIS) is started using from this SQL Server version and which is used as ETL tool

Difference between MS SQL 2005 & SQL Server 2000 - SQL Server Tutorials Reviewed by Ravi Kumar on 9:44:00 PM Rating: 5

No comments:

All Rights Reserved by Etechpulse © 2012 - 2017
Powered By Blogger

Contact Form

Name

Email *

Message *

Powered by Blogger.