---

Inside Microsoft SQL Server 2000

ISBN: 0735609985
EAN: 2147483647

Year: 2005
Pages: 179

Authors: Kalen Delaney

BUY ON AMAZON

• Cover
• LOC Page
• Dedication
• Foreword
• Preface
• Preface to the Second Edition
• Preface to the First Edition
• System Requirements for the Companion CD-ROMs
• Part I: Overview
• Chapter 1 -- The Evolution of Microsoft SQL Server: 1989 to 2000
• SQL Server: The Early Years
• Ron s Story
• Kalen s Story
• Microsoft SQL Server Ships
• Development Roles Evolve
• OS2 and Friendly Fire
• SQL Server 4.2
• SQL Server for Windows NT
• Success Brings Fundamental Change
• The End of Joint Development
• The Charge to SQL95
• The Next Version
• The Secret of the Sphinx
• Software for the New Century
• Chapter 2 -- A Tour of SQL Server
• The SQL Server Engine
• DBMS-Enforced Data Integrity
• Transaction Processing
• Symmetric Server Architecture
• Security
• High Availability
• Distributed Data Processing
• Data Replication
• Systems Management
• SQL Server Utilities and Extensions
• Client Development Interfaces
• Summary
• Part II: Architectural Overview
• Chapter 3 -- SQL Server Architecture
• The SQL Server Engine
• Managing Memory
• Transaction Logging and Recovery
• The SQL Server Kernel and Interaction with the Operating System
• Summary
• Part III: Using Microsoft SQL Server
• Chapter 4 -- Planning For and Installing SQL Server
• SQL Server Editions
• Hardware Guidelines
• Hardware Components
• The Operating System
• The File System
• Security and the User Context
• Licensing
• Network Protocols
• Collation
• Multiple Instances
• Installing SQL Server
• Basic Configuration After Installation
• Remote and Unattended Installation
• Summary
• Chapter 5 -- Databases and Database Files
• Special System Databases
• Database Files
• Creating a Database
• Expanding and Shrinking a Database
• Changes in Log Size
• Using Database Filegroups
• Altering a Database
• Databases Under the Hood
• Setting Database Options
• Other Database Considerations
• Backing Up and Restoring a Database
• Summary
• Chapter 6 -- Tables
• Creating Tables
• User-Defined Datatypes
• Identity Property
• Internal Storage
• Constraints
• Altering a Table
• Temporary Tables
• System Tables
• Summary
• Chapter 7 -- Querying Data
• The SELECT Statement
• Joins
• Dealing with NULL
• Subqueries
• Views and Derived Tables
• Other Search Expressions
• Summary
• Chapter 8 -- Indexes
• Index Organization
• Creating an Index
• The Structure of Index Pages
• Index Space Requirements
• Managing an Index
• Special Indexes
• Using an Index
• Summary
• Chapter 9 -- Modifying Data
• Basic Modification Operations
• Data Modification Internals
• Summary
• Chapter 10 -- Programming with Transact - SQL
• Transact-SQL as a Programming Language
• Transact-SQL Programming Constructs
• Transact-SQL Examples and Brainteasers
• Full-Text Searching
• Summary
• Chapter 11 -- Batches, Stored Procedures, and Functions
• Batches
• Routines
• Stored Procedures
• User-Defined Functions
• Rewriting Stored Procedures as Functions
• Rolling Your Own System Routines
• Executing Batches, or What s Stored About Stored Procedures (and Functions)?
• Temporary Stored Procedures
• Autostart Stored Procedures
• System Stored Procedures
• Execute(ANY STRING)
• Summary
• Chapter 12 -- Transactions and Triggers
• Transactions
• Triggers
• Summary
• Chapter 13 -- Special Transact-SQL Operations: Working with Cursors and Large Objects
• Cursor Basics
• Cursors and ISAMs
• Cursor Models
• Appropriate Use of Cursors
• Working with Transact-SQL Cursors
• Cursor Variables
• Working with Text and Image Data
• Summary
• Part IV: Performance and Tuning
• Chapter 14 -- Locking
• The Lock Manager
• Lock Types for User Data
• Lock Compatibility
• Internal Locking Architecture
• Bound Connections
• Row-Level vs. Page-Level Locking
• Locking Hints and Trace Flags
• Summary
• Chapter 15 -- The Query Processor
• The SQL Manager
• Compilation and Optimization
• The Procedure Cache
• Using Stored Procedures and Caching Mechanisms
• Execution
• Summary
• Chapter 16 -- Query Tuning
• The Development Team
• Application and Database Design
• Planning for Peak Usage
• Perceived Response Time for Interactive Systems
• Prototyping, Benchmarking, and Testing
• Creating Useful Indexes
• Monitoring Query Performance
• Concurrency and Consistency Tradeoffs
• Resolving Blocking Problems
• Resolving Deadlock Problems
• Segregating OLTP and DSS Applications
• Environmental Concerns
• Summary
• Chapter 17 -- Configuration and Performance Monitoring
• Operating System Configuration Settings
• SQL Server Configuration Settings
• System Maintenance
• Monitoring System Behavior
• Summary
• Bibliography and Suggested Reading
• Footnotes
• About the Author
• About This Electronic Book
• About Microsoft Press