Asia Pacific University Library catalogue


Expert performance indexing in SQL server / (Record no. 381334)

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
Holdings
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