17/03/2005 12:08:56 PM
In April [b]Victor Isakov[/b] [i](MCT, MCSE, MCDBA)[/i] will focus on analysing and optimizing query performance on SQL Server 2000.
This session will look at the optimizer in more detail and the various components of the query plan. The various tools available. The different join types will be discussed. It will conclude with when you should consider over-riding the Optimiser and the various hints available.
Indexing is just as important, as the optimizer ultimately looks at available indexes to generate it's QPs. This session will focus more on index design and trade-offs for optimal T-SQL execution. When should you use composite indexes? What are the implications of columns ordering and data types? What are best practises for covering indexes?
[b]Victor Isakov[/b] [i](email@example.com)[/i] has been involved with SQL Server since Version 4.21a, enjoying a reputation as one of the best [i]"SQL Gurus"[/i] in Australia. He has been an MCT since 1995 and consulted for organisations like the University of NSW, DET (NSW), BT Financial Group, Westpac and the UN. He specialises as a consultant in Architecting, Optimising and Troubleshooting Database Solutions.
Venue: Clifton & Associates (Level 2, 190 George Street, Sydney) |
Duration Pizza - 5:30PM | Session 1 - 6:00PM | Session 2 - 7:00PM (Till 8PM) |
On: Tuesday, 26 April 2005