February 1, 2025
It was great to catch up with Joey D’Antoni today and to have him on a SQL Down Under podcast. Joey D’Antoni is an Architect and […]
February 1, 2025
There are two ways you can write common join syntax. There’s an older way to write the query and a new way to write the query. […]
January 31, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
January 31, 2025
The most common form of join between two tables is what’s called an inner join. In the example shown above, I’ve selected some columns from different […]
January 30, 2025
A foreign key is a situation where we store the primary key of one table in another table. It’s very useful. For example, we might need […]
January 29, 2025
In the previous post, we saw how CROSS JOIN operations work. Now it’s rare for us to want to have every combination of the rows in […]
January 28, 2025
The simplest way to join two tables is what’s called a cross-join. So this is where I say from products, cross-join, sales territories. SELECT * FROM […]
January 27, 2025
Most programming languages have some way of forming loops. Now some of them have a variety. For example, a language like Basic had a For Next […]
January 26, 2025
In general, we try to avoid procedural logic when writing T-SQL. However, it is possible. The most basic procedural statement is the IF statement. It allows […]
January 25, 2025
As well as the variables that you declare, SQL Server has a number of built-in system variables and some built-in system functions. The system variables are […]
January 25, 2025
Variables in T-SQL work very much the way they do in other languages. A variable really is nothing more than a name given to a memory […]
October 30, 2024
One of the most popular courses that we used to run in person was a Query Performance Tuning and Advanced T-SQL course. I recently finished converting […]