Friday, November 22, 2013

what is database ?

Database a usually large collection of data organized specially for rapid search and retrieval as by a computer.

 Sql server supported two type of database 

  •  system database 

Like 

Master database

The  master database maintain all the system level information for a sql server system. Such as logon accounts, link server, and system configuration settings.
Model database act as a template for creating user define database .

Msdb database

MSDB database is used  by sql server agent for auto backup, jobs and scheduling alerts .

  Temp db database

TEMDB database used for temporary user objects that are explicitly created, such as sql query handling .

  • sample database

sql server sample database use for testing purpose.
Such as
Pubs , northwind --- It is use in sql server 2000
Adventure work --- it is use in sql server 2005,2008

  •  user defined database 

     

 

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

sql server index

sql index An index is an internal table structure that sql server uses to provide quick access to rows of a table based on the values...

  • SQL Server improving
    In the ten years since release of Microsoft's previous SQL Server product (SQL Server 2000), advancements have been made in performance...
  • Sql server create database
    create database student on primary (    name = 'st_data' , - - à it is use for logical name.    filename = 'f:\my...
  • Sql server database files
    Sql server database have three type of file  1) Primary data files 2) Secondary data files 3) log files What are primary data files? ...