Advantages of sql 2000 over sql 7.0, DOT NET Programming

Assignment Help:

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.


Related Discussions:- Advantages of sql 2000 over sql 7.0

Develop c# routines for website back end, Project Description: We requir...

Project Description: We require some routines written in C# (.NET) to: * Parse several RESTful APIs to change and push data to RabbitMQ * Pop objects from RabbitMQ and inp

What is object relational designe, What is Object Relational Designer? ...

What is Object Relational Designer? The 0/R Designer provides a visual design surface to make LINQ to SQL entity classes and associations (relationships) that are based on obje

Asp .net facebook app project completion, Project Description: We are a ...

Project Description: We are a small development house in Singapore, and have a project which is 90 percent complete; thud our previous developer could not finish due to other co

Develop a windows backup application, Develop a Windows Backup Application ...

Develop a Windows Backup Application Application Goal The goal is to prepare an easy to use application that provides the user peace of mind that all of their firewalls are b

Uml, What is UML? The Unified Modeling Language (UML) is a graphical la...

What is UML? The Unified Modeling Language (UML) is a graphical language for documenting, specifying, visualizing,  constructing, and  the artifacts of a software-intensive sys

Raise custom errors from stored procedure, How can you raise custom errors ...

How can you raise custom errors from stored procedure? The RAISERROR statements are  used to produce an ad hoc error message or to retrieve acustom message which is stored in t

Want c# single user login per session, Want C# Single User Login per sessio...

Want C# Single User Login per session Project Description: I need to save simulatenious logins for one account such as one user has a spottily premium account and someone tri

Define importance of vitamin c, Define importance of Vitamin c Freezing...

Define importance of Vitamin c Freezing preserves vegetable and nutrients to a great extent. Vitamin A and β-Carotene are well preserved in spinach, peas and beans, or are mode

Fake webcam application, I need a program that mimics the similar functiona...

I need a program that mimics the similar functionality as the link below. Program must have a unique user interface. Must add source code, installer, and of course a nice user i

Social media project, Social Media project Project Description: It's ...

Social Media project Project Description: It's a Windows Phone application which requires the subsequent capabilities: -Live Video Streaming -Social Networking capabili

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd