SQL tips that query better
Joins, indexes, and query notes that make the database work for you.
ActiveRecord: Use efficient queries for counting
Jon Tai
·
0 responses
·
ruby, rails, activerecord, sql
How to join 2 csv like SQL tables
Nicolas RAMY
·
0 responses
·
sql, csv, join
Generate drop table command for user schema PL/SQL
Mite Mitreski
·
0 responses
·
sql, oracle, plsql
Sql Server Datetime Tips and Tricks
Rick Pearson
·
0 responses
·
sql, mssql, datetime
Migrating from SQL Server 2012 to 2008
Chad Feldmann
·
0 responses
·
sql, sql server, migration
Where does your SQL FILESTREAM data live?
Darren Fuller
·
0 responses
·
sql, filestream
ORACLE: AGGREGATING SQL STATEMENT RESULTS AS SINGLE XML CLOB
Maxim Kalina
·
0 responses
·
sql, oracle, database, xml
Find out that two segments intersecting or not
Eugeniy Belyaev
·
0 responses
·
sql, range intersection
change sql table column on heroku
Yasser Arafa
·
0 responses
·
rails, heroku, sql
Querying database from inside Vim
Wojtek Ryrych
·
0 responses
·
vim, sql
SQL Server quick tip
Gilberto Ramirez
·
0 responses
·
sql, queries
Make Rails Console to show ActiveRecord SQL calls
Daniel Kosalla
·
0 responses
·
ruby, rails, sql, debugging
Stay away from NULL
marcello righelli
·
2 responses
·
sql, database
Date Format
k2t0f12d
·
0 responses
·
sql
Exception Handling in SQL Server
Mark Gella
·
0 responses
·
sql, server, 2008
Temporarily "disable" all users in Django
Davur S. Clementsen
·
0 responses
·
django, auth, sql
Counting shared tags with a SQL view
Charles Hoffman
·
0 responses
·
ruby, mysql, rails, sql
Postgres SQL Function with a LIKE
Anders Brownworth
·
0 responses
·
sql, postgres
GETTING N-TH MAXIMUM ROW WITH SQL
Maxim Kalina
·
0 responses
·
sql, database
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#
Coderwall Dev Community
Explore the all-time favorite tutorials, design patterns and engineering guides that thousands of readers keep sharing and coming back to, year after year.
These proven techniques, reusable code samples, programming tips and vibe coding habits earned their place through steady views and member likes.
Each entry here is still useful today, covering programming languages, frameworks and workflows that stay relevant long after they were first published.
Whether you're new to a tech stack or an experienced engineer refreshing your skills, start with the most useful tips our dev community members recommend and build on solid, well-tested coding knowledge.