Posted by wackyphill on 06/11/06 04:44

I understand your point Erland, but these Primary keys were created w/o
specifying that they should be non-clustered, so I'm certain they are.
Why is it that w/o a clustered index defragmentation on non-clustered
indexes can't occur, or did I misunderstand the previous poster?

You are correct that these tables currently are small by most people's
standards. I'm guessing that the largest one has < 1000 records. Is it
mentioned somewhere in SQL books on-line about free space looking lile
fragmentaion, that I can read up on?

Also, I'm looking for a good SQL Server 2005 book, if anyone has a
recommendation I'd apreciate it. I'm an experienced programmer, but am
not an experienced DBA as far as actually creating and managing tables,
views, and indexes, etc. inteligently. I've usually just written
queries or stored procs that end up getting used in my frontend
programs that interact w/ an existing database someone else had
created.

A book that was more beginner DBA orientated I think would be helpful
to me. Thanks for your input everyone.

[Back to original message]