SQL Server transaction log, SHRINK - to be or not to be?
You have a production database which has a very high growth rate. As a result the database transaction log gets full resulting a daily scheduled job to shrink. All the times this is affecting the performance on SQL Server, what is the best option to shrink the transaction log and set appropriate settings on the SQL Server.
To find out more on whether you have to SHRINK the transaction log or not refer to FAQ post.