Flylib.com
Inside Microsoft SQL Server 7.0 (Mps)
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
Inside Microsoft SQL Server 7.0 (Mps)
ISBN: 0735605173
EAN: 2147483647
Year: 1999
Pages: 144
Authors:
Ron Soukup
,
Kalen Delaney
BUY ON AMAZON
Project Management JumpStart
Building the Foundation
Breaking Down the Project Activities
Planning and Acquiring Resources
Executing the Project
Appendix C Sample Project Management Checklists
Building Web Applications with UML (2nd Edition)
Role of Process
Activities
Client-Side Risks
UX Modeling with UML
Software Architecture Document
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Using Formula Language in LotusScript Code
Links to developerWorks
Retrieve All Views in a Database
LotusScript Agent to Modify All Documents Containing a Specific Field Value
Encrypt the Database
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 23. Explore David Rumseys Historical Maps
Hack 24. Explore a 3-D Model of the Entire World
Hack 34. Map Other Planets
Hack 39. View Your Photo Thumbnails on a Flash Map
Hack 67. Seamless Data Download from the USGS
Cultural Imperative: Global Trends in the 21st Century
Culture and Climate
Americanization versus Asianization
Culture and Globalization
Appendix A Cultural Categorization Characteristics
Appendix B Leadership Test
Python Standard Library (Nutshell Handbooks) with
The rotor Module
Data Representation
Overview
The SimpleHTTPServer Module
The pre 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