Home   Schulung > EDV > Backoffice > SQL Server

This course covers all the possible indexing features in SQL Server, with in-depth, expert explanation of their internal structure and working. It covers in detail, how SQL Server optimizes the queries, how exactly Query Optimizer decides whether some index will be used or not, and how to design and tune the indexes to gain the best possible performance. It also deals with the most frequent mistakes and myths about indexing, and the performance impact of indexes on the system. Delegates will discover everything not only about the classic, relational indexes, but also about full-text, XML and spatial indexes, and their benefits. Upon successful completion of this course, students will be able to: - Describe, how exactly SQL Server uses indexes and how not - Which indexes are the best fit for which scenario - Design and implement the most efficient indexing structures for their systems - Improve the existing indexes in their systems - Solve problems with the indexes - Maintain the indexes for the best possible long-term performance - Employ advanced indexing techniques to get even more performance gains - Search texts and documents efficiently using full-text indexes - Implement XML and spatial indexes

Microsoft Design and Tuning of Indexes in SQL Server 2008/R2

Ziel
This course covers all the possible indexing features in SQL Server, with in-depth, expert explanation of their internal structure and working. It covers in detail, how SQL Server optimizes the queries, how exactly Query Optimizer decides whether some index will be used or not, and how to design and tune the indexes to gain the best possible performance. It also deals with the most frequent mistakes and myths about indexing, and the performance impact of indexes on the system. Delegates will discover everything not only about the classic, relational indexes, but also about full-text, XML and spatial indexes, and their benefits. Upon successful completion of this course, students will be able to:- Describe, how exactly SQL Server uses indexes and how not- Which indexes are the best fit for which scenario- Design and implement the most efficient indexing structures for their systems- Improve the existing indexes in their systems- Solve problems with the indexes- Maintain the indexes for the best possible long-term performance- Employ advanced indexing techniques to get even more performance gains- Search texts and documents efficiently using full-text indexes- Implement XML and spatial indexes
Schulungsinhalte


· Classic Indexes
How SQL Server does(n’t) use indexes . Clustered vs. nonclustered indexes . Internal structure of indexes . Index statistics, internal structure and its usage . Covering vs. Composite indexes . Quickly finding the missing and redundant indexes . Impact of indexes on system performance .Consolidation of indexes . Defragmentation and reorganization of indexes

· Advanced Indexing
Filtered indexes . Indexed (materialized) views . Indexing aggregates . Indexing functions and expressions . Index bitmaps . Index joins . Star Join Query Optimization . Optimization of statistics, filtered statistics . Little known ways of using indexes to optimize queries . Partitioning of indexes . Recommendations from the practice

· Full-text Indexes
Advantages over classic indexes . Creating and managing full-text indexes . Indexing texts and binary documents . Querying the full-text . Accelerating the LIKE operator by replacing it with full-text . Simulation of Google search using the full-text. Troubleshooting problems with full-text . Extending the full-text . Optional: New full-text features in SQL Server 2012

· Other Indexes
XML indexes . Spatial (geographic and geometric) indexes . Optional: Columnstore indexes in SQL Server 2012 .
Zielgruppe
Database professionals and developers deeply interested into the in-depth coverage of all SQL Server indexes, their proper design, implementation and performance tuning.
Voraussetzungen
Fundamentals in SQL querying and application development.
Ausschließlich als Inhouse-Schulung
Dieses Seminar bieten wir ausschließlich als Inhouse-Seminar in Ihren Räumlichkeiten oder bei uns in Münster an.
Seminardaten
Schulung-Nrdeatuind
Dauer2 Tage
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren Räumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung

Aktuelle Termine
Mo, 05.12.2016 - Fr, 09.12.2016, Aachen
Garantierte DurchführungProgrammieren mit VB.NET 2015
Mo, 05.12.2016 - Fr, 09.12.2016, Münster
Webentwicklung mit HTML, CSS, JavaScript, jQuery und PHP
Garantierte Durchführung Garantierte Durchführung!