December 2007 - Posts

• Geek City: Included Columns

  When an issue comes up more than once in a short period of time, I figure it is a message from the Universe. I might even assume it is a gift of blog fodder. So I won't turn down the gift, even if it means another juicy post before the end of year, much Read More... Posted Monday, December 31, 2007 12:53 PM by Kalen Delaney | 3 Comments Filed under: Tools, included columns, indexes Attachment(s): new_helpindex.txt

• Geek City: Christmas Present from PSS

  I rarely just make a post that is a link to someone else's blog post, but this one is too good to allow anyone to miss. So if you haven't seen any other announcements about this one, you'll see it here. Two of the incredible guys in Product Support Services Read More... Posted Tuesday, December 18, 2007 2:12 PM by Kalen Delaney | 3 Comments Filed under: Tools, Performance, SQLTrace

• Geek City: Q & A on my Plan Cache Sizing article in SQL Server Magazine

  My December article in SQL Server Magazine , called Managing Plan Cache Size, expands on the information I talked about in a post last month on the limits of plan cache . A reader of the article ask some questions on the SQL Server Magazine web site, Read More... Posted Saturday, December 15, 2007 8:00 PM by Kalen Delaney | 3 Comments Filed under: plan cache, plan guides, SQL Server Magazine, memory management

• Geek City: SQL Server Internals Course Coming Soon on DVD

  New York, New York, what a wonderful town! Or at least it looked wonderful from Jersey City, looking across the Hudson. I flew to Newark last Tuesday, spent Wednesday under bright lights with a boom microphone hanging over my head, and flew home on Thursday. Read More... Posted Saturday, December 15, 2007 12:59 PM by Kalen Delaney | 9 Comments

• Did You Know? More Prizes to Win

  Buck Woody, one of my favorite bloggers on the SQL Server Dev Team, invites you to try your luck with his SQL Server Management Studio crossword puzzle. One lucky person, who solves the puzzle correctly, will win a cool geeky prize. http://blogs.msdn.com/buckwoody/archive/2007/12/10/puzzle-of-the-month-this-one-with-prizes.aspx Read More... Posted Tuesday, December 11, 2007 5:44 PM by Kalen Delaney | 0 Comments

• Did You Know? I'm a Mother

  And I am going to use my blog to claim one of the sacred rights of motherhood, which is to brag about my children. My daughter is an award-winning Food Blogger with an incredible blog , for those of you who like to make or even eat food. For the past Read More... Posted Monday, December 10, 2007 11:55 AM by Kalen Delaney | 0 Comments Filed under: food, travelers lunchbox, raffle

• Geek City: HyperThreaded or Not?

  In almost all my classes, and every time I do any performance consulting, I get the question "How can I determine if our SQL Server is hyperthreaded?" I was delighted when I found the DMV sys.dm_sys_info, which has a column called hyperthread_ratio. But Read More... Posted Saturday, December 08, 2007 4:56 PM by Kalen Delaney | 7 Comments Filed under: CPUs, DMVs, Hyperthreading

• Did You Know? The Best SQL Server 2005 Feature

  This post really should have a topic of "Pet Peeve" but I really didn't want to sound quite so negative. It seems like almost every time I see a clever solution in a newsgroup response, or in a blog post, about how to extract some very useful troubleshooting Read More... Posted Tuesday, December 04, 2007 10:44 PM by Kalen Delaney | 9 Comments Filed under: Upgrade, DMVs