Learn four practical window functions with SQL examples for numbering rows, ranking ties, comparing previous values, and calculating running totals.
SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server
A common question I get: how do you go about detecting low disk space on SQL Server? Here are two ways, including xp_fixeddrives, and the one I prefer.
A Crossword Helper in T-SQL: Matching Word Patterns With LIKE
Match word patterns with LIKE and SUBSTRING, build sorted-letter anagram signatures, and use a leading-letter index for crossword searches.
SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055
Need SQL Server to wait before it runs the next statement? This SQL in Sixty Seconds video shows the delay command, WAITFOR DELAY, in action.
SQL – Difference Between INNER JOIN and JOIN
INNER JOIN and JOIN express the same inner join in this T-SQL syntax. I prefer spelling out the join type for readability.
Comparing Two Copies of a Table With CHECKSUM_AGG and HASHBYTES
Use CHECKSUM_AGG for a quick table-copy signal, then compare canonical HASHBYTES values and key ranges to locate real data differences.
What to Look For in a SQL Client Tool
Choose a SQL client tool by testing result handling, execution plans, transactions, and connection identity before trusting it with real work.