Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint
    Share this Page URL
    Help

    Contents

    Contents

    Introduction

    Chapter 1 Overview of Microsoft SQL Server 2008

    SQL Server in the Enterprise World

    The Need for an Enterprise System

    SQL Server Features

    SQL Server's Place Within Microsoft Architecture

    SQL Server Licensing

    Installing SQL Server 2008

    Defining an Installation Plan

    SQL Server 2008 Installation Requirements

    The SQL Server Installation Process

    Verifying the Installation

    The SQL Server Tool Set

    The Microsoft Client Tools

    Third-Party Tools and Utilities

    The Bottom Line

    Chapter 2 Understanding SQL Server Architecture

    Essential Internals

    SQL Server Data Storage Architecture

    The Data Engine

    SQL Server and Windows

    The SQL Server System Catalog

    The System Databases

    System Tables, Views, and Functions

    System Stored Procedures

    Datatyping

    System-Defined Datatypes


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial