Install SQL Server Management Studio (SSMS) 2016 Without Internet Access: One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation. It is now has its … Continue Reading →
Transaction Log Grows Unexpectedly Due to Orphan Transactions
Problem: A SQL Server 2005 database’s transaction log file is growing. The transaction log file is originally 20 gigabytes in size. Over a three day period, the transaction log grow … Continue Reading →