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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.25 (55)

You rated this post out of 5. Change rating

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

14,065 reads

This is my last week of the year working (I guess I come back...

This is my last week of the year working (I guess I come back...

I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...

I have an ADF pipeline that copies Files from source to destination. Both Source...

I''m running a stripped backup (2 files) to a Network share. It's a 32gig...

Comments posted to this topic are about the item Function Defaults

I have created this function in SQL Server 2022:

CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
    RETURN @one + @two
END

How can I call this and invoke the default value for @two?