Over the past couple of years, I’ve developed several tools that I’ve been using during my Performance Tuning and other related assignments. I thought to share it with the community but due to my other commitments, I couldn’t write any new posts in the past couple of months.
Here are the tools (essentially the stored procedures and T-SQL queries) you may be interested to explore. These tools shall be published to the general public in the SQL Server Community through an individual post on my blog. I’ll keep on adding new tools as and when they are born. The amendments shall also be made in the same post. You are cordially invited to post your suggestions to make these tools worthy for our community folks.
- usp_SQLServerCarpenter_Tools_Get_Costliest_Queries
- usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
- usp_SQLServerCarpenter_Tools_Get_Objects_Performing_Committed_Read
- usp_SQLServerCarpenter_Tools_Estimate_Nonclustered_Indexes_Clashing_With_Clustered_Index
- usp_SQLServerCarpenter_Tools_Estimate_Cardinality
- usp_SQLServerCarpenter_Tools_Estimate_Ineffective_Indexes
- usp_SQLServerCarpenter_Tools_GenerateTSQLCode_For_Get_Put_APIs
- Script to create copies of the existing object
- Get the month end dates of last N years
- Get the month end dates of last N months
- T-SQL query to find the list of objects referring Linked Servers
- T-SQL script to find hierarchy of tables – Row-wise result
- T-SQL script to find hierarchy of tables – Columnar result
- Estimating the storage savings by removing columns with NULL value across the table or marking them as SPARSE
- Find columns with NULL values across the table
- T-SQL query to get the latest available backup chain
- T-SQL script to purge all the tables including foreign key references
- T-SQL query to copy data from one database to another database
- Generic scalar function to check the tolerance
- Generic trigger for audit log