Flylib.com
Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
ISBN: 0735621055
EAN: 2147483647
Year: 2004
Pages: 115
Authors:
Kalen Delaney
BUY ON AMAZON
Inside Microsoft SQL Server 2005: The Storage Engine
Table of Contents
Copyright
Foreword
Acknowledgments
Introduction
Chapter 1. Installing and Upgrading to SQL Server 2005
SQL Server 2005 Prerequisites
Pre-Installation Decisions
Getting Ready to Install
To Migrate or Upgrade?
Selecting Components
Summary
Chapter 2. SQL Server 2005 Architecture
Components of the SQL Server Engine
Memory
Final Words
Chapter 3. SQL Server 2005 Configuration
Using SQL Server Configuration Manager
System Configuration
Final Words
Chapter 4. Databases and Database Files
System Databases
Sample Databases
Database Files
Creating a Database
Expanding or Shrinking a Database
Using Database Filegroups
Altering a Database
Databases Under the Hood
Setting Database Options
Database Snapshots
The tempdb Database
Database Security
Moving or Copying a Database
Compatibility Levels
Summary
Chapter 5. Logging and Recovery
Transaction Log Basics
Changes in Log Size
Reading the Log
Backing Up and Restoring a Database
Summary
Chapter 6. Tables
System Objects
Creating Tables
User-Defined Data Types
IDENTITY Property
Internal Storage
Constraints
Altering a Table
Summary
Chapter 7. Index Internals and Management
Index Organization
Creating an Index
The Structure of Index Pages
Index Space Requirements
Special Indexes
Table and Index Partitioning
Data Modification Internals
Managing Indexes
Using Indexes
Summary
Chapter 8. Locking and Concurrency
Concurrency Models
Transaction Processing
Locking
Lock Compatibility
Internal Locking Architecture
Bound Connections
Row-Level Locking vs. Page-Level Locking
Row Versioning
Other Features That Use Row Versioning
Controlling Locking
Summary
About the Author
Additional Resources for Developers
Visual Basic 2005
Visual C 2005
Web Development
Data Access
SQL Server 2005
Other Visual Studio 2005 Topics
Other Developer Topics
More Great Developer Resources
Developer Step by Step
Developer Reference
Advanced Topics
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)
ISBN: 0735621055
EAN: 2147483647
Year: 2004
Pages: 115
Authors:
Kalen Delaney
BUY ON AMAZON
Data Structures and Algorithms in Java
Polymorphism
Problems
Vocabulary
Minimum Spanning Trees
A.6. Methods and Breaking Out
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Understanding Intrusion Detection
IDS and IPS Internals
Snort
Data Correlation
Incident Response
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 9. Track the Friendly Skies with Sherlock
Hack 20. Make 3-D Raytraced Terrain Models
Hack 42. Map Your Tracklogs on the Web
Hack 88. Load Your Waypoints into a Spatial Database
Hack 90. Crawl the Geospatial Web with RedSpider
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 18. Examine Patterns of Criminal Activity
Hack 19. Map Local Weather Conditions
Hack 21. Track the International Space Station
Hack 49. Generate Geocoded RSS from Any Google Map
Hack 69. Cluster Markers at High Zoom Levels
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Basic Commands to Get Started
Generating Elevations
Dimensioning a Drawing
Using Layouts to Set Up a Print
Printing an AutoCAD Drawing
Quantitative Methods in Project Management
Project Value: The Source of all Quantitative Measures
Organizing and Estimating the Work
Quantitative Time Management
Special Topics in Quantitative Management
Quantitative Methods in Project Contracts
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