What

TSQL Performance Tips

TSQL Performance Tips

• Which is better, when and why: LIKE vs SUBSTRING, IN vs EXISTS, SUBQUERY vs JOIN.
• Why doesn't the Query Optimizer do an Index Seek when you'd expect it to.
• Why you should not use the UPPER or LOWER functions.
• How to avoid non-SARG-able WHERE clauses.
• Which query takes about 3 minutes in SQL Server 2008 and only one second in SQL Server 2012?

In this session we will answer these questions and show how bad designed queries lead to poor execution plans.

We will offer recommendations and tips how to avoid performance problems caused by poor query design and explain how local variables and parameters affect the generation of execution plan.

We will discuss and compare different query approaches and operators and give appropriate recommendations.

We'll also cover database constraints from the performance point of view.

When

Thursday 28 June 2012

Gather for food and drinks at 5:45 PM
Presentation starting at 6:10 PM

Where

Why

• Catch up with North Shore .NET User Group members.
• Have a bit of Pizza and a refreshment.
• Learn about Reactive Extensions.

Who

Our speaker is:

Dave Dustin

Dave Dustin. He's just this guy, you know?

In his spare time, Dave is a Certified Microsoft shill, SQL Server MVP and overall pretty normal bloke who'll sit down with you to help diagnose why the query plans on your mission critical application aren't running as you expected. Often for free. If you provide the beer.

http://about.me/DaveDustin

Cost

   Free

Pre-Requisites

   None

Attendance

20

Our Sponsors

The North Shore .NET User Group would like to thank our sponsors, for making this event happen.