Category: SQL Server

SQLServerCarpenter Tools

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 … Continue reading SQLServerCarpenter Tools →

usp_SQLServerCarpenter_Tools_GenerateTSQLCode_For_Get_Put_APIs

This procedure will generate SQL Code for Get and Put API's. This may be useful if you are developing your own data replication strategy to replicate data across multiple servers.

usp_SQLServerCarpenter_Tools_Estimate_Ineffective_Indexes

This procedure will list down all the indexes (Clustered as well Nonclustered Indexes) whose first key column having poor cardinality.

usp_SQLServerCarpenter_Tools_Estimate_Cardinality

This procedure will estimate the cardinality of all the columns of the supplied table list. If the table list is not supplied (or supplied with NULL, the default value) then it will estimate the cardinality for all the tables in the database.

usp_SQLServerCarpenter_Tools_Estimate_Nonclustered_Indexes_Clashing_With_Clustered_Index

This procedure will list down all the nonclustered indexes, which includes key columns as that of the clustered index. It will also list the key columns of both – nonclustered index, and the corresponding clustered index, along with the key ordinal of the clustered index key columns in the respective nonclustered index. It is now up to you to decide which one makes sense, and which doesn’t. Take the decision accordingly and delete the ones that do not make sense. This procedure may be helpful in performance tuning assignments.