TSQL-Duplication-Analyzer is a stored procedure designed to analyze and manage duplicate keys in database tables across multiple datasets. It automates the process of detecting duplicate records and ensuring proper key setup for optimal data integrity. The procedure performs checks across various tables and provides actionable insights, making it easier to maintain clean and reliable data in your database systems.

Features Duplicate Key Detection: Identifies tables with missing or misconfigured duplicate keys. Data Integrity Checks: Ensures tables are free from duplicate records, maintaining consistency across datasets. Customizable Configuration: Supports various filters and conditions for database and table names, dataset names, and pass count. Efficient Reporting: Outputs results on duplicate counts and missing keys, with actionable queries for cleanup. Flexible Execution: Can be run across multiple databases and tables with specific conditions.