Daily Coping 12 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

You’re doing your POC wrong! : T-SQL Tuesday #152

It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading

What's in a name? (T-SQL Tuesday #152)

Foreword
This month’s invitation is from Deborah Melkin (b|t), about venting anything you want. So let’s start this rant.

There are only two hard things in Computer Science: cache invalidation and...

Extended Events for Anything But Query Tuning: xml_deadlock_report_filtered

One of my favorite little bits of information about Extended Events is the fact that everyone running a full instance of SQL Server has deadlock information available to them,...

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...

Daily Coping 11 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

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...

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)...

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 –...