MSSQL-Administation-Scripts

Administrative scripts for Microsoft SQL Server database

MSSQL_PRC_ADM_delete_column_20190720.sql

It's a Administrative procedure that drops columns at MS SQL Server
=> input parameters are TABLE NAME and COLUMN NAME as STRING

MSSQL_compression_yn.sql

Script to find candiate tables for compressions columns at MS SQL Server

MSSQL_restore_DB.sql

Script to restore a database Backup with replace of the old data and relocate files at MS SQL Server

MSSQL_Search_content_CURSOR_20190917.sql

Script to find content from columns at MS SQL Server

MSSQL_Show_all_Trigger_20190220.sql

Script that lists all Triggers in MS SQL Server

MSSQL_Table_size_20190723.sql

Show descendent orderer tables by size at MS SQL Server