---

Inside Microsoft SQL Server 7.0 (Mps)

ISBN: 0735605173
EAN: 2147483647

Year: 1999
Pages: 144

Authors: Ron Soukup, Kalen Delaney

BUY ON AMAZON

• Cover
• LOC Page
• Foreword
• Preface
• Preface to the First Edition
• Chapter 1 -- The Evolution of Microsoft SQL Server: 1989 to 1998
• Ron s Story
• Kalen s Story
• Microsoft SQL Server Ships
• Development Roles Evolve
• OS2 and Friendly Fire
• Version 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
• The New Future
• 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
• 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
• 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
• Character Sets and Sort Orders
• Installing SQL Server
• Basic Configuration After Installation
• Remote and Unattended Installation
• Summary
• Chapter 5 -- Databases and Database Files
• Special System Databases
• Database Files
• Creating Databases
• Expanding and Shrinking Databases
• Changes in Log Size
• Database Filegroups
• Altering a Database
• Databases Under the Hood
• Database Options
• Other Database Considerations
• Summary
• Chapter 6 -- Tables
• Creating Tables
• Internal Storage -- The Details
• Indexes
• User-Defined Datatypes
• Identity Property
• Constraints
• Altering a Table
• Temporary Tables
• Summary
• Chapter 7 -- Querying Data
• The SELECT Statement
• Joins
• Dealing with NULL
• Subqueries
• Views and Derived Tables
• Other Search Expressions
• Summary
• Chapter 8 -- Modifying Data
• Basic Modification Operations
• Data Modification Internals
• Summary
• Chapter 9 -- Programming With Transact-SQL
• Transact-SQL as a Programming Language
• Transact-SQL Programming Constructs--The Basics
• Summary
• Chapter 10 -- Batches, Transactions, Stored Procedures, and Triggers
• Batches
• Transactions
• Stored Procedures
• Executing Batches or What s Stored About a Stored Procedure?
• Triggers
• Debugging Stored Procedures and Triggers
• Working with Text and Image Data
• Environmental Concerns
• Summary
• Chapter 11 -- Cursors
• Cursor Basics
• Cursors and ISAMs
• Cursor Models
• Appropriate Use of Cursors
• Working with Transact-SQL Cursors
• Cursor Variables
• Summary
• Chapter 12 -- Transact-SQL Examples and Brainteasers
• Using Triggers to Implement Referential Actions
• Brainteasers
• Summary
• Chapter 13 -- Locking
• The Lock Manager
• Lock Types for User Data
• Lock Compatibility
• Bound Connections
• Row-Level vs. Page-Level Locking
• Locking Hints and Trace Flags
• Summary
• Chapter 14 -- Optimizing Query Performance
• The Development Team
• Application and Database Design
• Planning for Peak Usage
• Perceived Response Time for Interactive Systems
• Prototyping, Benchmarking, and Testing
• Creating Useful Indexes
• Using Stored Procedures and Caching Mechanisms
• Concurrency and Consistency Tradeoffs
• Resolving Blocking Problems
• Resolving Deadlock Problems
• Segregating OLTP and DSS Applications
• Optimizing Queries
• Monitoring Query Performance
• Summary
• Chapter 15 -- Configuration and Performance Monitoring
• Windows NT Configuration Settings
• SQL Server Configuration Settings
• System Maintenance
• Monitoring System Behavior
• Summary
• About the Authors
• Suggested Reading