xREL.v3

Another exquisit release

Pluralsight.SQL.Server.Indexing.for.Performance-XQZT

Title: SQL Server: Indexing for Performance
Publisher: Pluralsight
Iso Size: 1.4G (1454938112 B)
Files: 30F
Date: 09/16/2017

Course #: Pluralsight
Type: data-professional
Published: Fri Sep 15, 2017
Modified: September 15, 2017
URL: www.pluralsight.com/courses/sqlserver-indexing-for-performance
Author: Kimberly Tripp
Duration: 7h 11m
Skill: Intermediate
Exercise:

Installation:
Unpack that shit, mount that shit, run that shit

Notes:
The most important feature in SQL Server when it comes to
getting the required workload performance is probably
indexing. But the indexing possibilities you have can be
bewildering, and it's easy to make the wrong choice,
leading to wasted resources and maybe even worse
performance! In this course, SQL Server: Indexing for
Performance, you'll learn how to correctly choose indexes for
your environment. First, you'll discover how clustered and
nonclustered indexes work and how they are used by SQL Server,
both of which are crucial when choosing the correct indexes to
create. Next you'll explore the tipping point - when an index
can be used or not, the benefits of covering queries, and how to
use the INCLUDE option to more effectively cover queries.
Finally, you'll learn how to use filtered indexes and get an
introduction to index consolidation for effective server
tuning. When you've finished this course, you'll have the
skills and knowledge to start adding and changing indexes in your
environment for better performance!