• "every table within SQL Server should have a clustered index"

    Fine, but should it then also always be the (preferably meaningless?) primary key? Or an index that is more likely to be used to retrieve ranges of records?