中圖網小程序
一鍵登錄
更方便
本類五星書更多>
-
>
全國計算機等級考試最新真考題庫模擬考場及詳解·二級MSOffice高級應用
-
>
決戰行測5000題(言語理解與表達)
-
>
軟件性能測試.分析與調優實踐之路
-
>
第一行代碼Android
-
>
JAVA持續交付
-
>
EXCEL最強教科書(完全版)(全彩印刷)
-
>
深度學習
深入解析SQL Server 2008-英文版 版權信息
- ISBN：9787115211439
- 條形碼：9787115211439 ; 978-7-115-21143-9
- 裝幀：一般膠版紙
- 冊數：暫無
- 重量：暫無
- 所屬分類：>>
深入解析SQL Server 2008-英文版 本書特色
本書是“微軟技術系列”之一，全書共分11個章節，主要對SQL Server處理查詢、管理數據作了詳細闡述，具體內容包括SQL Server架構和配置、跟蹤/擴展事件、日志和恢復、查詢優化等。該書可供各大專院校作為教材使用，也可供從事相關工作的人員作為參考用書使用。
深入解析SQL Server 2008-英文版 內容簡介
本書是講述sql server關系數據庫引擎內部機理和架構的權威指南。書中詳細闡述了sql server處理查詢、管理數據的相關內容，包括sql server架構和配置、跟蹤/擴展事件、日志和恢復、索引、表格、查詢優化、事務/并發以及dbcc。
本書適合中高級數據庫開發人員閱讀。
深入解析SQL Server 2008-英文版 目錄
1 sql server 2008 architecture and configuration
sql server editions
sql server metadata
compatibility views
catalog views
other metadata
components of the sql server engine
observing engine behavior
protocols
the relational engine
the storage engine
the sqlos
numa architecture
the scheduler
sql server workers
binding schedulers to cpus
the dedicated administrator connection (dac)
memory
the buffer pool and the data cache
access to in-memory data pages
managing pages in the data cache
the free buffer list and the lazywriter
checkpoints
managing memory in other caches
sizing memory
sizing the buffer pool
sql server resource governor
resource governor overview
resource governor controls
resource governor metadata
sql server 2008 configuration
using sql server configuration manager
configuring network protocols
default network configuration
managing services
sql server system configuration
operating system configuration
trace flags
sql server configuration settings
the default trace
final words
2 change tracking, tracing, and extended events
the basics: triggers and event notifi cations
run-time trigger behavior
change tracking
change tracking configuration
change tracking run-time behavior
tracing and profiling
sql trace architecture and terminology
security and permissions
getting started: profi ler
server-side tracing and collection
extended events
components of the xe infrastructure
event sessions
extended events ddl and querying
summary
3 databases and database files
system databases
master
model
tempdb
the resource database
msdb
sample databases
adventureworks
pubs
northwind
database files
creating a database
a create database example
expanding or shrinking a database
automatic file expansion
manual file expansion
fast file initialization
automatic shrinkage
manual shrinkage
using database filegroups
the default filegroup
a filegroup creation example
filestream filegroups
altering a database
alter database examples
databases under the hood
space allocation
setting database options
state options
cursor options
auto options
sql options
database recovery options
other database options
database snapshots
creating a database snapshot
space used by database snapshots
managing your snapshots
the tempdb database
objects in tempdb
optimizations in tempdb
best practices
tempdb space monitoring
database security
database access
managing database security
databases vs. schemas
principals and schemas
default schemas
moving or copying a database
detaching and reattaching a database
backing up and restoring a database
moving system databases
moving the master database
compatibility levels
summary
4 logging and recovery
transaction log basics
phases of recovery
reading the log
changes in log size
virtual log files
observing virtual log files
automatic truncation of virtual log files
maintaining a recoverable log
automatic shrinking of the log
log file size
backing up and restoring a database
types of backups
recovery mo
sql server editions
sql server metadata
compatibility views
catalog views
other metadata
components of the sql server engine
observing engine behavior
protocols
the relational engine
the storage engine
the sqlos
numa architecture
the scheduler
sql server workers
binding schedulers to cpus
the dedicated administrator connection (dac)
memory
the buffer pool and the data cache
access to in-memory data pages
managing pages in the data cache
the free buffer list and the lazywriter
checkpoints
managing memory in other caches
sizing memory
sizing the buffer pool
sql server resource governor
resource governor overview
resource governor controls
resource governor metadata
sql server 2008 configuration
using sql server configuration manager
configuring network protocols
default network configuration
managing services
sql server system configuration
operating system configuration
trace flags
sql server configuration settings
the default trace
final words
2 change tracking, tracing, and extended events
the basics: triggers and event notifi cations
run-time trigger behavior
change tracking
change tracking configuration
change tracking run-time behavior
tracing and profiling
sql trace architecture and terminology
security and permissions
getting started: profi ler
server-side tracing and collection
extended events
components of the xe infrastructure
event sessions
extended events ddl and querying
summary
3 databases and database files
system databases
master
model
tempdb
the resource database
msdb
sample databases
adventureworks
pubs
northwind
database files
creating a database
a create database example
expanding or shrinking a database
automatic file expansion
manual file expansion
fast file initialization
automatic shrinkage
manual shrinkage
using database filegroups
the default filegroup
a filegroup creation example
filestream filegroups
altering a database
alter database examples
databases under the hood
space allocation
setting database options
state options
cursor options
auto options
sql options
database recovery options
other database options
database snapshots
creating a database snapshot
space used by database snapshots
managing your snapshots
the tempdb database
objects in tempdb
optimizations in tempdb
best practices
tempdb space monitoring
database security
database access
managing database security
databases vs. schemas
principals and schemas
default schemas
moving or copying a database
detaching and reattaching a database
backing up and restoring a database
moving system databases
moving the master database
compatibility levels
summary
4 logging and recovery
transaction log basics
phases of recovery
reading the log
changes in log size
virtual log files
observing virtual log files
automatic truncation of virtual log files
maintaining a recoverable log
automatic shrinking of the log
log file size
backing up and restoring a database
types of backups
recovery mo
展開全部
深入解析SQL Server 2008-英文版 作者簡介
Kalen Delanay世界知名的SQL Server專家。微軟SQLSewer MVP。從1 987年供職Sybase時與微軟合作開發最早的SQL Server版本算起。她的SQL Sewer研發經驗已達20多年。她本人以對SQL Server底層技術的精湛造詣享譽業內。所著Inside Microsoft SQL Server系列（本書前身）長期以來被奉為圣經級著作。 Paul S．Randal和KJmberly L．Tripp夫婦世界知名的SQL Server專家。微軟SQL Sewer MVP。他們都曾長期效力于微軟SQL Sewer開發團隊。Randal更是在SQL Sewer多個版本中負責存儲引擎的開發。 Conor Cunningham目前擔任SQL Sewerver引擎主架構師。負責下一代引擎的設計和開發。Adam Machanic世界知名的SQL Server專家。微軟SQL Server MVP。著名社區SQLblog．com創始人。名著《SQL Sewer 2005編程藝術》的作者。 Ben Nevarez資深D8A。有多年SQL Sewer管理經驗。
書友推薦
- >
唐代進士錄
- >
經典常談
- >
莉莉和章魚
- >
我與地壇
- >
新文學天穹兩巨星--魯迅與胡適/紅燭學術叢書(紅燭學術叢書)
- >
李白與唐代文化
- >
煙與鏡
- >
企鵝口袋書系列·偉大的思想20:論自然選擇(英漢雙語)
本類暢銷
