October 2008 - Posts

• Geek City: Clearing a Single Plan From Cache in SQL Server 2008

  I just today found out about something that was in plain sight in the Books Online... but the documentation is so vast, I haven't discovered everything yet. I blogged about clearing a single plan from cache in SQL Server 2005 a while back, and mentioned Read More... Posted Friday, October 31, 2008 5:43 PM by Kalen Delaney | 4 Comments Filed under: metadata, plan cache, SQL Server 2008

• Did You Know: I am now the sole distributor of my DVDs

  I've had several posts about my DVDs, which I'm sure have aggravated Steve Dassin enormously. Way back in June, I told you that I had to break off from my DVD producer and just this week, I finally received all the remaining DVDs. They showed up on my Read More... Posted Thursday, October 30, 2008 2:29 PM by Kalen Delaney | 8 Comments Filed under: DVD, internals

• 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

• Did You Know? You Can Win a Copy of My Next Book!

  November is conference month for me, and I'll be giving away vouchers for signed copies of my new book, to be mailed to the winners as soon as I receive my author copies. I'll be giving away one each day of my seminars in London and Seattle! The London Read More... Posted Friday, October 24, 2008 9:09 PM by Kalen Delaney | 3 Comments Filed under: books, seminars

• Geek City: SQL Server 2008 Internals is Orderable!

  Less than a week ago, I told you about making some major progress on my new book, and that it would "soon" be pre-orderable. It turns out it already was orderable, as my helpful readers let me know. So here is the link to Amazon, for all of you who want Read More... Posted Thursday, October 23, 2008 4:08 PM by Kalen Delaney | 3 Comments Filed under: books, Inside SQL Server, internals

• Did You Know? There is a light at the end!

  I realize it's been a long time since I've posted, but I have been traveling quite a bit, and when not traveling I am writing. I have a firm deadline for the next book,and it means every available hour that I am not teaching will have to be spent writing. Read More... Posted Friday, October 17, 2008 1:40 PM by Kalen Delaney | 3 Comments Filed under: books, internals

• Did You Know? I'm not just a SQL Server expert!

  School started for my two university-attending sons, and one of them was ordering his books on Amazon from the Marketplace, which is resellers and Amazon partners, selling both new and used. He ordered the books before classes started, expecting to receive Read More... Posted Thursday, October 09, 2008 2:47 PM by Kalen Delaney | 12 Comments Filed under: books