Articles

External Article

Using schema binding to improve SQL Server UDF performance

SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.

2009-03-09

4,200 reads

Blogs

A Pursuit of Lifelong Learning

By

The following came across my YouTube feed today. It’s an interview with General James...

Advice I Like: Time and Focus

By

“You don’t need more time because you already have all the time that you...

Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals

By

I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...

Read the latest Blogs

Forums

Alamat BCA KCP BSD Sektor I Telp:0821°8200°233

By layanan_Bca88

Telp/Wa 628218200233 Komp, BSD City, Ruko Barcelona, Blk. E9 No.30 RK No. 28, 29,...

Alamat BCA KCP Cikupa Telp:0821°8200°203

By R4nt4u

Telp/Wa 628218200203 Jl. Raya Pemda Blok R-1 No.07, dan No.08, Bojong, Kec. Cikupa, Kabupaten...

Alamat BCA KCP Borobudur Telp:0821°7555°651

By m4rt1n4

Telp/Wa 628217555651 Jl. Borobudur Raya Blok M No. 36-37, Bencongan Indah, Kecamatan Kelapa Dua,...

Visit the forum

Question of the Day

DML Trigger Types

How many types of DML triggers are there?

See possible answers