Databases are usually in Full Recovery mode. This means that every transaction is retained in the transaction logs allowing a point in time recovery.
The implication of this is that unless the transaction log is truncated, no space gets freed up on deleting rows from any tables. Delete operations only shift data from the table to the logs.
Following are the steps to reduce the size of transaction log in SQL Server Management Studio:
Fig 1: Options to reduce transaction log file size
January 03, 2020 bySwanand Nirgudkar
For an automated process any operation involving database is relatively expensive since it involves…Continue Reading
October 11, 2019 bySwanand Nirgudkar
One may face issue while applying SheetKraft patch wherein ActivityRunner service refuses to start…Continue Reading
May 02, 2019 bySaloni Gude
Originally published on Thu, 2 Mar, 2017 at 6:59 AM Fill is used to generate multiple values from an…Continue Reading