Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Indexes: An Overview and Maintenance for Performance Expand / Collapse
Author
Message
Posted Tuesday, December 21, 2004 6:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 10:47 AM
Points: 19, Visits: 77
Comments posted to this topic are about the content posted at http://www.sqlservercentral.c
Post #152095
Posted Thursday, December 30, 2004 2:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 18, 2008 1:13 AM
Points: 22, Visits: 3

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+

   




Post #152970
Posted Thursday, December 30, 2004 8:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 28, 2012 6:13 AM
Points: 380, Visits: 52
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!




Michelle
Post #153006
Posted Thursday, December 30, 2004 9:36 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 18, 2008 1:13 AM
Points: 22, Visits: 3

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. 




Post #153104
Posted Monday, January 3, 2005 12:14 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 7:02 AM
Points: 1,140, Visits: 701
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%)


--
Adam Machanic
SQL Server MVP
SQLblog.com: THE SQL Server Blog Spot on the Web
Post #153324
Posted Wednesday, January 5, 2005 3:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 17, 2006 10:06 AM
Points: 28, Visits: 1

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.

Post #153882
Posted Tuesday, January 3, 2006 12:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 6, 2006 5:13 AM
Points: 28, Visits: 1

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

 




Kindest Regards,

Al Pagcaliwangan B.S. ECE, B.S.EE
Post #247757
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse