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,365 reads
Richard Fryar
Script Login Differences
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,697 reads
Blogs
A Biography Template for New Presenters
By DesertDBA
Presenting is difficult, and you already know that. It is also incredibly rewarding and...
Goal Progress–Feb 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
How to: exec sp_help on temp tables?
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
Forums
Problem with creating quri for alocating amount
good day i came a cross of a problem So i have a quri...
Problem with Logic for new column
Hi guys, I have the following table DDL/DML CREATE TABLE #DailyOnHandForecast (Id INT, ItemNo_...
pivot on 2 fields
I'm trying to create a query that pivots on 2 fields(entity,channel) and produce a...
Ask SSC