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

What's the Ceiling?

Comparing Images

Using Outer Joins

Optimize SQL LIKE Wildcard Searches

Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.

The LAGging NULL

No Renames

The LAGing data

Troubleshoot Chained SQL Server CTE

This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.