While looking at performance in some of my databases, I noticed there was a high number of FreeSpace scans going on.   Aaargh!  They are called clustered indexes, people use them!  Performance, performance, performance!

In most cases it is best practices to start with a clustered index on every table created.  There are rare instances when this is not the optimal setup, but for the large majority of standard databases put in a clustered index on each table.  Your shooting yourself in the foot, people!

Enjoy!