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
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.
Map
Other nearby events
-
Nov
25
Lean, Kanban and Theory of Constraints
37km away in Dundee
The TalkThe application of Lean principles, Kanban and pull-systems theory along with Goldratt's Theory of Constraints revolutionised the manufacturing world in the second half of the twentieth century. Belatedly, the software world is waking up to the transformative effects these tools can have. There are still no silver bullets in the software world, but that doesn't mean that we can't improve our aim.
-
Nov
25
VBUG NEWCASTLE: SysInternals Tools
90km away in Newcastle-upon-Tyne
Following on from his very well received presentation on Windows performance monitoring and analysis at our September meeting, Richard Diver returns t
-
Dec
9
VBUG NEWCASTLE: Windows AZURE - What's In The Cloud?
90km away in Newcastle-upon-Tyne
Microsoft are due to release the first version of Windows Azure at the Professional Developers Conference in November 2009, this session will look at
-
Dec
17
SuperChristmas in Newcastle
92km away in Newcastle-upon-Tyne
In partnership with SuperMondays, Thursday Fizz, Girl Geeks, and Refresh Teesside, VBUG are proud to announce: SuperChristmas is the Christmas par
Related discussion
-
High-Performance .NET Application Development & Architecture
by Manjot Bawa (0 replies)
-
VS.NET/sql server installation problem
by daspeac (4 replies)
-
Research topic in software
by reachsangeethamathew (0 replies)
-
Error Msg Description ?
by morizan (0 replies)
-
How to Change Default exe Icon in C#.net Windows Application
by sonali.terse (2 replies)
Related articles
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...
This thread is for discussions of Advanced TSQL in SQL Server 2000 - 2008.