Browse by Tags

All Tags » Code Tuning » Indexes (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: , ,
19 May 2010 20:44

Analysing Indexes - reducing scans.

The whole subject of database/application tuning is sometimes akin to a black art, it's pretty easy to find your worst 20 whatever but actually seeking to reduce operational overhead can be slightly more tricky. If you ever read through my analysing...
Posted by GrumpyOldDBA | 4 comment(s)
Filed under: , ,
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 | 2 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: , ,
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: ,
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: , ,
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 | 7 comment(s)
Filed under: ,