Community developer events

Advanced TSQL in SQL Server 2000 - 2008

Date
Tue, 30 Sep 2008, 09:00 - 16:45 (Add to calendar) GMT
Venue
St. Leonards's Hall , Edinburgh, GB
Cost
£200
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.

Comments

  1. 01 Jan 1999 at 00:00

    This thread is for discussions of Advanced TSQL in SQL Server 2000 - 2008.

Leave a comment

Sign in or Join us (it's free).

Map

Other nearby events

  • Feb 25

    Microsoft and Black Marble present Visual Studio 2010 and Managing the Application Lifecycle with TFS

    2km away in Edinburgh

    Welcome to the Microsoft/Black Marble exploration of developer tools and application lifecycle management, now taking place in Edinburgh. Come along and find out how Microsoft's Developer Tools are changing as well as how Team Foundation Server, Best Practice and Testing can be implemented to help your business manage its application lifecycle successfully.

  • Mar 17

    Web Application Testing With Selenium

    37km away in Dundee

    The TalkTesting is a fundamental part of the development process regardless of how you approach it however GUI's have always been trickier to test and web based UI's are some of the hardest. JavaScript, AJAX and browser compatibility are all things that make web UI functionality quite difficult and time consuming to test properly.Enter Selenium, a web application testing framework which makes the creation and automation of complex web user interface tests a joy.

Related podcasts

  • Stack Overflow: Podcast #28

    This is the twenty-eighth episode of the StackOverflow podcast, where Joel and Jeff discuss Windows Azure, SQL Server 2008 full text search, Bayesian filtering, porn detection, and project management — among other things. Jeff met the inestimable Joey DeVilla aka Accordion Guy...

Want to stay in touch with what's going on? Follow us on twitter!