This event is now over

Event Details

About

Pre-Con Code PRECON004
Pre-Con Title Plan-first Querying – Writing Queries to Suit the Optimizer
Track(s) Database Development/Administration
Trainer Rob Farley
Abstract

This day-long seminar takes a different approach to T-SQL, by teaching you to cater for what the Query Optimizer is doing.
The Query Optimizer turns your T-SQL query into a program known as a query plan, which runs to produce the data you’ve requested. GROUP BY does grouping, but the plan can choose a few different ways to do that. ON, WHERE and HAVING all filter, but the physical implementations can be identical or vastly different, depending on many other factors.
When you were taught to write T-SQL, you learned about how to create queries that are logically correct to produce the results you want. You were probably taught about using indexes, and other techniques for tuning, but not about Hash Aggregates, Spools, or Parallelism.
In this seminar, you will learn to write queries that produce the plans you want, and identify how particular query plan operators can help or hinder the performance of your queries, to give the kind of performance you should expect.

Modules/Topics
  • Reading & Evaluating SQL Plans
  • Query rewrites
  • Simplification
  • Base Rows
  • Join & Aggregate Types
  • Seek Order & Sort Order
Key Takeaways
  • Understand how plan components work, so that you can see what the plan is doing
  • Think of the plan you want, then write the T-SQL to suit the plan
  • Get a feel for why the plan doesn’t look the way you expect, and adapt if necessary
  • Understand the relationship between the T-SQL you write, the indexes and statistics in place, and what the Query Optimizer will give you
Demos

 

What Is Included?
  • Level 300-400, exclusive content from Rob Farley
  • Gain real-world knowledge, get real-world exposure packed with real-world demos and examples
  • Get your own copy of course material developed by Rob Farley
  • 8 hours of interaction with the Master
  • Lunch, Snacks, Tea/Coffee & loads of fun!
  • And may be some surprise goodies!!
Date August 16, 2017
Time 9:00 am to 5:00 pm IST
Duration 8 hours
Location Davanam Sarovar Portico Suites
(4 Star Deluxe Suite Hotel)
Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068
(Near Silk Board)


List Price

        

Until July 20, 2017

7, 500 + 18% GST

= 8, 850

July 21 – 31, 2017

8, 500 + 18% GST = 10, 030

August 1 – 10, 2017

9, 500 + 18% GST = 11, 210

August 11 – 16, 2017

10, 500 + 18% GST = 12, 390

PS: Prices might change without any prior notice

Contact

admin@sqlservergeeks.com

www.dps2017.com

Venue

Davanam Sarovar Portico Suites
Hosur Main Road, Opp Madiwala Police station
Near Silk Board
Bangalore, Karnataka
India

Map