2015-11-09
104 reads
SQLServerCentral
SQLServerCentral Runs sp_Blitz - The Future
After examining the SQLServerCentral servers using the sp_Blitz™ script, Steve Jones now looks at how we will use the script moving forward.
2015-04-30
6,950 reads
SQL Cop and SQLServerCentral
Steve Jones runs the SQL Cop tests against the SQLServerCentral database and looks at the results.
2015-03-23
5,354 reads
A Call for Questions
Our Question of the day is very popular, but we're looking for more complex questions
2014-09-08
642 reads
Write for SQLServerCentral - Bonus for Azure
We're always looking for articles, but here are a few ones that I'd like to see written up.
2016-04-29 (first published: 2014-09-04)
1,974 reads
2014-08-21 (first published: 2014-08-19)
1,650 reads
2014-05-27
1,122 reads
SQL Scripts in SSMS
A new plug in for Management Studio from Red Gate is free. It will give you access to all the scripts at SQLServerCentral, including your own briefcase.
2014-05-15
3,842 reads
Write for SQLServerCentral
We are looking for new content here for the site, based on your experiences in the real world. Submit something and get yourself published.
2014-05-22 (first published: 2014-04-10)
2,002 reads
Did This Work? - Forum Changes at SQLServerCentral
We've made a change to the forums at SQLServerCentral. Learn how you can mark a post as an answer to your question and help others.
2014-02-10
672 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
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