Read SHOW_STATISTICS headers, density and histogram boundaries, compare estimates with your plan, and query the histogram directly.
Counting Rows per Month With Zero-Filled Gaps
Build monthly counts with zero-filled gaps, generate a complete month range, and retain empty categories through a reporting scaffold.
Ranking Items by Rating Fairly With a Bayesian Average
Use Bayesian average in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.
Developer – 10 Phrases Developer Use Too Often
I am a developer and so are most of my friends. Here are 10 phrases every developer says too often, from ‘I can fix that’ to ‘That’s not my code’.
SQL Server Performance Stack: Look Beyond the Query
Tuned every query and SQL Server is still slow? David Klee looks at the SQL Server performance stack, from storage and virtualization to the network. He also explains why a baseline matters.