This script will show you how much diskspace can be reclaimed by shrinking all the logfiles of userdatabases using a DBCC SHRINKFILE(2) command. Often the spacegain is much smaller then expected. SQL Shrinks logfiles the end of the file until it finds the active part of the logfile. (If the active part of the logfile […]
2005-03-21 (first published: 2005-03-04)
426 reads
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
This may or may not be helpful in the long term, but since I’m...
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Comments posted to this topic are about the item Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers