Advanaced TSQL and performance tuning
It always surprises me
how many ways you can write a query and how the different ways can have an
amazing impact on the performance of your queries. Often unfortunately
the simplest solution doesn't perform the best. I will be running
a training seminar before SQLBits on how you can write your queires and index
your database to get the best performance out of SQL Server. I will also be
focusing on scalability. Its very easy to write a query that runs for one user,
understanding how queries scale is essential to ensuring your application
doesn't grind to a halt when the numbers of users increase.
Most of what I will cover will apply to SQL2000 as well as 2005
and 2008
To register go to http://book.registrationisopen.com/book.aspx?cust=sqlbits&eid=sqlbits20090301ss
Overview
Unlike many languages, SQL is a language where you don't explicitly control
how the code is executed. With SQL you define intent and then the optimiser
builds a query plan based on that. We will look at differing ways in which
queries can be written, and how some of these can have an amazing impact on the
performance and scalability of your system. To achieve this we will look at the
tools we can use to achieve this including profiler, query execution plans and
DMVs
We will extend this knowledge to understand how the optimiser builds
a query plan and how parameters and indexes affect the query plan chosen. This
will give you the knowledge to know when query plan resuse is good and bad, how
to avoid or benefit from parameter sniffing and ultimately write queries that
perform better.
Why Attend
After attending this course you will understand how you can write your
queries and index your tables to get the best performance.
Topics
Understanding Resources
Diagnosing performance
- Profiler
- Query Execution plans
- Dynamic Management Views
- Perfmon
Advanced TSQL
- Dynamic search conditions
- Ranking functions
- Windowed aggregates
- Use of cursors
- Scalar functions
To register go to http://book.registrationisopen.com/book.aspx?cust=sqlbits&eid=sqlbits20090301ss
-