did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780672309038

Microsoft SQL Server 6 Unleashed

by ; ; ; ; ;
  • ISBN13:

    9780672309038

  • ISBN10:

    0672309033

  • Edition: CD
  • Format: Paperback
  • Copyright: 1996-03-01
  • Publisher: Sams
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $59.99

Summary

This combination tutorial/reference teaches the reader how to develop robust systems and how to design, plan, administer, and tune both large and small databases.
-- Covers these programming topics: Referential Integrity, Stored procedures, data structures, and more
-- Teaches these administration subjects: Installation connectivity, security, performance tuning, and others
-- CD-ROM includes source code from the book, programming and administration tools, and libraries

Table of Contents

Introduction
Overview of Client/Serverp. 3
The Microsoft Client/Server Architecturep. 13
Introduction to Transact-SQLp. 29
Transact-SQL Datatypesp. 69
Creating and Altering Database Objectsp. 95
Transact-SQL Programming Constructsp. 149
Transact-SQL Program Structuresp. 199
Transaction Managementp. 233
How to Define Performancep. 253
Understanding SQL Server Storage Structuresp. 265
Designing Indexes for Performancep. 305
Understanding the Query Optimizerp. 327
Stored Procedure Optimizationp. 357
Analyzing Query Plansp. 367
Locking and Performancep. 419
Managing the SQL Server Optimizerp. 435
Database Design and Performancep. 447
Database Object Placement and Performancep. 461
Application Design for Performancep. 481
Advanced SQL Techniquesp. 495
Miscellaneous Performance Topicsp. 511
Common Performance and Tuning Problemsp. 531
Roles and Responsibilities of the System Administratorp. 553
SQL Server Installation and Connectivityp. 565
Defining Physical and Mirror Devicesp. 589
Defining, Altering, and Maintaining Databases and Logsp. 613
Security and User Administrationp. 653
Database Logging and Recoveryp. 693
SQL Server Database Backup and Restorationp. 703
Configuring and Tuning SQL Serverp. 731
Optimizing SQL Server Configuration Optionsp. 753
Measuring SQL Server System Performancep. 769
Remote Server Managementp. 777
The Microsoft SQL Server Distributed Management Frameworkp. 787
Introduction to Microsoft SQL Server 6.0 Replicationp. 807
Defining Systems Administration and Naming Standardsp. 825
Administering Very Large SQL Server Databasesp. 855
DB-Library Programmingp. 879
ODBC Programmingp. 897
Appendix: Legal Agreements Pertaining to the CD-ROMp. 909
Indexp. 913
Table of Contents provided by Blackwell. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program