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+

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. 

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.

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