|
" Microsoft SQL server 2008 internals / "
Kalen Delaney [and others].
Document Type
|
:
|
BL
|
Record Number
|
:
|
954919
|
Doc. No
|
:
|
b709289
|
Title & Author
|
:
|
Microsoft SQL server 2008 internals /\ Kalen Delaney [and others].
|
Publication Statement
|
:
|
Redmond, Wash. :: Microsoft,, ©2009.
|
Page. NO
|
:
|
1 online resource (xxvi, 754 pages) :: illustrations
|
ISBN
|
:
|
0735626243
|
|
:
|
: 0735634785
|
|
:
|
: 073563632X
|
|
:
|
: 9780735626249
|
|
:
|
: 9780735634787
|
|
:
|
: 9780735636323
|
|
:
|
0735626243
|
|
:
|
9780735626249
|
Abstract
|
:
|
Delve inside the core SQL Server engine-and put that knowledge to work-with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you'll gain the deep knowledge you need to exploit key architectural changes-and capture the product's full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking-from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan-or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users.
|
Subject
|
:
|
Database management.
|
Subject
|
:
|
Relational databases.
|
Subject
|
:
|
COMPUTERS-- Data Processing.
|
Subject
|
:
|
Database management.
|
Subject
|
:
|
Database management.
|
Subject
|
:
|
Relational databases.
|
Subject
|
:
|
SQL server.
|
|
:
|
SQL server.
|
|
:
|
SQL server.
|
Dewey Classification
|
:
|
005.4/476
|
LC Classification
|
:
|
QA76.9.D3M53 2009 ebook
|
Added Entry
|
:
|
Delaney, Kalen.
|
Parallel Title
|
:
|
SQL server 2008 internals
|
| |