30/11/2006 5:52:13 PM
Other than initial design & coding issues, designing indexes is the most crucial step toward achieving high levels of database performance. Managing indexes is also critical to maintain performance on an on-going basis.
In this session, local SQL Server MVP Greg Linwood describes precisely how indexes work, how they should be designed to maximise query performance (both retrieval and update) and how to manage them effectively.
In addition, some well established industry "best practices" will be challenged, providing some potentially new ideas even for the experienced database professional.
Greg Linwood is the Managing Director of "SQL Servants" - a dedicated Australian SQL Server infrastructure support business and also Australian Director of "Solid Quality Learning" - the world's leading provider of expert SQL Server training. Greg has worked in a range of developer & DBA capacities with SQL Server since 1993 and first received Microsoft’s SQL Server MVP award in 2003. He has gained significant expertise in SQL Server tuning & optimisation techniques and most of his professional time is currently spent tuning various customer SQL Server systems. Greg is passionate about building high quality SQL Server community events in Australia and is one of the founders of the Australian SQL Server User Group.
Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney |
Duration Duration 5:30pm Dinner - Session 6pm until 8pm |
On: Tuesday, 5 December 2006