Browse by Tags

All Tags » Indexes (RSS)

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

sys.dm_db_index_usage_stats does it tell the truth ?

Here’s what is in BOL 2008 , also in BOL 2005 , also in the first few blog posts about the this dmv that BING brought back, it’s also in my “Analysing Indexes” blog posts. “ Every individual seek, scan, lookup, or update on the specified index by one...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: ,

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

Analysing Indexes - count *

In my presentations on indexing I have always said that you should explore the advantages of covering your clustered index with a secondary index. In circumstances where you might want to just return values form the PK ( assuming it's your clustered...
Posted by GrumpyOldDBA | with no comments
Filed under:

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: , ,

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

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...

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: , ,

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: , ,

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...
More Posts Next page »