cetindogu
cetindogu
/ FindSparseColumnCandidates.sql
Created
May 18, 2024 11:57
— forked from davepcallan/FindSparseColumnCandidates.sql
SQL Server SQL script to find sparse column candidates
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| USE TestDB | |
| GO | |
| DECLARE @DatabaseName VARCHAR(100) | |
| DECLARE @SchemaName VARCHAR(100) | |
| DECLARE @TableName VARCHAR(100) | |
| DECLARE @ColumnName VARCHAR(100) | |
| DECLARE @FullyQualifiedTableName VARCHAR(500) | |
| --Create Temp Table to Save Results |