SQL Server Introduction / Brief idea about SQL Server

                                                              SQLSERVER

* SQL Server is RDBMS product introduced in 1989 , but it is very famous from 1995

* It is Platform dependant database i.e it works only on windows OS

* It can be managed by using the languages like SQL & T-SQL

* SQL is non-procedural language developed by IBM

* T-SQL is procedural language developed by Microsoft

* SQL and T-SQL are not case-sensitive

* Every database is a collection of objects

Object:

Whatever is holding the database is called as an 'object'

                                Version                              CodeName         Compatibility Level

                                                                               

                                8.0(SQL2000)                      Shiloh                                   80

                                8.0(64-bit SQL20)              Liberty                                  80

               

                                9.0(SQL-05)                        Yukon                                   90

                               

                                10.0(SQL-08)                      katmi                                    100

                                10.5 (SQL08-R2)                Kilimanjaro                        100

                                11.0 (SQL-12)                    Denali                                   110

Instance

* One time installation is called as Instance (or)

* It is a separate copy of same software product installed in a machine (or)

* It is a copy of SQLServer which runs in a system either with same version or different version

Advantages

                * To maintain different versions of SQL Server in same box

                * To reduce cost

                * To separate the environments like production, testing,   development.

                * To reduce temp db problems

                * To separate security privileges

SQLServer Strengths

                * One instance can maintain 32,767 databases

                * One database can contain 2 billion tables

                * One table can support up to 1024 columns

                * Single table supports unlimited data (or) unlimited rows up to hard-disk capacity

System requirements for SQLSERVER installation

Processor

                *A computer with an Intel or compatible processors is required for installation

                * The processor must be Intel Pentium 3600 or high

Memory

                * Standard editions require a minimum of 512 MB RAM

                * Enterprise edition require 1 GB RAM

Disk Space

* For full install 2 GB of disk space required

* 90 MB of disk space used if you are only installing the Management Studio and 

  development tools

Internet Requirements

                * Microsoft internet explorer 6.0 or higher and

                * Framework 2.0 required for all SQLServer installation

Operating System

                * Enterprise and standard editions require minimum windows server 2000 with SP4

                * The developer edition require windows server 2003 with SP1