Databases & DBA

Operate databases for reliability and speed. Learn backups, replication, HA/DR, indexing strategies, query tuning, security, auditing, and capacity planning. Get checklists and runbooks that keep production systems healthy and compliant.

Total Questions: 3.4k

Ask a question or start a discussion

Post

Article Video EBook

Show Thread for

Page Size

Answers

Full and inner joiun

Himha

13.2k

Answer

How to update one by string field in mongo.

Anton Gridushko

803

Answers

How can I get a dump of all tables DDL?

Dhawan

948

Answers

Create and Drop view in MySQL

Dipa Mehta

1.1k

Answers

How to create view in sql server?

Pawan Shukla

1.5k

Answers

Write a query to output the apartments whose prices are greater than t

Nabin Agarwala

4.6k

Answers

Any way to check creation or last updated date of index in postgres?

Mallesh Mallu

801

Answers

query has taken the wrong joins and I am not able to stop it

Mallesh Mallu

755

Answers

some error on log postgresql: "LOG: could not fork new process for co

Sanjay Kumar

810

Answers

how can I know the exact command to create those users?

Sanjay Kumar

700

Answers

I am running a SQL dump file and im getting this error: insert or upda

Sanjay Kumar

709

Answer

Do MySQL & postgres overlapping features have all same syntax or not a

Sanjay Kumar

746

Answers

MySQL community server witch performance better on windows or Linux ?

Dhawan

730

Answer

How to convert string "Metro Train" to "Train Metro" in postgresql

Nabin Agarwala

663

Answers

How do i install postgresql on MAC OS

Prajwal Kp

782

Answers

migrate MS SQL database to mysql.

Rakesh

923

Answer

if I don't specify db name to pg_dump and just run pg_dump > file.sql

Sanjay Kumar

652

Answers

Which datatype shall i use for mobile number in postgresql

Hrasha

889

Answers

Can someone explain what is lock pages in memory

Hrasha

668

Answer

What's the difference between restoring a dump file with pg_restore or

Nayak

640

- of 1048

Insert Link

Embed YouTube Video

Table Options

Insert Image

Full and inner joiun

How to update one by string field in mongo.

How can I get a dump of all tables DDL?

Create and Drop view in MySQL

How to create view in sql server?

Write a query to output the apartments whose prices are greater than t

Any way to check creation or last updated date of index in postgres?

query has taken the wrong joins and I am not able to stop it

some error on log postgresql: "LOG: could not fork new process for co

how can I know the exact command to create those users?

I am running a SQL dump file and im getting this error: insert or upda

Do MySQL & postgres overlapping features have all same syntax or not a

MySQL community server witch performance better on windows or Linux ?

How to convert string "Metro Train" to "Train Metro" in postgresql

How do i install postgresql on MAC OS

migrate MS SQL database to mysql.

if I don't specify db name to pg_dump and just run pg_dump > file.sql

Which datatype shall i use for mobile number in postgresql

Can someone explain what is *lock pages in memory*

What's the difference between restoring a dump file with pg_restore or

Can someone explain what is lock pages in memory