Expert Performance Indexing in Azure SQL and SQL Server 2022, 4th Edition
Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud
| Price | $54.54 - $74.70
|
| Rating |  |
| Authors | Edward Pollack, Jason Strate |
| Publisher | Apress |
| Published | 2023 |
| Pages | 638 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484292146 |
| ISBN-13 | 9781484292143 |
Take a deep dive into perhaps the single most important facet of query performance - indexes - and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other updates to help you optimize query execution and make performance improvements to even the most challenging workloads.
The book begins with explanations of the types of indexes and how they are stored in a database. Moving further into the book, you will learn how statistics are critical for optimal index usage and how the Index Advisor can assist in reviewing and optimizing index health. This book helps you build a clear understanding of how indexes work, how to implement and use them, and the many options available to tame even the most large and complex workloads.
- Edward Pollack (3 books)
- Jason Strate (3 books)
Similar Books
SQL Queries for Mere Mortals, 4th Edition 
by John L. Viescas
SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.Step by step, Viescas guides you through creating re...
Price: $18.13 | Publisher: Addison-Wesley | Release: 2018
PHP and MySQL Web Development, 4th Edition
by Luke Welling, Laura Thomson
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Int...
Price: $5.96 | Publisher: Addison-Wesley | Release: 2008
Internet, Phone, Mail, and Mixed-Mode Surveys, 4th Edition
by Don A. Dillman, Jolene D. Smyth, Leah Melani Christian
For over two decades, Dillman's classic text on survey design has aided both students and professionals in effectively planning and conducting mail, telephone, and, more recently, Internet surveys. The new edition is thoroughly updated and revised, and covers all aspects of survey research. It features expanded coverage of mobile pho...
Price: $50.00 | Publisher: Wiley | Release: 2014
Expert Performance Indexing in SQL Server, 2nd Edition
by Grant Fritchey, Jason Strate
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 ar...
Price: $56.42 | Publisher: Apress | Release: 2015
by Philip Seamark, Thomas Martens
Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI—Microsoft's leading self-service business intelligence application—and covers other products such as PowerPivot and SQL Serve...
Price: $30.08 | Publisher: Apress | Release: 2019
Machine Learning in the Oil and Gas Industry
by Yogendra Narayan Pandey, Ayush Rastogi, Sribharath Kainkaryam, Srimoyee Bhattacharya, Luigi Saputelli
Apply machine and deep learning to solve some of the challenges in the oil and gas industry. The book begins with a brief discussion of the oil and gas exploration and production life cycle in the context of data flow through the different stages of industry operations. This leads to a survey of some interesting problems, which are good c...
Price: $29.86 | Publisher: Apress | Release: 2020
by Kathi Kellenberger, Lee Everest
Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the WideWorldImporters database...
Price: $44.99 | Publisher: Apress | Release: 2021
by Chaminda Chandrasekara, Pushpa Herath
Understand and explore the features and management of Azure Boards with this book, which also covers Azure Boards configuration and advanced administration. This book starts by setting up projects with Azure DevOps and gives an overview of Azure Boards and its features. You will then learn to set up team projects and how to effectively us...
Price: $44.99 | Publisher: Apress | Release: 2019