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.
7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀
abdelrahmanallam profile

7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀

#sql #performance #database
32
Comments 4
4 min read
Building a Node.js Server with Microsoft SQL Database Integration
unlikelycreator profile

Building a Node.js Server with Microsoft SQL Database Integration

#node #sql #mssql #react
1
Comments
2 min read
How to Query 1st, 2nd, or Nth Largest attribute in SQL Table
muneebkhan4 profile

How to Query 1st, 2nd, or Nth Largest attribute in SQL Table

#sql #postgres #backend #webdev
Comments
3 min read
Postgres Concurrency : What could go wrong (part 1)
yet_anotherdev profile

Postgres Concurrency : What could go wrong (part 1)

#postgres #sql
9
Comments
4 min read
How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench
alumassy profile

How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench

#mysql #database #dataanalysis #sql
53
Comments 1
2 min read
SAS Function setDateByNumberBDays
vanhurter profile

SAS Function setDateByNumberBDays

#sas #sql #proc
2
Comments
1 min read
SAS Function isBrHolidayworkingDaysBetweenDates
vanhurter profile

SAS Function isBrHolidayworkingDaysBetweenDates

#sas #sql #proc
2
Comments
1 min read
SAS Functions previous and next BusinessDay
vanhurter profile

SAS Functions previous and next BusinessDay

#sas #sql #datefunctions #proc
Comments
1 min read
Create Stored Procedures using Embedded Python
intersystemsdev profile

Create Stored Procedures using Embedded Python

#python #sql #beginners #tutorial
2
Comments
5 min read
MySQL Basic Select challenges
sn0wf1re profile

MySQL Basic Select challenges

#sql #mysql
Comments
2 min read
Managing Calendar Availability in Supabase with SQL generate_series
ivaaan profile

Managing Calendar Availability in Supabase with SQL generate_series

#tutorial #postgres #sql #react
3
Comments
3 min read
SQL Constraints 101: Ensuring Data Accuracy and Integrity
aviatorifeanyi profile

SQL Constraints 101: Ensuring Data Accuracy and Integrity

#sql #database #data #datascience
1
Comments 4
6 min read
SAS Function isBrHoliday
vanhurter profile

SAS Function isBrHoliday

#sas #sql #datefunctions #procfcmp
2
Comments
1 min read
SAS Function isBusinessDay
vanhurter profile

SAS Function isBusinessDay

#sas #sql #datefunctions #proc
2
Comments
1 min read
pg_hint_plan in views? No. But in UDFs, Yes
franckpachot profile

pg_hint_plan in views? No. But in UDFs, Yes

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