This month my good friend Greg Low will be presenting a session on Avoiding Stored Procedure Recompiles.
In this session, Greg will describe the process by which SQL Server executes stored procedures and how it decides whether or not recompilations are necessary. He will discuss how to monitor recompilations and explain in detail the specific triggers that cause recompilation. Greg will then discuss techniques to be used when writing database code to help avoid the need for recompilations and to help keep systems performing well.
About the Presenter
Greg is an internationally recognised consultant, developer and trainer. He has been working in development since 1978, holds a PhD in Computer Science and a host of Microsoft certifications. Greg is the country lead for Solid Quality, a SQL Server MVP and one of only three Microsoft Regional Directors for Australia. Greg also hosts the popular SQL Down Under podcast (http://www.sqldownunder.com), organises the SQL Down Under Code Camp and co-organises CodeCampOz. He is a board member of PASS (the Professional Association for SQL Server).
WHERE Microsoft Brisbane Office, Level 9, Waterfront Place, 1 Eagle Street
WHEN Thursday, 24th July | 5:30PM for a 6:00PM start (finishing at approximately 7:30PM)
The QSSUG website can be found at www.qssug.org and contains a repository of materials from past meetings as well as details of upcoming meetings. Other Australian SQL Server related material can be found at www.sqlserver.org.au.
If you will be attending, please RSVP via email to email@example.com to help us plan refreshments (normally pizzas and drinks).