Splitting It Up: Side by Side Queries In SSMS
There are times when you are writing a query while referencing another piece of information: the results of another query,...
2018-02-27
276 reads
Bert Wagner
OR vs UNION ALL - Is One Better For Performance?
Today I want to show you a trick that could make your queries run faster.
It won't always work, but when it does everyone will be impressed with your performance...
2018-02-20
OR vs UNION ALL – Is One Better For Performance?
Today I want to show you a trick that could make your queries run faster.
It won’t always work, but when...
2018-02-20
196 reads
What I Do When I’m NOT Writing SQL
This post is a response to this month’s T-SQL Tuesday prompt created by Aaron Bertrand. Adam Machanic created T-SQL Tuesday...
2018-02-13
127 reads
What I Do When I'm NOT Writing SQL
This post is a response to this month's T-SQL Tuesday prompt created by Aaron Bertrand. Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas...
2018-02-13
"How do I contribute to dbatools?" with Drew Furgiuele
Watch this week's video on YouTube
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.
If...
2018-02-06
“How do I contribute to dbatools?” with Drew Furgiuele
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...
2018-02-06
104 reads
The Fastest Way To Locate Errors In Your SQL Query
Photo by N. on UnsplashIn about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming...
2018-01-30
1,788 reads
The Fastest Way To Locate Errors In Your SQL Query
In about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.
Coming from a .NET background, I'm used to receiving relatively helpful...
2018-01-30
2 reads
Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule
Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...
2018-01-23
435 reads
Blogs
My 2024 in Data: Health and Workouts
By Steve Jones
This is my last week of the year working (I guess I come back...
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...
Forums
Windows could not start the SQL server (SQLEXPRESS) service (macOS)
I have a common problem that I just cannot figure out after scrolling through...
Adventureworks data does not load
Hello, I am a new member here so forgive me if I am not...
Restore Procedure not working
I created a small procedure that reads the backup file and restores the DB...
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