Explain Codes LogoExplain Codes Logo

Sql

Sql Server: Extract Table Meta-Data (description, fields and their data types)

sql
metadata
database-management
sql-server

How to compare datetime with only date in SQL Server

sql
best-practices
performance
join

Quick selection of a random row from a large table in MySQL

sql
join
indexing
performance

Join between tables in two different databases?

sql
cross-database-join
database-optimization
sql-performance

Can I Comma Delimit Multiple Rows Into One Column?

sql
string-aggregation
query-optimization
sql-techniques

Sql Left Join first match only

sql
join
subqueries
performance

Full OUTER JOIN vs. FULL JOIN

sql
join
data-quality
query-optimization

Is there common street addresses database design for all addresses of the world?

sql
database-design
geocoding
data-normalization

Postgresql Index Usage Analysis

sql
database-performance
index-optimization
postgresql

Check for changes to an SQL Server table?

sql
checksums
change-detection
sql-server

How to get current instance name from T-SQL

sql
server-properties
sql-server
database-management

Where statement after a UNION in SQL?

sql
sql-performance
best-practices
query-optimization

Using a Single Row configuration table in SQL Server database. Bad idea?

sql
best-practices
schema-design
database-optimization

What is Ad Hoc Query?

sql
ad-hoc-queries
sql-performance
database-optimization

How do you create a temporary table in an Oracle database?

sql
database-design
performance-optimization
sql-queries

How to write a WHERE Clause to find all records in a specific month?

sql
join
best-practices
performance

Mysql Sum() multiple columns

sql
join
performance
best-practices

Export database schema into SQL file

sql
database-schema
sql-server
scripting

How to change the column position of a MySQL table without losing column data?

sql
database-structure
backup-plan
sql-alter-table

Cannot get simple PostgreSQL insert to work

sql
database-engineering
sql-best-practices
postgresql-tips