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.
Custom ordering without custom SQL with Ruby on Rails 7
jetthoughts_61 profile

Custom ordering without custom SQL with Ruby on Rails 7

#ruby #rails #webdev #sql
6
Comments
2 min read
Order-based Group Operations (I)
esproc_spl profile
Judy

Order-based Group Operations (I)

#devops #opensource #softwaredevelopment #sql
5
Comments
6 min read
Calling all beginners: simple SQL challenge
joolsmcfly profile

Calling all beginners: simple SQL challenge

#tutorial #codenewbie #sql
Comments
2 min read
Materialized View to improve the performance of complex queries?
sardarmudassaralikhan profile

Materialized View to improve the performance of complex queries?

#sqlserver #database #sql #programming
1
Comments
3 min read
Maximizing Database Efficiency Mastering Query Optimization in SQL
sardarmudassaralikhan profile

Maximizing Database Efficiency Mastering Query Optimization in SQL

#sql #sqlserver #softwaredevelopment #dataengineering
Comments
2 min read
WEREWOLF WEED
christiecamp profile

WEREWOLF WEED

#javascript #sql #100daysofcode #digitalgremlin
1
Comments
1 min read
Why do we NOLOCK in SQL server with an example
sardarmudassaralikhan profile

Why do we NOLOCK in SQL server with an example

#sql #sqlserver #database #softwaredevelopment
1
Comments
1 min read
Why do we NOLOCK AND LOCK in SQL server with an example
sardarmudassaralikhan profile

Why do we NOLOCK AND LOCK in SQL server with an example

#webdev #programming #database #sql
Comments
1 min read
Database server communication and data migration from one database to another server database in SQL server
sardarmudassaralikhan profile

Database server communication and data migration from one database to another server database in SQL server

#webdev #programming #sql #databse
Comments
2 min read
Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement
sardarmudassaralikhan profile

Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

#sql #sqlserver #sqlservermanagemnet #database
Comments
1 min read
How to create and configure a linked server in SQL Server Management Studio
sardarmudassaralikhan profile

How to create and configure a linked server in SQL Server Management Studio

#sql #sqlserver #database #linkserver
Comments
2 min read
SQL Math Functions with Use Cases
ashsajal profile

SQL Math Functions with Use Cases

#sql #mysql #postgressql #database
3
Comments 3
2 min read
Using SQLite to Examine Data Relationships and Compare Tables
jimgrimes86 profile

Using SQLite to Examine Data Relationships and Compare Tables

#sql #beginners
Comments
7 min read
Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning
namsi profile

Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

#database #postgres #sql #datamanagement
3
Comments
4 min read
Embedded Python Stored Procedure
intersystemsdev profile