Expert Performance Indexing in SQL Server, 2nd Edition



Bookstore > Books > Expert Performance Indexing in SQL Server, 2nd Edition

Price$49.99 - $60.74
Rating
AuthorsGrant Fritchey, Jason Strate
PublisherApress
Published2015
Pages432
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484211197
ISBN-139781484211199
EBook Hardcover Paperback

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.


  1. (5 books)
  2. (2 books)



Similar Books


Securing SQL Server, 2nd Edition

Securing SQL Server, 2nd Edition

by Peter A. Carter

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and countermeasures, and provides an introduction to compliance that is useful for meeting regulatory requirements such as the GDPR. The multi-layered...

Price:  $29.47  |  Publisher:  Apress  |  Release:  2018

Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012

by Jason Strate, Ted Krueger

Expert Performance Indexing for SQL Server 2012 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, y...

Price:  $24.70  |  Publisher:  Apress  |  Release:  2012

Dynamic SQL, 2nd Edition

Dynamic SQL, 2nd Edition

by Edward Pollack

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to impro...

Price:  $30.40  |  Publisher:  Apress  |  Release:  2019

Expert T-SQL Window Functions in SQL Server

Expert T-SQL Window Functions in SQL Server

by Kathi Kellenberger, Clayton Groom

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window...

Price:  $23.82  |  Publisher:  Apress  |  Release:  2015

Data Science with SQL Server Quick Start Guide

Data Science with SQL Server Quick Start Guide

by Dejan Sarka

SQL Server only started to fully support data science with its two most recent editions. If you are a professional from both worlds, SQL Server and data science, and interested in using SQL Server and Machine Learning (ML) Services for your projects, then this is the ideal book for you.This book is the ideal introduction to data science w...

Price:  $34.99  |  Publisher:  Packt Publishing  |  Release:  2018

What's New in SQL Server 2012

What's New in SQL Server 2012

by Rachel Clements, Jon Reade

Microsoft SQL Server has been part of the enterprise database landscape since SQL Server 7 arrived in 1998 and has evolved into the relational and BI platform of choice by businesses around the globe. The performance and full feature set of SQL Server has been widely recognized by the business community and it is viewed as a powerful weap...

Price:  $20.99  |  Publisher:  Packt Publishing  |  Release:  2012

Beginning SQL Server Modeling

Beginning SQL Server Modeling

by Bart Weller

Beginning SQL Server Modeling will help you gain a comprehensive understanding of how to apply DSLs and other modeling components in the development of SQL Server implementations. Most importantly, after reading the book and working through the examples, you will have considerable experience using SQL Modeling components, because the book...

Price:  $17.99  |  Publisher:  Apress  |  Release:  2010

Nginx HTTP Server, 2nd Edition

Nginx HTTP Server, 2nd Edition

by Clement Nedelcu

Nginx is a lightweight HTTP server designed for high-traffic websites, with network scalability as the primary objective. With the advent of high speed Internet access, short loading times and fast transfer rates have become a necessity. This free, open source solution will either come as a full replacement of other software such as Apach...

Price:  $26.99  |  Publisher:  Packt Publishing  |  Release:  2013