Compare quartiles from PERCENTILE_CONT with NTILE row buckets, calculate interquartile range, and flag candidates beyond 1.5 IQR.
Why FLOAT Math Does Not Add Up in T-SQL Queries
See why FLOAT math produces approximate sums and comparisons in SQL Server, then use DECIMAL or tolerance checks for the right data.
Weighted Averages in T-SQL
Calculate weighted averages with matching numerator and denominator populations, decimal arithmetic, NULL rules, and calendar windows.
Splitting an Amount Across Rows Without Losing a Cent
Make splitting an amount preserve every cent by checking rounded shares, allocating weighted remainders, and documenting deterministic ties.
Extract Decimal Part of a Number in SQL Server
To extract decimal part of a number in SQL Server, use ABS(value) % 1. This post compares four methods on positive and negative amounts and explains why the result is sometimes 0. It also covers float columns, digits as whole numbers and trailing zeros.
Constant Folding: Expressions the Optimizer Solves Before Running
SQL Server does the math on your literals once, while it builds the plan. Here is where that helps, and where it quietly stops.
What a Data Scientist Does: The Skills That Still Matter
What a data scientist does is turn a vague question into an answer that people can trust and act on. This post walks through the work as a loop, and shows the summary statistics step in T-SQL on a small bike rental log.