Watch this week’s episode on YouTube. Last week we looked at how implicit conversions and datatype precedence can cause SQL Server to output unexpected results (if you aren’t aware of how...
2019-10-01
268 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
994 reads
Watch this week’s video on YouTube! A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with...
2019-09-24
57 reads
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
2 reads
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
1 reads
This post is a response to this month’s T-SQL Tuesday #118 prompt by Kevin Chant. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...
2019-09-19 (first published: 2019-09-10)
1,131 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
3 reads
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
Watch this week’s episode on YouTube. Last week’s post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace....
2019-09-16 (first published: 2019-09-03)
522 reads
Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....
2019-09-12 (first published: 2019-08-27)
1,800 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...
Web Application Development Services. Our highly qualifies and skilled professionals have let us serve...
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