in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » General Tuning » Indexes (RSS)

Browse by Tags

  • 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 fragmenting too quickly and where the high levels...
    Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-10-2008

  • 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 NONCLUSTERED INDEX 3 0 4695 2000000 17 2 NONCLUSTERED...
    Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 09-27-2007

  • 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 size_in bytes 0 HEAP 1 0 153847 2000000 577...
    Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 09-27-2007

  • 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 for these examples is not representative of any conventions...
    Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 09-27-2007

  • 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 where there is a value for reads or writes Collect...
    Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 07-22-2007
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems