Browse by Tags

All Tags » Indexes (RSS)
28 January 2010 20:38

Index Rebuild Observations

As part of a series of migration tests carrying out an all index rebuild on a user database has been used to compare relative performance. As the application is a true 7 x 24, there are no maintenance windows so index rebuilds are very intrusive and elicit...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
11 March 2009 22:14

Does a GUID make a good clustered key?

I've covered the use of unique identifiers ( guids ) in my presentations and in my articles on anlysing indexes; however I probably wasn't quite as succinct as I could have been. So do I like unique identifiers as clustered keys? Absolutely not...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
05 February 2009 20:24

Can I Index a bit ? ( Part 1 )

The final part wil follow and a fully illustrated pdf will be on my website - I'll post the location when it's complete. Can I index a bit? VBUG Presentation 27th January 2009 Bracknell. Here's a brief summary of subject matter and the points...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
15 September 2008 16:17

Indexes, Basically - from SQL Bits

I'll put the entire content including as much as I can remember of what I said, the demo code and results onto my web site over the following week or so. If you'd like the demo databases ( sql 2008 ) there are three, the largest being 60Gb - none...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
11 July 2008 18:46

Filtered Indexes - Really Cool !!!!!!!!!!!!!!!

You may or may not be aware that one of the major new features for SQL 2008 is filtered indexes. Now I'm not quite sure why more hasn't been made of this as it is without doubt a seriously significant new feature. I suppose it depends upon your...
Posted by GrumpyOldDBA | 3 comment(s)
Filed under: , ,
10 June 2008 20:30

Tracking problem indexes in SQL 2000

It’s all so easy(ish) to work within SQL 2005 but the reality is that there are still more SQL 2000 databases than SQL 2005, so I’m told, and I’m supporting one of them right now. I’ve been contemplating on how to get a handle on which of my indexes are...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
26 May 2008 15:07

Covering Clustered Indexes

I’ve noticed that of late I’ve become a bit more critical of a well known publication that I suspect many DBA’s read. I have subscriptions to a number of publications and for the ones that I pay for I’m generally quite content. I like paper / hard copy...
Posted by GrumpyOldDBA | 4 comment(s)
Filed under: ,
18 February 2008 19:53

Analysing Indexes Summary

· I’ve put the work I’ve done on using the dmvs to analyse indexes onto my web site – the links to the pages are underneath. Trying to post large documents to the blog is very difficult, and probably not what a blog was intended for! · I need to do more...
Posted by GrumpyOldDBA | 3 comment(s)
Filed under: ,
22 October 2007 20:54

sys.dm_db_index_physical_stats

It seems my comments in my SQLBits presentation about dropping sys.dm_db_index_physical_stats into a table valued function so it can be used within queries caught the eye of an important person. Now I'd not really given much thought to what I did, I was...
Posted by GrumpyOldDBA | 3 comment(s)
Filed under: ,
27 September 2007 08:19

Analysing Indexes Part 4 - Size does matter - 3

11. dropping the clustered index shows all secondary indexes at + 9 bytes ( integer index replaced with guid index ) Index id index_typec Index depth Index level Page count Record count avg_record size_in bytes 0 HEAP 1 0 153847 2000000 579 datetime 2...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
27 September 2007 08:17

Analysing Indexes Part 4 - Size does matter -2

4. Replacing the clustered Primary Key with a non clustered Primary Key on the integer column gives us two secondary indexes, each entry being + 9 bytes The primary key is index 3 Index id index_typec Index depth Index level Page count Record count avg_record...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
27 September 2007 08:12

Analysing Indexes Part 4 - Size does matter

( can't post this in one go so it's going to be a few parts ) v I’ll say now that this is a whole lot of figures and values, I’ve attempted to summarize what I can at the end of the article; for those who want to cut to the chase. o ( The naming used...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
13 September 2007 10:14

Analysing Indexes at SQLBits

Seems I've been selected to present at SQLBits on my work on Index Analysis. So a thankyou for those who voted for my presentation. I just noticed this post http://blogs.msdn.com/sqlcat/archive/2007/09/12/sqlcat-tracks-at-2007-sql-pass.aspx?CommentPosted...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
22 July 2007 22:38

Analysing Indexes Part 2

Here's the next instalment, expect there to at least another two or three. I’m still only working with basic indexing No partitioning I’m not looking at xml indexes. 14.0 Collecting Raw Index usage data Collects table name, index name , reads and writes...
Posted by GrumpyOldDBA | 4 comment(s)
Filed under: , ,
12 July 2007 16:17

Analysing Indexes Part 1

Actually what started as a small document has continued to grow. I'm working on performance tuning a well known application and as I document as I work so others can follow what I'm doing I thought I'd add it to my blog. There's nothing particularly startling...
Posted by GrumpyOldDBA | 4 comment(s)
Filed under: ,