Faking Temporal Tables with Triggers
This post is a response to this month's T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-09-11
21 reads
Bert Wagner
Faking Temporal Tables with Triggers
This post is a response to this month's T-SQL Tuesday #106 prompt by Steve Jones. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-09-11
12 reads
Does The Order Of Index Columns Matter?
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance...
2018-09-13 (first published: 2018-09-04)
5,036 reads
Does The Order Of Index Columns Matter?
Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...
2018-09-04
9 reads
Does The Order Of Index Columns Matter?
Watch this week's video on YouTube
When beginning to learn SQL, at some point you learn that indexes can be created to help improve the performance of queries.
Creating your first...
2018-09-04
17 reads
Ignoring NULLs with FIRST_VALUE
Watch this week’s episode on YouTube.
The SQL Server FIRST_VALUE function makes it easy to return the “first value in an...
2018-08-28
9,018 reads
Ignoring NULLs with FIRST_VALUE
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
25 reads
Ignoring NULLs with FIRST_VALUE
Watch this week's video on YouTube
The SQL Server FIRST_VALUE function makes it easy to return the "first value in an ordered set of values."
The problem is that if that...
2018-08-28
29 reads
FizzBuzz and Multiple Recursive Member CTEs
Watch this week’s episode on YouTube.
Last week I needed to write a recursive common table expression. I’ve written them before,...
2018-09-07 (first published: 2018-08-21)
2,366 reads
FizzBuzz and Multiple Recursive Member CTEs
Watch this week's video on YouTube
Last week I needed to write a recursive common table expression. I've written them before, but it's been a while and needed to visit...
2018-08-21
19 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers