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...
  • T-SQL tutorial
    Welcome to beginner to advance T-SQL tutorial. In this tutorial I have explained you about basic to advance T-SQL statement .This tutorial ...
  • Transact-SQL using for SQL Server
    create a table simple tableperson  create table person (     p_id  int,     firstname varchar(50),      lastname varchar(50),     addr...