Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let’s take a quick look anyway. Because, you know, it comes up all the time.
Category: TSQL
Generate RESTORE LOG statements
Today, we’re going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files, using Powershell and find-and-replace.
Fix WHERE clause AND/OR/NOT confusion with truth tables
The ANDs, ORs, and NOTs in a T-SQL query’s WHERE clause can get confusing, especially if you’re thinking of it like plain-Jane algebra. Here I show you how to figure out exactly what a query is doing, using truth tables!