Browse by Tags

• 2003
• allocation
• allow_page_lock
• Conference Resources/Q&A
• data
• deadlock
• Design
• disk
• Events
• extent
• file search
• fragmentation
• Hardware
• i/o
• insert
• IO
• Microsoft
• online
• performance
• Personal
• query
• raid
• resources
• security
• service pack
• services
• sql express
• SQL Server
• SQL Server 2005
• SQL Server 2008
• table
• Testing
• tips
• tool
• unused indexes
• windows
• xp

• 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

• Execution plan re-use, sp_executesql and TSQL variables

  Let me start by saying that the contents of this post is not very advanced. If you have read the excellent paper "Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005", http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx Read More... Posted Friday, August 29, 2008 4:34 PM from Tibor Karaszi | (Comments Off) Filed under: performance, indexes

• 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

• Are inserts quicker to heap or clustered tables?

  Is it quicker and/or lower overhead to insert into a heap vs. a clustered table? I don't know. So I decided to do a test. Some background information first: The test was inspired from a sidebar with Gert-Jan Strik in the open newsgroups. Basically I expressed Read More... Posted Thursday, August 14, 2008 10:05 PM from Tibor Karaszi | (Comments Off) Filed under: performance, indexes

• Yet some more fixes for sp_indexinfo...

  I got some more feedback (see yesterday's blog post on this) which I now incorporated into sp_indexinfo. See change log at bottom of the article for details. http://www.karaszi.com/SQLServer/util_sp_indexinfo.asp Share this post: email it! | bookmark Read More... Posted Wednesday, July 09, 2008 6:03 PM from Tibor Karaszi | (Comments Off) Filed under: performance, indexes

• New version of sp_indexinfo

  (See my initial blog post for general information about this proc.) I just updated sp_indexinfo a bit: I added the schema name as a new column in the output of the first resultset. I added an optional second resultset with missing index information. This Read More... Posted Tuesday, July 08, 2008 5:58 PM from Tibor Karaszi | (Comments Off) Filed under: performance, indexes

• Fed up with hunting physical index details?

  I am. I find myself endlessly hunting for index information when working against the various SQL Servers I come in contact with. And, sure, the information is there. You just need to go and get it. This generally means that I start with sp_helpindex. Read More... Posted Monday, July 07, 2008 10:17 PM from Tibor Karaszi | (Comments Off) Filed under: performance, indexes

• 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

• Find table and index name for fragmented indexes

  Got this question from a newsgroup today. The answer is pretty simple, just use the dynamic management view sys.dm_db_index_physical_stats. I'm posting this here mostly so I have somewhere to refer to when asked this question... I prefer to have a helper Read More... Posted Monday, November 12, 2007 6:53 AM from Tibor Karaszi | (Comments Off) Filed under: indexes

• DBCC EXTENTINFO - unused pages in these extents (undocumented)

  When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when Read More... Posted Tuesday, September 04, 2007 10:45 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, indexes, fragmentation, table, deadlock, i/o, insert, data, allocation, extent