Browse by Tags

All Tags » Indexes » General Tuning (RSS)
05 September 2011 13:23

Posts of Interest

I don't make a habit of just posting links as I think it's like a form of cheating, however sometimes there are things I want to keep track of and I know If I put the link on my blog I'll find it again! so: a short one here; We've just...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
04 June 2010 12:04

Given the choice 8 out of 10 Optimisers prefer.........

Did you know that included columns do not partake in the uniqueness of a unique index? ( see below ) A few months ago we upgraded our major production system from SQL2000 to SQL2008, this has allowed me to apply some of the index tuning techniques I devised...
Posted by GrumpyOldDBA | with no comments
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: , ,
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 | 1 comment(s)
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: ,
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 | 5 comment(s)
Filed under: , ,