Murakami Sale
 
 

Recently Viewed clear list


The Powell's Playlist | August 8, 2014

Peter Mendelsund: IMG The Powell's Playlist: Water Music by Peter Mendelsund



We "see" when we read, and we "see" when we listen. There are many ways in which music can create the cross-sensory experience of this seeing...... Continue »
  1. $11.87 Sale Trade Paper add to wish list

spacer
Qualifying orders ship free.
$10.50
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside - Bldg. 2 Database- Applications

Inside Microsoft SQL Server(tm) 2005: The Storage Engine

by

Inside Microsoft SQL Server(tm) 2005: The Storage Engine Cover

 

Synopses & Reviews

Publisher Comments:

This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples. Long Description Understanding the internals of storage in SQL Server helps database developers and administrators to better create, maintain, and mine information from enterprise data. This practical, hands-on book focuses on the SQL Server 2005 Storage Engine and delves deep into the structures used for storing data, including files, tables, indexes, and data types. Topics also include security details, with coverage of the new SQL Server 2005 security model, and data protection through the backup and restore algorithms. With pragmatic advice, best practices, extensive code samples, and table examples, developers and database administrators will find the guidance they need to better understand how to build powerful, efficient databases. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers enhanced security features, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. Featuring key advances in enterprise data management, developer productivity, and business intelligence, SQL Server 2005 is part of the Microsoft Windows Server SystemTM--a comprehensive and integrated server infrastructure that simplifies the development, deployment, and operations of a flexible business solution.

Synopsis:

Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.



Discover how to:

  • Upgrade or migrate to SQL Server 2005 and choose configuration options
  • Control space allocation for databases and files manually or automatically
  • Manage transaction logs to maximize efficient restore operations and data consistency
  • Observe the internal structures of clustered and nonclustered indexes
  • Build and partition relational indexes and tables
  • Explore internal storage issues and compare fixed- and variable-length datatypes
  • Detect and correct index fragmentation
  • Implement and manage an appropriate concurrency model using locking or row versioning


      PLUS—Get code samples on the Web.

About the Author

Kalen Delaney is a Microsoft MVP who has worked with SQL Server since 1987. She's a subject-matter expert on Microsoft's official SQL Server courses and previously wrote Inside SQL Server (Microsoft Press). She lives in the Pacific Northwest.

Table of Contents

ForewordAcknowledgmentsIntroductionChapter 1: Installing and Upgrading to SQL Server 2005Chapter 2: SQL Server 2005 ArchitectureChapter 3: SQL Server 2005 ConfigurationChapter 4: Databases and Database FilesChapter 5: Logging and RecoveryChapter 6: TablesChapter 7: Index Internals and ManagementChapter 8: Locking and ConcurrencyAppendix : About the AuthorAppendix : Additional Resources for DevelopersAppendix : More Great Developer Resources

Product Details

ISBN:
9780735621053
Subtitle:
The Storage Engine
Author:
Delaney, Kalen
Manufactured:
Microsoft Press
Publisher:
Microsoft Press
Subject:
Programming Languages - SQL
Subject:
Client-server computing
Subject:
Relational databases
Subject:
Client-Server Computing - General
Subject:
Server Computing
Subject:
Database-Client Server
Subject:
Computers;Database Management;Microsoft SQL Server;Programming Languages;SQL;SQL Server;Server
Subject:
Database Management - General
Copyright:
Edition Description:
2005 ed.
Series:
Developer Reference
Publication Date:
20061011
Binding:
Paperback
Language:
English
Illustrations:
Y
Pages:
464
Dimensions:
9 x 7.3 x 1.1 in 794 gr

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Client Server

Inside Microsoft SQL Server(tm) 2005: The Storage Engine Used Trade Paper
0 stars - 0 reviews
$10.50 In Stock
Product details 464 pages Microsoft Press - English 9780735621053 Reviews:
"Synopsis" by , Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.



Discover how to:

  • Upgrade or migrate to SQL Server 2005 and choose configuration options
  • Control space allocation for databases and files manually or automatically
  • Manage transaction logs to maximize efficient restore operations and data consistency
  • Observe the internal structures of clustered and nonclustered indexes
  • Build and partition relational indexes and tables
  • Explore internal storage issues and compare fixed- and variable-length datatypes
  • Detect and correct index fragmentation
  • Implement and manage an appropriate concurrency model using locking or row versioning


      PLUS—Get code samples on the Web.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.