What are advantages of SQL 2000 over SQl 7.0

Home > .NET > SQL

Q

What are advantages of SQL 2000 over SQl 7.0 ?

✍: Guest

A

User-Defined Functions: User-Defined Functions (UDFs) -- one or more Transact-SQL statements can be used to encapsulate code for reuse. Userdefined functions cannot make a permanent change to the data or modify database tables. UDF can change only local objects for a UDF, such as local cursors or variables.
Distributed Partitioned Views: Distributed partitioned views allow you to partition tables horizontally across multiple servers. So, you can scale out one database server to a group of database servers that cooperate to provide the same performance levels as a cluster of database servers. Due to distributed partitioned views, SQL Server 2000 now on the first place in the tpc-c tests.
New Data Types: These include: bigint, an 8-byte integer type; sql_variant, a data type that allows the storage of data of different data types; and the table data type, which allows applications to store results temporarily for later use.
INSTEAD OF and AFTER Triggers: There are INSTEAD OF and AFTER Triggers in SQL Server 2000. INSTEAD OF triggers are executed instead of the INSERT, UPDATE or DELETE triggering action. AFTER triggers are executed after the triggering action.
Cascading Referential Integrity Constraints: There are new ON DELETE and 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 which 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 two options: NO ACTION :-NO ACTION specifies that the deletion/update fail with an error.
CASCADE :-CASCADE specifies that all the rows with foreign keys pointing to the deleted/updated row are also deleted and updated.
32 CPU and 64GB Memory Support: SQL Server 2000 Enterprise Edition running under Windows 2000 DataCenter can support up to 32 CPUs and up to 64GB of physical memory (RAM) on a computer.
XML Support: SQL Server 2000 can use XML to insert, update, and delete values in the database, and the database engine can return data as Extensible Markup Language (XML) documents

2007-10-25, 4920👍, 0💬

What are different types of locks in SQL SERVER
What are different transaction levels in SQL SERVER? Transaction Isolation level decides how is one process isolated from other process.Using transaction levels you can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER READ COMMITTED The shared lock is held for the dur... 2007-10-25, 5993👍, 0💬

What is DBCC
What is DBCC? DBCC (Database Consistency Checker Commands) is used to check logical and physical consistency of database structure.DBCC statements can fix and detect problems.They are grouped in to four categories Maintenance commands like DBCC DBREINDEX , DBCC DBREPAR etc , they are mainly used for... 2007-10-25, 5638👍, 0💬

What is ACID fundamental? What are transactions in SQL SERVER
What is ACID fundamental? What are transactions in SQL SERVER ? A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ACID (Atomicity, Consistency, Isolation, and Durability) properties, to qualify as a t... 2007-10-25, 5343👍, 0💬

What are the different locks in SQL SERVER
What are the different locks in SQL SERVER ? Depending on the transaction level six types of lock can be acquired on data Intent The intent lock shows the future intention of SQL Server's lock manager to acquire locks on a specific unit of data for a particular transaction. SQL Server uses intent lo... 2007-10-25, 5183👍, 0💬

Can we suggest locking hints to SQL SERVER
Can we suggest locking hints to SQL SERVER ? We can give locking hints that helps you over ride default decision made by SQL Server. For instance, you can specify the ROWLOCK hint with your UPDATE statement to convince SQL Server to lock each row affected by that data modification. Whether it's prud... 2007-10-25, 5134👍, 0💬

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. 2007-10-25, 4952👍, 0💬

What are advantages of SQL 2000 over SQl 7.0
What are advantages of SQL 2000 over SQl 7.0 ? User-Defined Functions: User-Defined Functions (UDFs) -- one or more Transact-SQL statements can be used to encapsulate code for reuse. Userdefined functions cannot make a permanent change to the data or modify database tables. UDF can change only local... 2007-10-25, 4921👍, 0💬

What is LOCK escalation
What is LOCK escalation? Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Serve... 2007-10-25, 4913👍, 0💬

What is the difference between UNION and UNION ALL SQL syntax
What is the difference between UNION and UNION ALL SQL syntax ? UNION SQL syntax is used to select information from two tables. But it selects only distinct records from both the table, while UNION ALL selects all records from both the tables. Note : Selected records should have same datatype or els... 2007-10-25, 4900👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.