Four bytes look like a bargain until a total comes out wrong. Watch real round, overflow and drift, then decide when decimal is the safer pick.
CROSS JOIN: Duplicate Inputs Multiply the Result
CROSS JOIN multiplies row counts, including repeated labels. Keep source identifiers and grouped pair counts visible while checking result grain.
SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers
A SQL enthusiast at the airport asked for a simple way to find maximum between two numbers. Here is his clever ABS formula and my CASE version.
Tabular Models for the SQL Developer
Tabular models for the SQL developer add relationships, measures, security, and reusable semantics above SQL tables; learn when a view is enough.
Summary Tables: Keeping Pre-Aggregated Totals Current
Keep summary tables current with changed-day rebuilds, handle late arrivals and deletes, and reconcile stored totals against detail.
SQL SERVER – SSAS – Multidimensional Space Terms and Explanation
At a Tech Ed On Road session I was asked to explain multidimensional space in simple words. Here are dimension, member, value, attribute and size.
Data Integration Patterns Without Special Tools
Data integration patterns in SQL Server cover full reloads, incremental pulls, change capture, and file drops with clear restart rules.