Automate Data Purity Investigation
Sometimes running DBCC CHECKDB WITH DATA_PURITY returns thousands of affected columns. This script automates the identification of those columns.
2015-04-13 (first published: 2013-07-04)
2,413 reads
Sometimes running DBCC CHECKDB WITH DATA_PURITY returns thousands of affected columns. This script automates the identification of those columns.
2015-04-13 (first published: 2013-07-04)
2,413 reads
Compare the logins and users on two instances and generate a TSQL script to make them the same.
2015-02-26 (first published: 2013-11-15)
2,828 reads
Want to blend your love of marketing with the power of data? Becoming a...
I live for questions and this was an interesting one. Can you see Table...
By Steve Jones
I’m not looking for a job, but I ran across an article about using...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Hi All, Is there a way i can create package for an individual...
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
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