SUM DISTINCT totals different amounts without checking order identity. I’d establish the row grain first. Compare equal-priced orders, repeated copies and missing amounts.
SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
Why is SQL Server Agent starting before SQL Server Engine service? A user group member asked me, and here are my quick reasons, from jobs to OS tasks.
SQL SERVER – Backup master Database Interval – master Database Best Practices
How often should you back up master? It holds logins and server settings, so here are my master database best practices for backup timing.
SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
Is there any real world reason to list a missing identity in a table? Readers had no new script, but a lively discussion on whether gaps matter.
Modulo: Negative Values Keep the Dividend Sign
Modulo can return a negative remainder for a negative dividend. A second expression normalizes a positive-divisor bucket while keeping the original input and remainder visible.
SQLAuthority News – Interview with SQL Server MVP Glenn Berry
My interview with SQL Server MVP Glenn Berry, Database Architect at NewsGator and longtime SQL Server teacher at University of Denver.
SQL Server – Multiple CTE in One SELECT Statement Query
How do you use multiple CTE in one SELECT statement? Two simple examples: independent CTEs joined together, and a second CTE built on the first.