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.
Data Cleaning and Analysis with SQL
alex_murithi profile

Data Cleaning and Analysis with SQL

#sql #database #datascience
1
Comments
5 min read
Plataforma gratuita para practicar SQL en español
rozhnev profile

Plataforma gratuita para practicar SQL en español

#spanish #sql #database #learning
1
Comments
1 min read
How to Solve a Month-over-Month Churn SQL Interview Question
rahmanfrr profile
Rahman

How to Solve a Month-over-Month Churn SQL Interview Question

#sql #dataengineering #interviewprep #amazon
Comments
4 min read
Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map
arnavsharma2711 profile

Your Index Only Scan Is Lying: Covering Indexes and the Visibility Map

#database #postgres #sql #performance
Comments
4 min read
Composite Indexes Explained: Why Column Order Is the Whole Game
arnavsharma2711 profile

Composite Indexes Explained: Why Column Order Is the Whole Game

#database #sql #postgres #backend
Comments
4 min read
QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway.
tracepointdata profile

QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway.

#snowflake #sql #dataengineering #database
2
Comments 2
4 min read
How Database Indexes Work (And Why Yours Might Be Useless)
arnavsharma2711 profile

How Database Indexes Work (And Why Yours Might Be Useless)

#database #programming #sql
Comments
6 min read
Building Answer Lineage for Enterprise Data Agents
arisyn profile

Building Answer Lineage for Enterprise Data Agents

#ai #llm #sql #data
1
Comments
5 min read
SQL Is Surviving, Franklin: Now Rows Are Competing
ms_njenga profile

SQL Is Surviving, Franklin: Now Rows Are Competing

#database #programming #sql
4
Comments 2
11 min read
The SQL Worked Perfectly. The Data Was Wrong.
eduardo-ortega profile

The SQL Worked Perfectly. The Data Was Wrong.

#sql #database #debugging #programming
Comments 2
5 min read
Why I Built a SQL Practice Platform with Zero Backend Compute
rahmanfrr profile
Rahman

Why I Built a SQL Practice Platform with Zero Backend Compute

#webdev #architecture #sql #webassembly
Comments
3 min read
Making SSMS Smarter: Building a Productive T-SQL Workflow with Snippets and Code Analysis
databaseinsights profile

Making SSMS Smarter: Building a Productive T-SQL Workflow with Snippets and Code Analysis

#sql #database #sqlserver #productivity
3
Comments 2
6 min read
Stop Sending Every SQL Query to Your Most Expensive Model — Build a Router Instead
davidmurray profile

Stop Sending Every SQL Query to Your Most Expensive Model — Build a Router Instead

#ai #database #sql #architecture
3
Comments 1
4 min read
Solving the Classic SQL "Gaps and Islands" Problem: 3 Modern Approaches
rahmanfrr profile

Solving the Classic SQL "Gaps and Islands" Problem: 3 Modern Approaches

#sql #database #tutorial #programming
Comments 2
5 min read
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17
aleksander_frolov profile

One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17

#performance #postgres #mysql #sql
Comments 3
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.