What are advantages of SQL 2000 over SQl 7.0?

1)User-Defined Functions: The User-Defined Functions (UDFs) -- one or moreTransact-SQL statements may be used to encapsulate the code for reuse. The Userdefinedfunctions cannot make a permanent change to the data or modifythe database tables. The UDF can change only the local objects for a UDF, like local cursors or variables.

2)Distributed Partitioned Views: The Distributed partitioned views allow you topartition the tables horizontally across the multiple servers. Therefore, you can scale out onedatabase server to a group of database servers that cooperate to provide thesame performance levels as a cluster of database servers. Due to the distributed partitioned views, the SQL Server 2000 now on the first place in the tpc-c tests.

3)New Data Types: This include: bigint, sql_variant,an 8-byte integer type;  a data type that allows the storage of data of different data types; and the table  data type, which allows all applications to store the results temporarily for later use.

4)INSTEAD OF and AFTER Triggers: There are INSTEAD OF & AFTER Triggers in the SQL Server 2000. INSTEAD  triggers are executed instead of the INSERT,DELETE , UPDATE or triggering action. AFTER triggers are executed after the triggering action.

5)Cascading Referential Integrity Constraints: These are new ON DELETE & ON UPDATE clauses in the REFERENCES clause of the CREATE TABLE and ALTER TABLE statements. The ON DELETE clause controls what actions are taken if you attempt to delete a row to that existing foreign keys point. The ON UPDATE clause defines the actions that are taken if you attempt to update a candidate key value to which existing foreign keys point.

The ON DELETE and ON UPDATE clauses have 2 options:

NO ACTION :-The NO ACTION specifies that the deletion/update fail with an error.

CASCADE :-The CASCADE specifies that all the rows with foreign keys pointing to the deleted/updated row are also deleted and updated.

6)32 CPU and 64GB Memory Support: The SQL Server 2000 Enterprise Edition running under the Windows 2000 DataCenter can support up to 32 CPUs and up to 64GB of physical memory (RAM) on a computer.

7)XML Support: The SQL Server 2000 can use XML to insert,  delete, and update values in the database, and the database engine can return data as in the Extensible Markup Language (XML) documents.

Posted Date: 9/24/2012 4:14:01 AM | Location : United States

Ask an Expert

Related Discussions:- Advantages of sql 2000 over sql 7.0, Assignment Help, Ask Question on Advantages of sql 2000 over sql 7.0, Get Answer, Expert's Help, Advantages of sql 2000 over sql 7.0 Discussions

Write discussion on Advantages of sql 2000 over sql 7.0
Your posts are moderated

Write your message here..

Related Questions

Record processing system, Your first assignment will require you to develop... Your first assignment will require you to develop a record processing system in both ASP and PHP, giving you an opportunity to see two modern web scripting languages in action.

How do i force the dispose method to be called automatically, How do I forc... How do I force the Dispose method to be called automatically, as clients can forget to call Dispose method? To Call the Dispose method in the Finalize method and in the Dispose

Need help in fixing chrome problem, Fixing chrome problem Problem 1- Boo... Fixing chrome problem Problem 1- Booksearcha.asp and bookrstep2.asp on allreaders.com (bookrstep2 only accessible from bookrstep1.asp) utilize scroll down menus at times. In Chr

C# pyramid type programs, 1 2 2 3 3 3 4 4 4 4 3 3 3 2 2 1 1 2 2 3 3 3 4 4 4 4 3 3 3 2 2 1

Wds and mdt deployment server training, WDS and MDT Deployment Server Train... WDS and MDT Deployment Server Training Project Description: I'm seeking someone who can Teach/Train me with MDT and WDS server. This Can be online teaching courses. I will

Finding the frequencies - c# program, Finding the frequencies - C# Program:... Finding the frequencies - C# Program: Please let me know how to find Frequencies in C#.

Software bot for domain parking, I have 10 domains which are presently park... I have 10 domains which are presently parked, now I need a software/Bot which generate clicks on the ads placed on the website. These clicks which are generated should use proxy to

I need c# aac sound receiver over wcf, I need C# AAC sound receiver over WC... I need C# AAC sound receiver over WCF Project Description: I want a WCF method which is able to receive a byte stream of an AAC sound file from iPhone device and save it on t

Develop nesting software with unit costing, Develop Nesting software with u... Develop Nesting software with unit costing for gasket manufacturing Project Description: Our current gasket costing software is old and antiquated and has limited use interna

What is the use of the commandbuilder class, What is the use of the Command... What is the use of the CommandBuilder class? The CommandBuilder class is used to automatically update a database according to the changes made in a DataSet. This class autom