Mickey

Why Scalar Functions Can Be Costly

Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(55)

You rated this post out of 5. Change rating

2017-06-02 (first published: 2016-01-04)

14,691 reads

Ramblings of a retired data architect Let me start by saying that I have...

A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....

With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...

Hi everyone, Below is a consolidated summary of what we validated Architecture & data...

Hi all, I recently moved to a new employer who have their HA setup...

Comments posted to this topic are about the item Semantic Search in SQL Server...

I have this data in a SQL Server 2025 table:

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO

If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?