Category: Performance Improvement in SQL
018. find a list of Weekends between given two Dates in SQL Server
This script helps to DBA for finding available weekends between the dates so they can set auto-schedule for database maintenance.
016. Find stored procedures which have used Temporary Table
Whenever we are finding some issues in performance, we are also try to avoid Dynamic Sql in Stored Procedure.To avoid
010. Generate CREATE Index script for all indexes in database in Sql Server
Problem: Sometime DBA’s want to get script of indexes from their current database. How anyone can get “Drop and Create