Scripts to Update Database Values Executing scripts to update incorrect values in a database should be done with care. If a script dynamically updates a value based on a calculation it is possible that each subsequent execution of the script… Read More ›
T-SQL
Shrinking a Log File in SQL Server 2008
Starting in SQL 2008 the ability to backup with no truncate options were removed. This affects the ability to shrink a log file without actually performing a backup. There is some significant risk in truncating the log file without first… Read More ›