I’m going back to speak in St. Louis next month. I didn’t make it last year and I’m looking forward to it. You can find additional details on the St. Louis SQL Server user group web site. The meeting will be held at the Microsoft office and I’ll be speaking at 1PM.
I’ll be speaking on the procedure cache. As people get better and better tuning queries this is the next major piece to understand. We’ll talk about how and when query plans are reused. The most common issue I see around odd query plans are stored procedures that use one query plan but the queries run completely different when you extract the SQL and hard code the parameters. That’s just one of the common issues that I’ll address.
There will be a second speaker after I’m done, then a short vendor presentation and a drawing for a netbook.