select * from SQL - DEV Community

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
A Full Table Scan Isn’t Always a Mistake

A Full Table Scan Isn’t Always a Mistake

Comments
4 min read
One constant was costing my schema retriever 17 points

One constant was costing my schema retriever 17 points

Comments
2 min read
Postgres not using your index? It's counting pages, not rows

Postgres not using your index? It's counting pages, not rows

Comments
10 min read
Find the Departures Your Offboarding Ticket Report Misses with SQLite

Find the Departures Your Offboarding Ticket Report Misses with SQLite

Comments
4 min read
Build a Pre-Deployment Schema Drift Check for SQL Server

Build a Pre-Deployment Schema Drift Check for SQL Server

Comments
5 min read
5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

Comments
4 min read
A refund-aware reorder point model for TikTok Shop SKU planning

A refund-aware reorder point model for TikTok Shop SKU planning

Comments
5 min read
From 9 Seconds to 2 Milliseconds: Database Indexes Explained

From 9 Seconds to 2 Milliseconds: Database Indexes Explained

Comments
6 min read
Creator commission is a cash event, not a percentage

Creator commission is a cash event, not a percentage

Comments
4 min read
Text-to-SQL Agents Answer Questions Nobody Reviewed. Add Receipts

Text-to-SQL Agents Answer Questions Nobody Reviewed. Add Receipts

Comments
5 min read
PostgreSQL errors in your first month, and what they actually mean

PostgreSQL errors in your first month, and what they actually mean

Comments
3 min read
A cast to five bytes and a two-character word

A cast to five bytes and a two-character word

Comments
3 min read
SKU-level contribution margin: a reconciliation model for TikTok Shop ad scaling

SKU-level contribution margin: a reconciliation model for TikTok Shop ad scaling

Comments
5 min read
PostgreSQL Commands – Step-by-Step Guide

PostgreSQL Commands – Step-by-Step Guide

Comments
1 min read
Your language chart changes when bytes get the votes

Your language chart changes when bytes get the votes

Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.