2001-04-22
5,260 reads
Articles
Quickly Disconnect Users
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
2001-04-21
18,145 reads
Automatically Gathering Server Information Part 3
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-20
11,223 reads
Process Tracking
It is not always possible to run a process on a set schedule. This article by Steve Jones looks at a technique for ensuring that your processes can run on whenever you need them to without any loss of data.
2001-04-18
4,756 reads
Tame Those Strings! Part 3 - Using REPLACE
The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.
2001-04-18
17,118 reads
Tame Those Strings! Part 4 - Numeric Conversions
The fourth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with numeric conversions.
2001-04-18
9,514 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
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