GENERATE_SERIES returns numbers within a declared range. These read-only examples specify the step, preserve input types and order every returned series deliberately.
SQL SERVER – Parallelism Query in Database
Feodor asked how to get a parallelism query plan on a dual core computer using AdventureWorks. Here is the T-SQL I used to reproduce a parallel plan.
Relational Division in T-SQL: Customers Who Bought Every Product
Solve relational division with counts and double NOT EXISTS, then handle duplicates, NULL values, empty requirements, and exact matching.
SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example
BINARY_CHECKSUM helps detect changes in a row. My working example shows how it works and why it misses a value changed from A to B and back to A.
geometry STDifference: Keep the Subtraction Direction
geometry STDifference is directional. Two overlapping equal-area rectangles can produce equal remaining areas while retaining entirely different regions.
SQL Tips – 5 SQL Server Best Practices
5 SQL Server Best Practices worth a quick check, starting with backing up the master database and testing it, and rebuilding indexes online to cut downtime.
SQL SERVER – Check Advanced Server Configuration
How do you Check Advanced Server Configuration values? Turn on show advanced options with sp_configure, run RECONFIGURE, then run sp_configure to list them.