Expert performance indexing in SQL server / (Record no. 381334)
[ view plain ]
000 -LEADER | |
---|---|
fixed length control field | 02117cam a22003497i 4500 |
001 - CONTROL NUMBER | |
control field | 19232077 |
003 - CONTROL NUMBER IDENTIFIER | |
control field | APU |
005 - DATE AND TIME OF LATEST TRANSACTION | |
control field | 20180531140433.0 |
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
fixed length control field | 160816t20152015nyua 001 0 eng d |
010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
LC control number | 2016439367 |
020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
International Standard Book Number | 9781484211199 (pbk.) |
035 ## - SYSTEM CONTROL NUMBER | |
System control number | (OCoLC)ocn921187576 |
040 ## - CATALOGING SOURCE | |
Original cataloging agency | YDXCP |
Language of cataloging | eng |
Transcribing agency | YDXCP |
Modifying agency | WAN |
042 ## - AUTHENTICATION CODE | |
Authentication code | lccopycat |
050 00 - LIBRARY OF CONGRESS CALL NUMBER | |
Classification number | QA76.9.D3 |
Item number | S77 2015 |
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
Classification number | 005.7/585 |
Edition number | 23 |
100 1# - MAIN ENTRY--PERSONAL NAME | |
Personal name | Strate, Jason. |
9 (RLIN) | 38337 |
245 10 - TITLE STATEMENT | |
Title | Expert performance indexing in SQL server / |
Statement of responsibility, etc | Jason Strate, Grant Fritchey. |
250 ## - EDITION STATEMENT | |
Edition statement | 2nd ed. |
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
Place of publication, distribution, etc | [New York] : |
Name of publisher, distributor, etc | Apress, |
Date of publication, distribution, etc | 2015. |
300 ## - PHYSICAL DESCRIPTION | |
Extent | xxiii, 403 p. : |
Other physical details | ill. ; |
Dimensions | 26 cm |
500 ## - GENERAL NOTE | |
General note | Includes index. |
505 0# - FORMATTED CONTENTS NOTE | |
Formatted contents note | Index fundamentals -- Index storage fundamentals -- Index metadata and statistics -- XML indexes -- Spatial indexing -- Full-text indexing -- Indexing memory-optimized tables -- Indexing myths and best practices -- Index maintenance -- Indexing tools -- Indexing strategies -- Query strategies -- Monitoring indexes -- Index analysis -- Indexing methodology. |
520 ## - SUMMARY, ETC. | |
Summary, etc | "This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You'll better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. The final destination is a guided tour through a number of real life scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database"--Back cover. |
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE | |
Uniform title | SQL server. |
9 (RLIN) | 616 |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
Topical term or geographic name as entry element | Database management. |
9 (RLIN) | 124 |
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
Topical term or geographic name as entry element | SQL (Computer program language) |
9 (RLIN) | 13 |
700 1# - ADDED ENTRY--PERSONAL NAME | |
Personal name | Fritchey, Grant. |
9 (RLIN) | 38338 |
906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) | |
a | 7 |
b | cbc |
c | copycat |
d | 2 |
e | ncip |
f | 20 |
g | y-gencatlg |
942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
Source of classification or shelving scheme | |
Koha item type | Book |
Withdrawn status | Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Collection code | Home library | Current library | Shelving location | Date acquired | Source of acquisition | Invoice number | Cost, normal purchase price | Total Checkouts | Total Renewals | Full call number | Barcode | Date last seen | Date checked out | Copy number | Cost, replacement price | Price effective from | Koha item type | PO number |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Not Withdrawn | Available | Not Damaged | Available for loan | Book | APU Library | APU Library | Open Shelf | 27/04/2018 | EMO | I-021320 | 158.10 | 1 | 8 | QA76.9.D3 S77 2015 c.1 | 00012008 | 24/11/2021 | 12/09/2018 | 1 | 158.10 | 27/04/2018 | Staff Circulation | U-2018/04/0811 | |
Not Withdrawn | Available | Not Damaged | Available for loan | Book | APU Library | APU Library | Open Shelf | 27/04/2018 | EMO | I-021320 | 158.10 | QA76.9.D3 S77 2015 c.2 | 00012009 | 27/04/2018 | 2 | 158.10 | 27/04/2018 | General Circulation | U-2018/04/0811 |