4/10/2006 12:13:02 PM
Recompilation of stored procedures can introduce performance penalties in SQL Server. In this session, Greg will cover what causes stored procedures to be recompiled, how this has changed from SQL Server 2000 and how to minimise the impact of this. He'll also cover caching of ad-hoc query batches.
Dr Greg Low is an internationally-recognised consultant and trainer. He has worked as a developer since the early 1980s and is widely known in the Australian developer community. He has trained developers, database administrators and engineers within Australia and in many other countries. He is also one of only two Microsoft Regional directors in Australia.
Venue: Mechanics' School of Arts, Level 3, 280 Pitt St, Sydney *** NEW LOCATION*** |
Duration Duration 5:30pm Food - Session 6pm until 8pm |
On: Tuesday, May 2, 2006