LEADER 03299nam 22006255 450 001 9910300637703321 005 20200706002730.0 010 $a9781484211182 010 $a1484211189 024 7 $a10.1007/978-1-4842-1118-2 035 $a(CKB)3710000000514071 035 $a(EBL)4091395 035 $a(SSID)ssj0001585105 035 $a(PQKBManifestationID)16262965 035 $a(PQKBTitleCode)TC0001585105 035 $a(PQKBWorkID)14866321 035 $a(PQKB)10260229 035 $a(DE-He213)978-1-4842-1118-2 035 $a(MiAaPQ)EBC4091395 035 $a(CaSebORM)9781484211182 035 $a(PPN)18976659X 035 $a(OCoLC)930869236 035 $a(OCoLC)ocn930869236 035 $a(EXLCZ)993710000000514071 100 $a20151111d2015 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExpert Performance Indexing in SQL Server /$fby Jason Strate, Grant Fritchey 205 $a2nd ed. 2015. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2015. 215 $a1 online resource (415 p.) 225 1 $aExpert's Voice in SQL Server 300 $aIncludes index. 311 08$a9781484211199 311 08$a1484211197 327 $aIndex 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. 330 $aThis 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. Defines the types of indexes and their implementation options Provides use cases and common patterns in applying indexing Describes and explain the index metadata and statistics Provides a framework of strategies and approaches for indexing databases. 410 0$aExpert's voice in SQL server. 517 3 $aExpert performance indexing in Structured Query Language server 606 $aDatabase management 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 615 0$aDatabase management. 615 14$aDatabase Management. 676 $a004 700 $aStrate$b Jason$4aut$4http://id.loc.gov/vocabulary/relators/aut$0935388 702 $aFritchey$b Grant$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300637703321 996 $aExpert Performance Indexing in SQL Server$92106966 997 $aUNINA