Welcome to SQLSaturday #340

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Sep 20 2014 at 6256 Greenwich Dr., San Diego, CA 92122. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.


SQLSaturday #340 Pre-Con!

You are simply not going to want to miss this event.  Itzik Ben-Gan 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.

Link:     Query and Index Tuning with Itzik Ben-Gan


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.



Register

*We do ask that you consider to OPT-IN for the Sponsors of this event. Without their assistance, we cannot bring this FREE event to you. You can always opt-out if and when they contact! Thank you for your consideration.

Click here to view/download event summary in XML format.

Join us on Twitter!

Event News

Event Sponsors

  
  
  
  
  
  
  
  
  
  
  
  
SQLSaturday Home
PASS