August 2007 - Posts

• Useful Index Information Scripts for SQL Server 2005

  Italian SQL Server MVP Davide Mauri has released four very useful scripts that simplify the usage of SQL Server 2005 DMVs to discover, analyze, and understand index usage and health. The queries are not rocket science, but they are long and rely on DMVs Read More... Posted Friday, August 31, 2007 6:31 PM by KKline | 3 Comments Filed under: Internals, SQL Programming, Tips

• PASS Seminar on Virtualization Sponsored By Quest

  For those of you who attended our fun and informative PASS session last year on "Surviving the Data Avalanche" and VLDBs, you might be interested in attending this year's panel discussion on Virtualization. Here are the details: Virtualization and SQL Read More... Posted Thursday, August 30, 2007 4:50 PM by KKline | 0 Comments Filed under: Speaking, Tips, Trends

• The Perils of Hyperthreading for SQL Server

  Just a quick note to send a big Thank You to Christoph Stotz of Frankfurt, Germany for his hospitality on Sunday. Thank you, Christoph! Slava Oks has a rather well-known blog entry about how hyperthreading can negatively impact the performance of a SQL Read More... Posted Saturday, August 18, 2007 4:47 PM by KKline | 7 Comments Filed under: Internals, Performance, Tips

• Delivering Sessions in Detroit, Chicago, and Many Cities in Germany

  I'll be speaking in Detroit on the morning of Wednesday, September 5th and Chicago on the morning of Thursday, September 6th in the Quest Software "Breakfast with the Experts" series. If you live in the area, I'd love to see you there. Details are at Read More... Posted Wednesday, August 15, 2007 11:06 AM by KKline | 0 Comments Filed under: Speaking

• Some Good Tips

  We can all use a little help from our friends. That's why I'd like to direct your attention to a few articles written by friends whom I trust and find very credible. The first person I'd like to introduce you to is Denny Cherry. Denny is a senior DBA Read More... Posted Monday, August 13, 2007 3:01 PM by KKline | 0 Comments Filed under: People, Tips

• New SQL Server Product Releases from Quest Software

  I was the initial architect for a number of the SQL Server tools offered by Quest Software. Check them out at http://www.quest.com/sql_server . This month, a number of new products have been or are being released. Here are some of the products with some Read More... Posted Friday, August 10, 2007 11:55 AM by KKline | 0 Comments Filed under: Quest Software

• Determining SQL Server Cores, CPUs, and Hyperthreading

  Over the years, I've heard people mention that they wanted a way to determine the physical processor configuration on a machine, for example, how many cores are on the server, is hyperthreading enabled, etc. The good news is that uber-genius of the SQL Read More... Posted Tuesday, August 07, 2007 9:27 AM by KKline | 3 Comments Filed under: Internals, Performance