Flylib.com
Inside Microsoft SQL Server 2000
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
Inside Microsoft SQL Server 2000
ISBN: 0735609985
EAN: 2147483647
Year: 2005
Pages: 179
Authors:
Kalen Delaney
BUY ON AMAZON
The CISSP and CAP Prep Guide: Platinum Edition
Operations Security
Legal, Regulations, Compliance, and Investigations
The Accreditation Phase
Appendix D The Information System Security Engineering Professional (ISSEP) Certification
Appendix G Control Baselines
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Jump Start with SWT/JFace
Trees
Scales, Sliders, and Progress Bars
Drag and Drop and the Clipboard
Drawing Diagrams with Draw2D
Special Edition Using Crystal Reports 10
Introduction
Using Existing Crystal Reports as Templates
What Is the Crystal Repository?
Crystal Analysis in the Real World MDX
Creating Schedulable Program Objects
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Photoshop Layers and After Effects
3-D Layers from Photoshop Layers
Static Matte Painting in Photoshop
Making Movies from Stills
Custom Scene Transitions
File System Forensic Analysis
File System Category
FAT
Index Attributes and Data Structures
Symbolic Link
Bibliography
Python Standard Library (Nutshell Handbooks) with
The fnmatch Module
The rotor Module
The popen2 Module
The mailcap Module
The shelve Module
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies