Scary Scalar Functions - Part Four: Your Environment

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance
Part Three: The Cure
Part Four: Your Environment

Foreword
In the previous posts, we have learned why Scalar Functions (UDFs) are bad for parallelism...

My Toolbox - Everything

Foreword
Not everything in the general sense, but a tool called Everything by voidtools (Download link). Usually, I have to make this distinction when googling.
No matter how great is my...

Unexpected Blocking during the Indexed View Creation

The problem
There was a need to make changes to a table with an Indexed View. Since Indexed Views must be created with SCHEMABINDING, the View must be dropped and...

My Toolbox - Greenshot

Foreword
A picture is worth a thousand words. I use screenshots daily, whether it’s to share results, how-to tutorials, point out mistakes or create memes.
None of the tools I’ve tried...

Scary Scalar Functions - Part Three: The Cure

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance
Part Three: The Cure

Foreword
In the first two parts, we have seen why the Scalar functions (UDFs) are a problem for the...

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

Scary Scalar Functions - Part Two: Performance

Scary Scalar Functions series overview

Part One: Parallelism
Part Two: Performance

Foreword
In the second part of this series, we’ll look at how Scalar functions (or UDFs) affect performance.
If you want to follow...

What is causing my constraint to be untrusted?

The problem
In this scenario, you have discovered that one of your Check constraints or Foreign keys is not trusted.
Maybe you’ve detected it with a sp_Blitz, dbachecks or out of...

Scary Scalar Functions - Part One: Parallelism

Foreword
I’m still surprised many people don’t realise how lousy Scalar functions (aka User Defined Functions aka UDFs) are. So because it’s my current focus in work and this Stack...

Coding Standards (T-SQL Tuesday #151)

Foreword
This month’s invitation is from Mala Mahadevan, and it’s about coding standards. Fortunately, I may forget several basic ones because my team probably eradicated them long ago.
I’ll go with...