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.
How to find and fix slow PostgreSQL queries

How to find and fix slow PostgreSQL queries

1
Comments
10 min read
ORA-01652: Unable to Extend Temp Segment. Don't Just Add Space.

ORA-01652: Unable to Extend Temp Segment. Don't Just Add Space.

Comments
11 min read
MySQL or PostgreSQL, Does It Matter to Choose Which?

MySQL or PostgreSQL, Does It Matter to Choose Which?

Comments
3 min read
My SQL JOIN Ran Perfectly and Doubled the Refunds

My SQL JOIN Ran Perfectly and Doubled the Refunds

Comments
9 min read
MySQL Workbench Alternative: ER Diagrams Past 250 Tables

MySQL Workbench Alternative: ER Diagrams Past 250 Tables

Comments
10 min read
5 rules we used to turn 164,963 daily follower readings into one honest growth number

5 rules we used to turn 164,963 daily follower readings into one honest growth number

Comments 1
3 min read
Filtering Data in SQL: A Beginner's Guide to WHERE, IN, BETWEEN, NULL, and LIKE

Filtering Data in SQL: A Beginner's Guide to WHERE, IN, BETWEEN, NULL, and LIKE

1
Comments 1
3 min read
We turned down 802 of 1,051 companies. Here is the SQL to read your own reject reasons

We turned down 802 of 1,051 companies. Here is the SQL to read your own reject reasons

Comments
3 min read
I compared four ways to pick tables for a text-to-SQL prompt

I compared four ways to pick tables for a text-to-SQL prompt

Comments
2 min read
An alias that walked past my SQL guard: red-teaming an MCP server for warehouse access

An alias that walked past my SQL guard: red-teaming an MCP server for warehouse access

Comments 1
7 min read
SQL OPERATOR WEEK 2 21ST-22ND NOVEMBER

SQL OPERATOR WEEK 2 21ST-22ND NOVEMBER

Comments
2 min read
Your location join gives some job ads extra salary votes

Your location join gives some job ads extra salary votes

Comments
7 min read
Second Highest Salary in SQL: 4 Ways, and Which Ones Quietly Break

Second Highest Salary in SQL: 4 Ways, and Which Ones Quietly Break

1
Comments 1
5 min read
SQL SELECT Statement: Practical Examples for Interview Preparation

SQL SELECT Statement: Practical Examples for Interview Preparation

Comments
4 min read
SQL basics

SQL basics

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.