{"product_id":"9781484211182","title":"Expert Performance Indexing in SQL Server","description":"\u003cp\u003eThis 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.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDefines the types of indexes and their implementation options\u003c\/li\u003e\n\u003cli\u003eProvides use cases and common patterns in applying indexing\u003c\/li\u003e\n\u003cli\u003eDescribes and explain the index metadata and statistics\u003c\/li\u003e\n\u003cli\u003eProvides a framework of strategies and approaches for indexing databases\u003cp\u003e\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003eWhat you’ll learn\u003cul\u003e\n\u003cli\u003eProperly index in-memory OLTP tables\u003c\/li\u003e\n\u003cli\u003eRecognize and remove unnecessary indexes\u003c\/li\u003e\n\u003cli\u003eReview statistics to understand indexing choices made by the optimizer\u003c\/li\u003e\n\u003cli\u003eProperly apply strategies such as covering indexes, included columns, index intersections, and more\u003c\/li\u003e\n\u003cli\u003eWrite queries to make good use of the indexes already in place\u003c\/li\u003e\n\u003cli\u003eDesign effective indexes for full-text, spatial, and XML data types\u003c\/li\u003e\n\u003cli\u003eManage the big picture: Encompassing all indexes in a database, and all database instances on a server\u003c\/li\u003e\n\u003c\/ul\u003eWho this book is for      \u003cp\u003e     \u003cem\u003eExpert Performance Indexing in SQL Server \u003c\/em\u003eis intended for database administrators and developers who are ready to lift the performance of their environment by thoughtfully building indexes to speed up the queries that matter the most and make a difference to the business.       \u003c\/p\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47131514437872,"sku":"9781484211182","price":34.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781484211182_p0.jpg?v=1763632003","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781484211182","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}