$150

SQL Server Query Performance Tuning

Event Information

Share this event

Date and Time

Location

Location

Hilton Garden Inn Albany/SUNY Area

1389 Washington Ave

Albany, NY 12206

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

Abstract

You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what?
In this pre-conference session we will analyze common use cases of poorly performing queries, such as the improper use of scalar functions, inaccurate statistics and bad impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques.
The topics in this session are relevant for SQL Server versions 2005 through 2016. We will also demonstrate some of the new features introduced in SQL Server 2016. At the end of the session, you'll have a list of tips and techniques to apply in your environment.

Outline

• Analyzing Execution Plans

• Search Arguments

• Data Type Issues

• Indexes Best Practices

• Temporary Tables vs. Table Variables

• (Not) Using Cursors

• (Not) Using Scalar Functions

• Working with Parameters and Variables

• Skewed Data Distribution

• Window Functions

• LOB Data

• Manipulating Hierarchies

• Row Identifiers

• Manipulating Statistics

• And More, As Time Permits…

Session Prerequisites

• Basic Experience with Database Design

• Experience with T-SQL Programming

• Basic Experience with SQL Server Troubleshooting

Session Goals

1. Learn how to interpret and analyze execution plans and avoid common mistakes
2. Understand why some features, such as cursors and scalar functions, can be performance killers, and learn how to avoid them but still maintain good programming techniques
3. Understand parameter sniffing, when it's good and when it's bad, and also be able to troubleshoot performance problems caused by bad impact of parameter sniffing.

Event Schedule/Logistics

8:00 am - 8:30 am : Breakfast & check-in

8:30 am - 12:00 pm : Precon (morning session)

12:00 pm - 1:00 pm : Lunch

1:00pm - 5:00 pm : Precon (afternoon session)

Breakfast and lunch are both provided by the hotel as part of your registration. Vegetarian options are included in the menu. Other dietary requests will be provided upon request by attendees.

Share with friends

Date and Time

Location

Hilton Garden Inn Albany/SUNY Area

1389 Washington Ave

Albany, NY 12206

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved