namanvadehra@gmail.com

Naman Vadehra is a DBA in a product based IT company. With total experience of more than 11 years, he is more inclined towards analyzing the sql server environment. My areas of interest include performance tuning, identifying ways of doing comprehensive analysis to assist in troubleshooting issues.

Interests: anything but working :)

All authors

Fill Factor vs Page Splits – Measure It..!!

by namanvadehra@gmail.com

Digging into Databases

I have been trying to solve the puzzle of “How to evaluate my current Fill Factor setting?”, and there have...

2014-10-08

1,307 reads

All authors

Blogs

My 2024 in Data: Reading

By Steve Jones

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

Book Review – Agile Data Warehouse Design

By Koen Verbeeck

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

My 2024 in Data: Speaking

By Steve Jones

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

Read the latest Blogs

Forums

Need ADF pipeline suggestion to copy 1 million files

By varunkum

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

Backup issues

By Bruin

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

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Visit the forum

Question of the Day

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?

See possible answers