SQL-Server-Helper-Script

This repository contains all helping SQL Server Script which will use in day to day life to troubleshoot and understand SQL Server Health.

Name		Name	Last commit message	Last commit date
Latest commit History 25 Commits
1. Select Primary Key value from Table dynamically-Sql Server		1. Select Primary Key value from Table dynamically-Sql Server
10. Generate CREATE Index script for all indexes in database in Sql Server		10. Generate CREATE Index script for all indexes in database in Sql Server
11. Get all available Databases in SQL Server Instance		11. Get all available Databases in SQL Server Instance
12. Get all schemas in SQL Server database		12. Get all schemas in SQL Server database
2. Find Blocking queries in Sql Server		2. Find Blocking queries in Sql Server
3. Find Most Expensive Stored Procedure Sql Server		3. Find Most Expensive Stored Procedure Sql Server
4. Find most expensive queries-Sql Server		4. Find most expensive queries-Sql Server
5. Find most expensive tables-Sql Server		5. Find most expensive tables-Sql Server
6. Find most used column names in database – Sql Server		6. Find most used column names in database – Sql Server
7. Find out all tables without indexes in Sql Server		7. Find out all tables without indexes in Sql Server
8. Find redundant indexes Sql Server		8. Find redundant indexes Sql Server
9. Find unused Indexes – Sql Server		9. Find unused Indexes – Sql Server
README.md		README.md

Provide feedback