What’s new in Sql server 2000

What’s new in Sql server 2000.
 
As Sql server is the major release which is improved and enterprise level on performance, reliability, scalability, quality and easy to use…
 
their was a major change in Engine on Sql server 7. with sql server 2000 the engine is improved compare with earlier version and make it enterprise level. improved with (Analysis services (OLAP) and other area also) but here we will discuss only on engine.
 
  Sql Server 7 Sql Server 2000
     
Engine good Improved for Enterprise level – ecommerce
New name OLTP Services Analysis Services
New name Repository Components Meta Data Services
  Visual database design tool Database diagram
Collation enhancements Code pages and Sort order -server level Collations – database level and column level
multiple instance on sql server   up to 16
Improved performance/resource   support for 32 CPU and 64 GB RAM….
Failure Clustering na easy to install and improved
Log shipping na high availability option
Net library   improved to make the connectivity
Distributed query   new OPENROWSET to connect to OLE DB  providers
Kerberos and security delegation   maintain
Recovery na Point in time is possible
set Quoted_identifier default OFF ON
Recovery option sp_dboption.combination of – trunc. Log on chkpt and select into/bulk copy simple, build logged full
server configuration option default short-order id, extended memory size, language in cache, language neutral full-text, language neutral full-text, mem async io, resource timeout, spin counter, time slice, Unicode comparison style, Unicode locale id. na
Reserve keywords AVG, COMMITTED, CONFIRM, CONTROLROW, COUNT, ERROREXIT, FLOPPY, ISOLATION, LEVEL, MAX, MIN, MIRROREXIT, ONCE, ONLY, PERM, PERMANENT, PIPE, PREPARE, PRIVILEGES, REPEATABLE, SERIALIZABLE, SUM, TAPE, TEMP, TEMPORARY, UNCOMMITTED, WORK. n/a
profiler sps. xp_trace_addnewqueue, xp_trace_generate_event n/a
for old bcp requires   V switch
     
XML Support   support xml
Federal database server   manage tables horizontally on multiple servers.
New na Query Analyzer object browser
New   Index views
    indexs on computed column
    user define FUNCTION
    Notification services
new data types   bigint, sql_variant, table
    Instead of and After trigger
cascading Integrity constraints   on delete and on update
Replication na schema change in replication (add/drop column)
    Validation of replication
DTS   new custom task and multiple data pump
application to obtain trusted connection not require "trusted connection="yes"
DBCC   can  use parallel processing
after upgrade   should run full text search and update stats.
 
Ansi NULL is also plays an important role in sql server 2000. consider this option with care when upgrading
 
Thanx
Vinay
 
 
Reference:
https:\\microsoft.com/sql
 
 
 
Advertisements
This entry was posted in Whats New. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s