SQL Server Partitioning for Performance

Often enough I get questions regarding partitioning to try to help alleviate performance issues with very large tables. A common misconception is that due to the table being large,...

Thank You Allen!

I know I can say that I’m a friend of Allen White without getting into trouble. Allen and I have a shared a lot of things over the years...

T-SQL Tuesday #152–It Depends

A great invitation this month from Deborah Melkin. I thought this was very apt, as I use this phrase often. Many of us do. This was a tougher post...

T-SQL Tuesday 152: An ORM Will Not Save You From Yourself

T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Deborah Melkin (blog | twitter) asks us for a database-related rant.

I...

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

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

How do I tell if identity_insert is turned on and if so what table?

TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading

The First 30 Days at a New Database Job

Over the last four years, ok it seems longer than that, I’ve started four jobs. A couple just weren’t good fits. One I was at for three years. I...

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_Ineffective_Indexes

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