Monday, 24 July 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Improving Database Performance thru better queries & design (David Lean)
Author: Grant Paisley Date Posted: 27/09/2010 11:52:08 PM
This will be a fantastic session as Dave is both a skilled presenter, and has a wealth of knowledge for us...

Over the past 20 years (in Microsoft) David has tuned a lot of databases & rewritten a lot of code.

This talk looks at TSQL & some of the techniques / templates he uses. We will examine commonly used TSQL syntax & explore alternatives that run significantly faster.

It will highlight code that seems to produce the correct results but doesn’t always. And touch on some quick preliminary scans that help you categorise the database schema to predict the types of mistakes you are likely to find in its design.


This talk is targeted at entry to medium level folks that write TSQL in code & Stored procedures & want to improve.

If you are a performance tuning god, you might pick up 1 or 2 ideas but more likely you will have seen it all before.


Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) | 6:00PM - 8:00PM Session | On: Tuesday, 12 October 2010