Inside Microsoft SQL Server 2005: The Storage Engine
- ISBN-10
- 0735621055
- ISBN-13
- 9780735621053
- Series
- Inside Microsoft SQL Server 2005
- Category
- Client/server computing
- Language
- English
- Published
- 2007
- Author
- Kalen Delaney
Description
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.
Get the book
Other editions
Similar books
-
Mastering Microsoft Exchange Server 5
By Barry GerberAnywhere 555-555-9725 508 555-555-5592 592 Administrator Alvarez , Rubin Anderson , John Andrews , Archie anon Application Recipients Bolton , Jim Boyd , William Davis , Kay Dead Letter Managers Doggson , Bob Dummy Tempate NY ( Mail .
-
MCSE Exam Notes: Proxy Server 2
By Todd Lammle, Scott RichardsonThis reference covers one of the elective exams for the MCSE--Implementing and Supporting Microsoft Proxy Server 2.0--giving complete information on the exam objectives.
-
More Jumping JavaScript
By Bill Anderson, Brian Freeman, Janice Winsor< P ID = " txtLunacy " CLASS = title > Lunacy < / P > < P ID = " txt Best " CLASS = title > Best of Times < / P > < P ID = " txtBroken " CLASS = title > Broken < / P > < / DIV > < DIV ID = " slctBtn " > < IMG SRC = " images ...
-
Professional Sql Server 2000 Dts
By Mark ChaffinProfessional Sql Server 2000 Dts
-
Inside Windows NT Server 4, Certified Administrator's Resource Edition
By Drew Heywood... Charles Gose , Dayna Isley , Greg Pearson , Cliff Shubs , Paul Worthington Technical Editors Alain Guilbault Software Product Developer Steve Flatt Assistant Marketing Manager Gretchen Schlesinger Acquisitions Coordinator Amy Lewis ...
-
Access 95 Client/server Development
By Michelle Poolet, Michael ReillyThis book provides powerful, real-world examples--such as Pizza Hut and Land's End--on the effective use, design, and maintenance of Access front-ends for anyone programming with Access in a client/server environment....
-
Microsoft .NET Framework Web Developer Core Requrements: Self-paced Training Kit
By Tony Northrup, Shawn Wildermuth, Brian C. LanhamAce your preparation for the skills measured by three required MCPD: Web Developer exams—and on the job.
-
A Guide to Microsoft Exchange Server 5.5
By Ed Tittel, Barry Shilmover, Tim Catura-HouserP Office SIA CA Contacts Microsoft Outlook Eile Edit View Go Tools Actions Help Bo Find Organize Outlook Shortcuts ... Duke for each contact , and go Archell , Douglas J. Boyer , Wynn Sent Items directly to any contact's World Full Name ...
-
The Complete TCP/IP Training Course
By Douglas ComerThe Complete TCP/IP Training Course
-
Internetworking with TCP/IP.: Design, implementation, and internals
By Douglas Comer, David L. StevensThis text provides an in-depth look at the TCP/IP Internet Protocols. It presents a complete implementation - showing the internals of the TCP/IP protocol software - with actual code. This...