2023-06-30
462 reads
T-SQL
Paging Data in T-SQL
This article will show you how to page through a set of results using the OFFSET and FETCH options of the ORDER BY clause.
2023-06-28
2023-06-26
490 reads
Same Language, Different Words
I had to come to the Redgate office in Cambridge this past week for a department onsite. As a result, my wife and I were able to come early for a few days adventuring together, the first trip we've taken by ourselves in nearly seven years. As a large family with six kids, it takes […]
2023-06-17
135 reads
Horizontal Trees
Introduction The sp_HorizontalTree procedure introduced here may be used to audit tables with dependent columns. A column is dependent on another if the meaning of the first column depends on the meaning of the second. For example, in a table containing accounting information, the meaning of a Fiscal Quarter column depends on the Fiscal Year to […]
2023-06-16
2,417 reads
2023-06-05
360 reads
2023-05-22
403 reads
Common Table Expression Basics
Learn the basics of how CTEs work with a few examples in this article.
2023-05-31 (first published: 2023-05-19)
5,842 reads
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.
2023-05-19
2023-05-15
392 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers