Sql

Use LIKE %..% with field values in MySQL

text-search-operations

performance-optimisation

Group MySQL query by 15 min intervals

mysql-performance

Alter DATABASE failed because a lock could not be placed on database

database-administration

Filter Table Before Applying Left Join

index-optimization

What is a good reason to use SQL views?

data-abstraction

database-management

Find a string by searching all tables in SQL Server

database-optimization

Sql, Auxiliary table of numbers

Mysql: Select DISTINCT / UNIQUE, but return all columns?

sql-performance

Are PostgreSQL column names case-sensitive?

database-migration

Mysql: GROUP_CONCAT with LEFT JOIN

performance-tuning

Having issues with a MySQL Join that needs to meet multiple conditions

How to do select from where x is equal to multiple values?

Postgresql query between date ranges

database-optimization

Convert Rows to columns using 'Pivot' in SQL Server

pivot-engineering

Sql Server - transactions roll back on error?

transactional-anomalies

try-catch-block

Library of Useful (Difficult) SQL scripts

performance-optimization

Mysql: Typecasting NULL to 0

database-optimizations

Update MySQL with if condition

conditional-updates

database-performance

How to COALESCE for empty strings and NULL values?

performance-optimization

Sql Joins Vs SQL Subqueries (Performance)?

explain.codes / Sql