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.

Catching a Deleted Column

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 […]

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 […]

Refresh Limits

Picking the Backup to Restore

Common Table Expression Basics

Learn the basics of how CTEs work with a few examples in this article.

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.

Refreshing Modules

Find 40 Problems in this SQL Server Stored Procedure

I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why.