SQLServerCentral / Discuss Content Posted by Desiree Harris / Article Discussions / Article Discussions by Author / Indexes: An Overview and Maintenance for Performance / Latest Posts

RE: Indexes: An Overview and Maintenance for Performance

Al Pagcaliwangan — Tue, 03 Jan 2006 00:10:00 GMT

I'll use this knowledge in my projects existing tables. Thanks!

RE: Indexes: An Overview and Maintenance for Performance

AndreQ1 — Wed, 05 Jan 2005 15:41:00 GMT

I very much enjoyed the article and it provided a lot of useful information. I have a stored procedure called RefreshDatabase that runs various maintenance scripts. I've included your reindexing commands in that and am eager to see the performance benefits.

Again, thank you.

RE: Indexes: An Overview and Maintenance for Performance

Adam Machanic — Mon, 03 Jan 2005 12:14:00 GMT

Quote:--The fullness of the index pages can be determined by reading the "Avg. Bytes free per page" and "Avg. Page density (full)" statistics. The "Avg. Bytes free per page" figure should be low and the "Avg. Page density (full)" figure should be high. You'll notice that both tables likely have very full pages.--However, both tables do not have very full pages. They have high free byte counts and low page densities. (6721.0 / 16.96% and 5596.0 / 30.86%)

RE: Indexes: An Overview and Maintenance for Performance

Davidk — Thu, 30 Dec 2004 21:36:00 GMT

Well, my significant other is the wordsmith in the family, but I’ll give this a go:

“Each table can have only one clustered index, however, up to 249 nonclustered indexes can be added per table.

Consulted BOL searched “noncluserted indexes” then “number per table” issue was is it spelled “non-clustered” or “nonclustered” BOL says “nonclustered”.

Thanks for the opportunity to be of service, hope this helps. I’d be glad to help in the future too.

David Kappel, kap@msn.com

P.S I’ looking for work, and I’m willing to travel from the Seattle area.

RE: Indexes: An Overview and Maintenance for Performance

mimorr — Thu, 30 Dec 2004 08:28:00 GMT

I look forward to finishing the article, however, could you fix the following typo?Each table can have only one clustered index, however up to 249 clustered indexes can be added per table. Thanks!

RE: Indexes: An Overview and Maintenance for Performance

Davidk — Thu, 30 Dec 2004 02:03:00 GMT

Thank you Desiree, I just passed MS database implementation exam with a score over 90%. I wish I had read your article first; my score would have been higher. Good relevant Info.

David Kappel, MCDBA (brand-new), MCSE, CompTIA Security+

Indexes: An Overview and Maintenance for Performance

Desirée B. Harris — Tue, 21 Dec 2004 18:10:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.c