What’s new in Microsoft Sql Server 7 -Server

This is the second part of what’s new in Microsoft sql server 7,
b. Server:
 
  Sql Server 6x Sql Server 7  
Server     Remark
Backup/restore   online bkp improved.  
    supports differential bkp and recovery  
    no setup for restore another server  
    restore will create database automatically  
  NA attach and detach is possible  
       
  only sql authentication windows authentication included  
Store procedure separate compile plan for each user -procedure cache shared for all user  
  parameter marker( parameter) parameter name  
    procedure cache stores ad hoc parameterized queries  
    differed name resolution – if no table exists we can create SP  
compliance   SQL 92  
       
Replication   build in with sql (enterprise manager)  
    scriptable/immediate update with multiple sites.  
    Microsoft Management console Enterprise manager
  SQL Executive Sql Agent Improved
  isql/w Query analyzer uses ODBC
    osql uses ODBC
    isql DB – Library
  Service manager on taskbar default  
  Sql Trace Profiler  
    Index Tuning Wizard  
    DTS  
Parallel query execution NA default support multiple processors
    Good for VLDB – High end.  

 

 
Thanx.
Vinay
 
Reference
 
 
 
 
 
 
 
 
 
 
 

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