LEADER 04238nam 22005895 450 001 9910357835703321 005 20200703044754.0 010 $a9781484254646 010 $a1484254643 024 7 $a10.1007/978-1-4842-5464-6 035 $a(CKB)4100000009939808 035 $a(MiAaPQ)EBC5987427 035 $a(DE-He213)978-1-4842-5464-6 035 $a(CaSebORM)9781484254646 035 $a(OCoLC)1140553210 035 $a(OCoLC)on1140553210 035 $a(EXLCZ)994100000009939808 100 $a20191128d2019 u| 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aExpert Performance Indexing in SQL Server 2019 $eToward Faster Results and Lower Maintenance /$fby Jason Strate 205 $a3rd ed. 2019. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2019. 215 $a1 online resource (xxiii, 615 pages) $cillustrations 300 $aPrevious edition published: 2015. 311 08$a9781484254639 311 08$a1484254635 320 $aIncludes bibliographical references. 327 $a1. Index Fundamentals -- 2. Index Storage Fundamentals -- 3. Index Metadata and Statistics -- 4. XML Indexes -- 5. Spatial Indexing -- 6. Indexing Memory-Optimized Tables -- 7. Full-Text Indexing -- 8. Indexing Myths and Best Practices -- 9. Index Maintenance -- 10. Indexing Tools -- 11. Indexing Strategies -- 12. Query Strategies -- 13. Monitoring Indexes -- 14. Index Analysis -- 15. Indexing Methodology. 330 $aTake a deep dive into perhaps the single most important facet of good performance: indexes, and how to best use them. Recent updates to SQL Server have made it possible to create indexes in situations that in the past would have prevented their use. Other improvements covered in this book include new dynamic management views, the ability to pause and resume index maintenance, and the ability to more easily recover from failures during index creation and maintenance operations. This new edition also brings new content around the indexing of columnstore and in-memory tables, showing how these new types of tables and the queries that execute against them can also benefit from good indexing practices. The book begins 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 will better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. You will get a look at the Index Advisor now available in Azure SQL Database, and learn how to review and maintain the health of your indexes. The final chapters present a guided tour through a number of scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database. You will: Properly index row store, columnstore, and in-memory tables Review statistics to understand indexing choices made by the optimizer Apply indexing strategies such as covering indexes, included columns, and index intersections Recognize and remove unnecessary indexes Design effective indexes for full-text, spatial, and XML data types Manage the big picture: Encompass all indexes in a database, and all database instances on a server. 606 $aDatabase management 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 606 $aMicrosoft and .NET$3https://scigraph.springernature.com/ontologies/product-market-codes/I29030 615 0$aDatabase management. 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 14$aDatabase Management. 615 24$aMicrosoft and .NET. 676 $a005.7565 700 $aStrate$b Jason$4aut$4http://id.loc.gov/vocabulary/relators/aut$0935388 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910357835703321 996 $aExpert Performance Indexing in SQL Server 2019$92536868 997 $aUNINA LEADER 02019nas 2200637-a 450 001 9910893060003321 005 20260218111740.0 035 $a(CKB)991042731854500 035 $a(CONSER)---95650403- 035 $a(DE-599)ZDB2605701-3 035 $a(DE-599)2605701-3 035 $a(EXLCZ)99991042731854500 100 $a19950106a19949999 -a- - 101 0 $aita 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 00$aEnergia, ambiente e innovazione 210 $aRoma $cENEA$d1994- 215 $a1 online resource 300 $aTitle from cover. 311 08$aPrint version: Energia, ambiente e innovazione. 1124-0016 (DLC) 95650403 (OCoLC)31775580 606 $aNuclear energy$zItaly$vPeriodicals 606 $aNuclear industry$zItaly$vPeriodicals 606 $aElectric power-plants$vPeriodicals 606 $aEnergy industries$zItaly$vPeriodicals 606 $aEnergie nucléaire$2eclas 606 $aEnergie$2eclas 606 $aIndustrie nucléaire$2eclas 606 $aMensuels$2eclas 606 $aElectric power-plants$2fast$3(OCoLC)fst00905639 606 $aEnergy industries$2fast$3(OCoLC)fst00910110 606 $aNuclear energy$2fast$3(OCoLC)fst01039951 606 $aNuclear industry$2fast$3(OCoLC)fst01040250 607 $aItalie$2eclas 607 $aItaly$2fast 608 $aPeriodicals.$2fast 615 0$aNuclear energy 615 0$aNuclear industry 615 0$aElectric power-plants 615 0$aEnergy industries 615 7$aEnergie nucléaire. 615 7$aEnergie. 615 7$aIndustrie nucléaire. 615 7$aMensuels. 615 7$aElectric power-plants. 615 7$aEnergy industries. 615 7$aNuclear energy. 615 7$aNuclear industry. 676 $a333.79/24/05 712 02$aENEA (Agency : Italy) 906 $aJOURNAL 912 $a9910893060003321 920 $aexl_impl conversion 996 $aEnergia, ambiente e innovazione$9794719 997 $aUNINA