I’ve had a really disappointing experience with the Liquid Web sales team, regarding the web server that hosts this blog post you’re reading right now. My disappointment is compounded...
2024-01-26
25 reads
Understanding query plans is key to successful query tuning in Microsoft SQL Server. Randolph West of the Microsoft docs team posted on Thursday that the logical and physical showplan...
2024-01-26
39 reads
So what did I learn? I think a better question is, "What did I re-learn?"
2024-01-26 (first published: 2024-01-09)
233 reads
It’s T-SQL Tuesday again! In fact, it’s the first of the year and our intrepid host is Reitse Eskens (blog|twitter). ... Continue reading
2024-01-24 (first published: 2024-01-09)
515 reads
I am a big fan of the cloud. While I appreciate local storage and privacy/control/security, etc., that stuff can also go away locally. Plus, I like the convenience, and...
2024-01-24
29 reads
A couple of weeks ago, I encountered a DAX question that I had not previously considered. They had a situation where there were two paths between two tables: on...
2024-01-24 (first published: 2024-01-09)
483 reads
All Spark Connect Posts
Goal of this post This post aims to show how we can create a .NET application, deploy it to Databricks, and then run a Databricks job...
2024-01-24 (first published: 2024-01-23)
51 reads
When it comes to data meshes that have been constructed or are currently under development, I have not observed any instances where the four core data mesh principles have...
2024-01-22 (first published: 2024-01-04)
206 reads
Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production? Many of us manage databases...
2024-01-22 (first published: 2024-01-08)
616 reads
altschmerz – n. a sense of weariness with the same old problems that you’ve always had, the same boring issues and anxieties you’ve been gnawing on for decades, which...
2024-01-19
5 reads
By Steve Jones
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...
By Steve Jones
This is my last week of the year working (I guess I come back...
I have an ADF pipeline that copies Files from source to destination. Both Source...
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? See possible answers