You may be confusing index free space with database file free space.

Index free space refers to the free space in each page of an index.  When an insert operations occurs,...

This doesn't sound like a SQL problem, it sounds like a Crystal problem. 

While Crystal is designed to simply "connect and create" reports against a database, it's notoriously slow if...

Transaction logging cannot be "turned off", regardless of the recovery model in place.

SQL Server issues a "checkpoint" every 60 seconds in the transaction log.  This interval can change depending upon...