Subqueries II

Calculate a Moving Average with T-SQL Windowing Functions

Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.

More Funny SELECTs

The Funny SELECTs

SQL IS NULL and SQL IS NOT NULL Examples

This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.

A Strange Query

Running Steve's Code

New SQL Server 2022 Functions

There were a number of T-SQL functions added in SQL Server 2022. Today Steve asks if you are using any of these in your work.

Should That Be One Update Statement or Multiple?

Let’s say we have a couple of update statements we need to run every 15 minutes in the Stack Overflow database, and we’ve built indexes to support them:

A Strange Result