Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
3 reads
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
3 reads
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
1 reads
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
Watch this week’s episode on YouTubeWhen first learning SQL Server, I had the brilliant idea of defining every column on...
2019-04-05 (first published: 2019-03-19)
1,565 reads
Watch this week's video on YouTube
A while back I learned that it's possible to create temporary stored procedures in SQL Server.
I never put that knowledge into practice however because I...
2019-04-02
Watch this week's video on YouTube
A while back I learned that it's possible to create temporary stored procedures in SQL Server.
I never put that knowledge into practice however because I...
2019-04-02
This post is a response to this month’s T-SQL Tuesday #112 prompt by Shane O’Neill. T-SQL Tuesday is a way for the SQL...
2019-03-29 (first published: 2019-03-12)
284 reads
It’s important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect. Today I want to look at what...
2019-03-26
22 reads
Watch this week's video on YouTube
It's important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect.
Today I want...
2019-03-26
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...
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
Website: https://dmtcart.shop/ Buy dmt carts and get the experience you expect. DMT is now...
I have an ADF pipeline that copies Files from source to destination. Both Source...
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