Browse by Tags

• Conference Resources/Q&A
• Design
• Events
• Personal
• resources
• SQL Server 2005
• tips

• 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

• Auto update statistics and auto create statistics - should you leave them on and/or turn them on??

  YES!!! OK, well, I guess I should be more specific because as in most things in SQL Server, the real answer is "it depends". And for these two options, it depends mostly on your SQL Server version. Since SQL Server 7.0, the way that auto update works, Read More... Posted Monday, August 25, 2008 5:12 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: indexes, SQL Server 2008, tips, SQL Server 2005

• SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)!

  OK, so, I don't blog very often. I don't know what it is... I think it's that I feel like I always need to blog huge posts and the thought of writing my huge post makes me not want to blog... so, sometimes my time-between-blogging (TBB :) is long. I'm Read More... Posted Monday, August 25, 2008 3:27 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Events, Personal, indexes, SQL Server 2008, tips, Design

• Indexes in SQL Server 2005/2008 - Part 2 - Internals

  OK, I first posted on some of the limitations to indexes in SQL Server 2005 and 2008 in part one here . Now, I want to dive into index internals for a post (or two). And, I often get the question “ who is the best audience for your blog – or, for this Read More... Posted Monday, June 09, 2008 3:43 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Events, indexes, SQL Server 2008, SQL Server 2005, Conference Resources/Q&A

• Indexes in SQL Server 2005/2008 - Best Practices, Part 1

  In my blog post on my new sp_helpindex proc ( sp_helpindex2 ), I mentioned that the indexes in my sample were not necessarily a recommended set of indexes - just a test set of indexes. So... in this post, I thought I'd start a series on indexes, limitations Read More... Posted Wednesday, April 16, 2008 7:44 PM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: indexes, SQL Server 2008, 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