We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to shrink the transaction logs.
If I do this, and if the transaction log is forced to shrink everyday, how is it going to affect the server’s performance? Also, is it going to affect something else? Finally, do I even need to reindex tables every day?