Hi,

couple questions:

1) How does one determine the best field (or fields) to build the clustered index on? Examples would be of great help to me here.

2) I was told by "someone who knows" that fillfactors should range between about 50 and 90 - and be based on "how much inserting, updating occurrs" so that heavily inserted tables such as "line items" might be set at 50 while a near static table might get set at 90. Does this sound like good advice?

Thanks,
Ken