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.
NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19
franckpachot profile

NOT IN can be executed as an Anti-Join (NOT EXISTS) in PG19

#postgres #sql #database #performance
Comments
7 min read
Apache Iceberg Query Optimization: Production Guide
jonisar profile

Apache Iceberg Query Optimization: Production Guide

#iceberg #dataengineering #snowflake #sql
Comments
40 min read
SQL Database Projects and AI: A Match Made in Heaven
lovelacecoding profile

SQL Database Projects and AI: A Match Made in Heaven

#dotnet #sql #ai #beginners
Comments
8 min read
Window functions vs Aggregate functions
mark_glemba_962f6bc8a12dd profile

Window functions vs Aggregate functions

#analytics #database #datascience #sql
Comments
9 min read
My alert fired 7 times across 1963 pairs. I assumed the thresholds were too high. They were, and it didn't matter
juanauriti profile

My alert fired 7 times across 1963 pairs. I assumed the thresholds were too high. They were, and it didn't matter

#monitoring #database #sql #webdev
Comments
4 min read
Text-to-SQL in Practice: When to Trust AI Output and When to Gate It
databaseinsights profile

Text-to-SQL in Practice: When to Trust AI Output and When to Gate It

#sql #ai #database #devops
Comments 1
4 min read
Oracle SQL: JSON Functions
sandeep-oracle profile

Oracle SQL: JSON Functions

#oracle #oraclesql #sql
Comments
2 min read
Cursor Pagination vs Offset Pagination: Which One Should You Use?
omeiza_ahmed profile

Cursor Pagination vs Offset Pagination: Which One Should You Use?

#backend #database #performance #sql
Comments
3 min read
Same question, same database, two callers
ashish_sinha_5241c7673d93 profile

Same question, same database, two callers

#ai #database #llm #sql
1
Comments
2 min read
38% of an analyst's questions get "no records found" when the data is right there
ashish_sinha_5241c7673d93 profile

38% of an analyst's questions get "no records found" when the data is right there

#sql #ai #database #security
Comments
5 min read
Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs
hafsa_motiwala profile

Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs

#showdev #datascience #database #sql
Comments
4 min read
Oracle SQL: Pseudo-Columns
sandeep-oracle profile

Oracle SQL: Pseudo-Columns

#oracle #oraclesql #sql #plsql
Comments
4 min read
Oracle SQL: Read-Only Tables
sandeep-oracle profile

Oracle SQL: Read-Only Tables

#oracle #oraclesql #sql #plsql
Comments
3 min read
Oracle SQL: Unused Columns & Virtual Columns
sandeep-oracle profile

Oracle SQL: Unused Columns & Virtual Columns

#oracle #oraclesql #sql #plsql
Comments
3 min read
Window Functions vs. Aggregate Functions in SQL (With Examples)
ericmwaimiri profile

Window Functions vs. Aggregate Functions in SQL (With Examples)

#database #programming #sql #tutorial
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.