Browse by Tags

• Design
• Events
• SQL Server 2005

• RunAs Radio Interview Posted - "Kim Tripp Indexes Everything"

  Well... I think I had had too much tea that morning ;-). But, as always, chatting with Richard and Greg was great. Here's the specific show link: http://www.runasradio.com/default.aspx?showNum=76 . Oh, and just for the record, I didn't come up with that Read More... Posted Saturday, October 04, 2008 4:51 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Events, indexes, SQL Server 2008, resources, SQL Server 2005

• Updates (fixes) to sp_helpindex2

  I first posted an update to sp_helpindex here . My version of sp_helpindex was solely to expand what sp_helpindex showed and adds 1 or 2 things based on version: for SQL2005+ it adds included columns and for SQL2008 it also adds the filter predicate. Read More... Posted Monday, August 25, 2008 5:23 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: indexes, SQL Server 2008, resources, SQL Server 2005

• sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex

  OK - so this has been frustrating me for many months... when you create indexes with included columns (which was a new feature of SQL Server 2005), they're not shown by sp_helpindex or by DBCC SHOW_STATISTICS. I understand this not showing for statistics Read More... Posted Thursday, April 03, 2008 4:22 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: indexes, SQL Server 2008, resources, SQL Server 2005

• Statistics, query plans, and are you reading Conor's blog?

  I know that Paul and I recommended that you subscribe to Conor's blog ... but have you? He's posted some great details on Partitioning ( Part 1 and Part 2 ) as well as statistics and it always reminds me of how much I can learn from other people's perspectives! Read More... Posted Tuesday, February 05, 2008 6:06 PM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: indexes, SQL Server 2008, resources, Design