I have a database of 7 Gigs. But, the transaction log is of 18 Gig size. I have been inserting and deleting tables with millions of records for the past few montths. I dont have maintenance plan on this database except that it is backed up every week. I dont have any space constraints.
But, I do wonder whether the size of the transaction log would effect the performance of queries on the main database.