Refreshing a View

More OUTER APPLY

Get the Most Current Row From a Detail Table

This article compares the performance of finding the most recent row in a child table for updates, looking at four possible solutions.

OUTER APPLY

Starter Metadata T-SQL Query Examples for Databases and Tables

SQL Server provides lots of information about various aspects of server and database objects and this data is referred to as metadata. Understanding what is available and how to use this metadata can greatly enhance and streamline how you can work with SQL Server.

Missing Chinese Surnames

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