國立高雄大學圖資館 |

Language: English

Back

Pro SQL server internals

Korotkevitch, Dmitri.

Pro SQL server internals

Record Type:	Electronic resources : Monograph/item
Title/Author:	Pro SQL server internalsby Dmitri Korotkevitch.
Author:	Korotkevitch, Dmitri.
Published:	Berkeley, CA :Apress :2016.
Description:	xxxi, 804 p. :ill., digital ;24 cm.
Contained By:	Springer eBooks
Subject:	Computer Science.
Online resource:	http://dx.doi.org/10.1007/978-1-4842-1964-5
ISBN:	9781484219645$q(electronic bk.)

Pro SQL server internals
Korotkevitch, Dmitri.

Pro SQL server internals[electronic resource] /by Dmitri Korotkevitch. - 2nd ed. - Berkeley, CA :Apress :2016. - xxxi, 804 p. :ill., digital ;24 cm.

Part 1: Tables and Indexes -- 1. Data Storage Internals -- 2. Tables and Indexes -- 3. Statistics -- 4. Special Indexing and Storage Features -- 5. SQL Server 2016 Enhancements -- 6. Index Fragmentation -- 7. Designing and Tuning the Indexes -- Part 2: Other Things That Matter -- 8. Constraints -- 9. Triggers -- 10. Views -- 11. Functions -- 12. XML and JSON -- 13. Temporary Tables and TempDB -- 14. CLR -- 15. CLR Types -- 16. Data Partitioning -- Part 3: Locking, Blocking and Concurrency -- 17. Lock Types and Transaction Isolation Levels -- 18. Troubleshooting Blocking Issues -- 19. Deadlocks -- 20. Lock Escalations -- 21. Optimistic Isolation Levels -- 22. Application Locks -- 23. Schema Locks -- 24. Designing Transaction Strategies -- Part 4: Query Life Cycle -- 25. Query Optimization and Execution -- 26. Plan Caching -- Part 5: Practical Troubleshooting -- 27. System Troubleshooting -- 28. Extended events -- 29. Query Store -- Part 6: Inside the Transaction Log -- 30. Transaction Log Internals -- 31. Backup and Restore -- 32. High Availability Technologies -- Part 7: In-Memory OLTP Engine -- 33. Column-Based Storage and Batch Mode Execution -- 34. Columnstore Indexes -- Part 8: In-Memory OLTP Engine -- 35. In-Memory OLTP Internals -- 36. Transaction Processing in In-Memory OLTP -- 37. In-Memory OLTP Programmability.

ISBN: 9781484219645$q(electronic bk.)

Standard No.: 10.1007/978-1-4842-1964-5doiSubjects--Uniform Titles:

SQL server.
Subjects--Topical Terms:

212513
Computer Science.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.7585

Pro SQL server internals
LDR:02306nmm a2200325 a 4500 001 500112
003 DE-He213
005 20161130134536.0
006 m d
007 cr nn 008maaau
008 170621s2016 cau s 0 eng d
020 $a 9781484219645$q(electronic bk.)
020 $a 9781484219638$q(paper)
024 7 $a 10.1007/978-1-4842-1964-5 $2 doi
035 $a 978-1-4842-1964-5
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a UMT $2 bicssc
072 7 $a COM021000 $2 bisacsh
082 0 4 $a 005.7585 $2 23
090 $a QA76.9.D3 $b K84 2016
100 1 $a Korotkevitch, Dmitri. $3 683436
245 1 0 $a Pro SQL server internals $h [electronic resource] / $c by Dmitri Korotkevitch.
250 $a 2nd ed.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2016.
300 $a xxxi, 804 p. : $b ill., digital ; $c 24 cm.
505 0 $a Part 1: Tables and Indexes -- 1. Data Storage Internals -- 2. Tables and Indexes -- 3. Statistics -- 4. Special Indexing and Storage Features -- 5. SQL Server 2016 Enhancements -- 6. Index Fragmentation -- 7. Designing and Tuning the Indexes -- Part 2: Other Things That Matter -- 8. Constraints -- 9. Triggers -- 10. Views -- 11. Functions -- 12. XML and JSON -- 13. Temporary Tables and TempDB -- 14. CLR -- 15. CLR Types -- 16. Data Partitioning -- Part 3: Locking, Blocking and Concurrency -- 17. Lock Types and Transaction Isolation Levels -- 18. Troubleshooting Blocking Issues -- 19. Deadlocks -- 20. Lock Escalations -- 21. Optimistic Isolation Levels -- 22. Application Locks -- 23. Schema Locks -- 24. Designing Transaction Strategies -- Part 4: Query Life Cycle -- 25. Query Optimization and Execution -- 26. Plan Caching -- Part 5: Practical Troubleshooting -- 27. System Troubleshooting -- 28. Extended events -- 29. Query Store -- Part 6: Inside the Transaction Log -- 30. Transaction Log Internals -- 31. Backup and Restore -- 32. High Availability Technologies -- Part 7: In-Memory OLTP Engine -- 33. Column-Based Storage and Batch Mode Execution -- 34. Columnstore Indexes -- Part 8: In-Memory OLTP Engine -- 35. In-Memory OLTP Internals -- 36. Transaction Processing in In-Memory OLTP -- 37. In-Memory OLTP Programmability.
630 0 0 $a SQL server. $3 199469
650 1 4 $a Computer Science. $3 212513
650 2 4 $a Database Management. $3 273994
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer eBooks
856 4 0 $u http://dx.doi.org/10.1007/978-1-4842-1964-5
950 $a Professional and Applied Computing (Springer-12059)