Advanced TSQL in SQL Server 2000 - 2008

Learn advanced T-SQL techniques to solve complex problems and enhance your database performance. You will also learn how to to review existing T-SQL and optimise it for simplicity and performance.

Optimising your database application is very much like tuning a racing car, you can separate it into a few areas. You can tune the hardware that your database runs on i.e. The road, wheels and shock absorbers. You can tune the structure of your database, i.e. The engine of the car. Finally you can tune how your application uses the database, i.e. the driver.

In this seminar we will focus on optimising the way in which you drive your database. We will touch on some of the other areas of optimisation where we need to.

In racing, different drivers take different racing lines, in SQL Server the same applies. The intent behind a query can be achieved in a number of different ways, some that perform well, some that perform very badly. You will learn in this seminar to identify how queries can be rewritten to achieve the best performance, and simplify them.