Skip Main Navigation
Page Content
This event has ended

SQL Saturday #340 PreCon - Index and Query Tuning with Itzik Ben-Gan

SoCal SQL Saturday

Friday, September 19, 2014 from 8:00 AM to 5:00 PM (PDT)

SQL Saturday #340 PreCon - Index and Query Tuning with...

Ticket Information

No tickets available.

Share SQL Saturday #340 PreCon - Index and Query Tuning with Itzik Ben-Gan

Event Details

You are simply not going to want to miss this event.  Itzik is one of the foremost experts on SQL Server and his Pre-Cons and Sessions at PASS are always filled to capacity.  And we are bringing him to your front door.  This event WILL sell out, so do not pass up your chance to buy your ticket for this event.

------------------------------------------------------------------------------------------------------------------

Seminar: Query and Index Tuning

Level: mostly 200; at some points 300.

Abstract:

This seminar provides the foundations for tuning queries and designing a good indexing strategy.

You will learn about the internals of tables and indexes, index access methods, included non-key columns, filtered indexes and statistics, columnstore indexes, inline index definition, prioritizing queries for tuning, and gathering index and query information and statistics.

You will also learn about using temporary tables and table variables for tuning purposes, choosing between relational and iterative solutions, and performing query tuning by applying query revisions.

Prerequisites: Half a year to a year of experience writing and tuning T-SQL queries.

Agenda:

    Internals and Index Tuning
        Table and Index Internals
        Index Access Methods
        Included Non-key Columns
        Filtered Indexes and Statistics
        Columnstore Indexes
        Inline Index Definition
        Prioritizing Queries for Tuning
        Index and Query Information and Statistics
    Temporary Tables
    Sets vs. Cursors
    Query Tuning with Query Revisions
 

Itzik Ben-Gan

http://tsql.solidq.com/about.htm

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Have questions about SQL Saturday #340 PreCon - Index and Query Tuning with Itzik Ben-Gan? Contact SoCal SQL Saturday

When & Where


UC San Diego Extension Digital Arts Center
6256 Greenwich Dr
San Diego, CA 92122

Friday, September 19, 2014 from 8:00 AM to 5:00 PM (PDT)


  Add to my calendar
SQL Saturday #340 PreCon - Index and Query Tuning with Itzik Ben-Gan
San Diego, CA Events Seminar Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.