Browse by Tags

• books
• indexes
• metadata
• query plans
• training

• Geek City: Plan Caching Internals

  This Friday is the last of my summer seminars. On August 27, I am presenting on plan caching, plan reuse and recompile and plan cache metadata. This is one of my favorite topics to talk about, because a lot of the information is not very widely known, Read More... Posted Monday, August 23, 2010 11:04 AM by Kalen Delaney | 0 Comments Filed under: training, metadata, plan cache, seminars, query plans

• Did You Know? I'm doing 3 more online seminars with SSWUG!

  As I told you in April , I recorded two more seminars with Stephen Wynkoop, on aspects of Query Processing. The first one will be broadcast on June 30 and the second on August 27. In between, we'll broadcast my Index Internals seminar, on July 23. Workshops Read More... Posted Friday, June 11, 2010 4:46 PM by Kalen Delaney | 2 Comments Filed under: training, plan cache, indexes, seminars, query plans

• Did You Know? More online seminars!

  I am in Tucson again, having just recorded two more online workshops to be broadcast by SSWUG. We haven't set the dates yet, but we are thinking about offering a special package deal for the two of them. The topics really are related and I think they Read More... Posted Thursday, April 22, 2010 5:20 PM by Kalen Delaney | 2 Comments Filed under: training, books, plan cache, seminars, query plans

• Geek City: Reducing Cache Bloat and a Metadata Bug

  I've been running some tests with the new SQL Server 2008 configuration option 'optimize for ad hoc workloads' which is intended to reduce cache bloat due to holding onto plans for single use ad hoc queries. This option will allow a new type of cached Read More... Posted Wednesday, October 29, 2008 5:43 PM by Kalen Delaney | 1 Comments Filed under: metadata, plan cache, seminars