Explain the new features of SQL server 2000?



Explain the new features of SQL server 2000?..

Answer / ravi raj

XML Support - The relational database engine can return
data as Extensible Markup Language (XML) documents.
Additionally, XML can also be used to insert, update, and
delete values in the database. (for xml raw - to retrieve
output as xml type)
User-Defined Functions - The programmability of Transact-
SQL can be extended by creating your own Transact-SQL
functions. A user-defined function can return either a
scalar value or a table.

Indexed Views - Indexed views can significantly improve the
performance of an application where queries frequently
perform certain joins or aggregations. An indexed view
allows indexes to be created on views, where the result set
of the view is stored and indexed in the database.
New Data Types - SQL Server 2000 introduces three new data
types. bigint is an 8-byte integer type. sql_variant is a
type that allows the storage of data values of different
data types. table is a type that allows applications to
store results temporarily for later use. It is supported
for variables, and as the return type for user-defined
functions.

INSTEAD OF and AFTER Triggers - INSTEAD OF triggers are
executed instead of the triggering action (for example,
INSERT, UPDATE, DELETE). They can also be defined on views,
in which case they greatly extend the types of updates a
view can support. AFTER triggers fire after the triggering
action. SQL Server 2000 introduces the ability to specify
which AFTER triggers fire first and last.

Multiple Instances of SQL Server - SQL Server 2000 supports
running multiple instances of the relational database
engine on the same computer. Each computer can run one
instance of the relational database engine from SQL Server
version 6.5 or 7.0, along with one or more instances of the
database engine from SQL Server 2000. Each instance has its
own set of system and user databases.

Index Enhancements - You can now create indexes on computed
columns. You can specify whether indexes are built in
ascending or descending order, and if the database engine
should use parallel scanning and sorting during index
creation.

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is query processing?

0 Answers  


What value could be assigned to Varchar Type?

3 Answers  


What are system databases in ms sql server?

0 Answers  


How many non clustered indexes there can be on table ?

0 Answers  


Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  


How to test values returned by a subquery with the in operator?

0 Answers  


How we create SQL Server 2005 Reporting Services ? Give me Sample

0 Answers   HCL,


1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,


What is Index Segmentation ?

1 Answers   TCS,


How to generate create procedure script on an existing stored procedure?

0 Answers  


How many triggers are possible per table?

0 Answers  


Categories