Only one more chapter to go! As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title...
2023-11-08 (first published: 2023-10-23)
624 reads
As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...
2023-11-06
9 reads
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a...
2023-11-06 (first published: 2023-10-23)
739 reads
Yes, you still need to do some work to maintain indexes in Azure SQL Database. This post will walk you through setting up statistic updates and index maintenance using...
2023-11-06 (first published: 2023-10-19)
488 reads
📰 News Process Azure Event Hubs data using Azure Data Factory Mapping Data Flows Read how to process Azure Event Hubs data using ADF for certain use cases. Automate...
2023-11-05
10 reads
zielschmerz – n. the dread of pursuing a lifelong dream, which requires you to put your true abilities out there to be tested on the open savannah, no longer...
2023-11-03
122 reads
I had someone ask me recently about deleting branches. While I had known how to delete a local branch, I had to look up how to delete a remote...
2023-11-03 (first published: 2023-10-23)
164 reads
I find that quite a few people using Flyway will end up with a lot of migration scripts over time. While you can certainly re-baseline and split scripts into...
2023-11-03
24 reads
SQL Server query developers, listen up! Query execution time is not everything you should be worried about. You need to examine the parse and compilation time for each of...
2023-11-03 (first published: 2023-10-18)
585 reads
I had a customer recently ask if they could find out which objects are dependent on others using SQL Doc. This post shows how to do that. Using SQL...
2023-11-01
285 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
This is my last week of the year working (I guess I come back...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Comments posted to this topic are about the item Function Defaults
Comments posted to this topic are about the item Big Data or Small Data
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