Favorite Question - Badge - Database Administrators Stack Exchange

Favorite Question

Question saved by 25 users. This badge can be awarded multiple times.

Awarded 155 times.

Using MongoDB and PostgreSQL together

Awarded Dec 7, 2022 at 13:26

chucksmash

5351 gold badge6 silver badges9 bronze badges

Cast to date is sargable but is it a good idea?

Awarded Nov 7, 2022 at 14:25

Mikael Eriksson

21.9k4 gold badges58 silver badges103 bronze badges

How do you calculate mysql max_connections variable?

Awarded Oct 13, 2022 at 9:47

Gabriel Solomon

9751 gold badge10 silver badges13 bronze badges

Are individual queries faster than joins?

Awarded Jul 27, 2022 at 12:50

Martin

2,4104 gold badges24 silver badges34 bronze badges

Should I add an arbitrary length limit to VARCHAR columns?

Awarded Jul 12, 2022 at 13:42

Daniel Serodio

1,1192 gold badges11 silver badges13 bronze badges

How to get the name of the current database from within PostgreSQL?

Awarded May 13, 2022 at 5:31

Amelio Vazquez-Reina

1,9872 gold badges13 silver badges8 bronze badges

How to list all constraints of a table in PostgreSQL?

Awarded Apr 27, 2022 at 7:02

Thirumal

2,1083 gold badges12 silver badges24 bronze badges

Aggressive Autovacuum on PostgreSQL

Awarded Apr 10, 2022 at 17:50

CadentOrange

7331 gold badge8 silver badges10 bronze badges

What is the search_path for a given database and user?

Awarded Mar 9, 2022 at 12:26

user664833

1,6591 gold badge18 silver badges19 bronze badges

How to run psql on Mac OS X?

Awarded Jan 24, 2022 at 18:15

Jonas

31.6k27 gold badges59 silver badges64 bronze badges

What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?

Awarded Jan 9, 2022 at 10:36

Abdul Manaf

9,43916 gold badges69 silver badges83 bronze badges

MongoDB using too much memory

Awarded Dec 9, 2021 at 8:50

SpiXel

9111 gold badge9 silver badges13 bronze badges

What is the best way to store an email address in PostgreSQL?

Awarded Dec 1, 2021 at 7:04

Adam Matan

11.1k29 gold badges79 silver badges94 bronze badges

InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6

Awarded Oct 18, 2021 at 22:36

giorgio79

1,3877 gold badges18 silver badges19 bronze badges

restore table from .frm and .ibd file?

Awarded Oct 17, 2021 at 16:11

Tong Wang

5831 gold badge5 silver badges5 bronze badges

What is the default order of records for a SELECT statement in MySQL?

Awarded Aug 23, 2021 at 12:58

daisy

1,2583 gold badges11 silver badges14 bronze badges

Calculating disk space usage per MySQL DB

Awarded Jun 22, 2021 at 4:46

GoldenNewby

6141 gold badge6 silver badges8 bronze badges

Double entry bookkeeping database design

Awarded Jun 2, 2021 at 0:53

Dmitry Kudryavtsev

5091 gold badge5 silver badges7 bronze badges

Granting a user account permission to create databases in PostgreSQL

Awarded May 17, 2021 at 18:48

GSto

2,2432 gold badges13 silver badges6 bronze badges

MySQL Set UTC time as default timestamp

Awarded Apr 16, 2021 at 9:59

Adam Matan

11.1k29 gold badges79 silver badges94 bronze badges

When should you denormalize?

Awarded Mar 23, 2021 at 17:33

Richard

6,3138 gold badges40 silver badges62 bronze badges

SQL Server Agent Jobs and Availability Groups

Awarded Mar 12, 2021 at 17:23

nojetlag

2,8478 gold badges32 silver badges39 bronze badges

MySQL: Create index If not exists

Awarded Feb 9, 2021 at 15:50

Adam Matan

11.1k29 gold badges79 silver badges94 bronze badges

How to drop all connections to a specific database without stopping the server?

Awarded Jan 28, 2021 at 10:36

sorin

1,1523 gold badges10 silver badges14 bronze badges

MySQL Error Reading Communication Packets

Awarded Jan 23, 2021 at 10:05

KM.

1,2694 gold badges14 silver badges20 bronze badges

How to select the first row of each group?

Awarded Jan 8, 2021 at 18:50

BrunoLM

3,3237 gold badges26 silver badges22 bronze badges

DBA first day in a new job - check backups and security - How? what else should be checked?

Awarded Jan 5, 2021 at 14:42

Marcello Miorelli

15.4k50 gold badges140 silver badges272 bronze badges

How restore a specific database from backup using mongorestore command

Awarded Oct 16, 2020 at 22:11

pankaj choudhary

8412 gold badges8 silver badges4 bronze badges

Default value for UUID column in Postgres

Awarded Sep 16, 2020 at 14:32

Basil Bourque

9,94617 gold badges53 silver badges90 bronze badges

SQL server databases stuck in restoring state

Awarded Aug 23, 2020 at 8:17

Pooya Yazdani

1,0931 gold badge8 silver badges7 bronze badges

How to get a working and complete PostgreSQL DB backup and test

Awarded Jul 20, 2020 at 15:56

Ali Razeghi - AWS

7,4581 gold badge23 silver badges37 bronze badges

Difference between On Delete Cascade & On Update Cascade in mysql

Awarded Jun 20, 2020 at 11:34

Smokey

1,0511 gold badge8 silver badges8 bronze badges

What are the arguments against or for putting application logic in the database layer?

Awarded Apr 14, 2020 at 15:25

Phil Lello

1,4491 gold badge11 silver badges9 bronze badges

Function Performance

Awarded Apr 14, 2020 at 15:25

Derek Downey

23.2k11 gold badges77 silver badges104 bronze badges

Connect to sql plus from command line using connection string

Awarded Apr 7, 2020 at 18:25

Edvinas

6311 gold badge6 silver badges3 bronze badges

How to properly format sqlite shell output?

Awarded Mar 26, 2020 at 11:45

Kshitiz Sharma

3,0878 gold badges29 silver badges35 bronze badges

Optimizing a Postgres query with a large IN

Awarded Mar 10, 2020 at 14:50

Garrett

9331 gold badge10 silver badges15 bronze badges

How to estimate/predict data size and index size of a table in MySQL

Awarded Mar 4, 2020 at 11:05

Abdul Manaf

9,43916 gold badges69 silver badges83 bronze badges

How to use psql with no password prompt?

Awarded Feb 7, 2020 at 10:10

Majid Azimi

2,0913 gold badges22 silver badges23 bronze badges

When to use NULL and when to use an empty string?

Awarded Jan 24, 2020 at 11:05

Maniero

2,6586 gold badges27 silver badges29 bronze badges

SQL Server: How to track progress of CREATE INDEX command?

Awarded Dec 2, 2019 at 21:50

Jonesome Reinstate Monica

3,3299 gold badges36 silver badges55 bronze badges

I can't connect to my servers SQL database via an IP Address

Awarded Nov 29, 2019 at 11:15

Shaun S

6831 gold badge6 silver badges6 bronze badges

When to use views in MySQL?

Awarded Nov 15, 2019 at 20:25

David LeBauer

3,1028 gold badges29 silver badges33 bronze badges

How to keep history of SQL Server stored procedure revisions

Awarded Oct 18, 2019 at 6:10

cja

3552 gold badges4 silver badges10 bronze badges

What problems will I get creating a database per customer?

Awarded Sep 20, 2019 at 8:35

Rik Heywood

6731 gold badge6 silver badges6 bronze badges

Best practice between using LEFT JOIN or NOT EXISTS

Awarded Sep 18, 2019 at 17:55

Michael Richardson

1,2352 gold badges9 silver badges9 bronze badges

Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?

Awarded Sep 11, 2019 at 13:45

Paul White♦

78.7k28 gold badges394 silver badges617 bronze badges

Postgres UPDATE ... LIMIT 1

Awarded Aug 15, 2019 at 14:55

vastlysuperiorman

1,4652 gold badges10 silver badges8 bronze badges

Must-read Books for DBA [closed]

Awarded Aug 15, 2019 at 14:40

Maniero

2,6586 gold badges27 silver badges29 bronze badges

PostgreSQL not running on Mac

Awarded Aug 1, 2019 at 10:10

Michael P.

2,0112 gold badges12 silver badges8 bronze badges

When should I rebuild indexes?

Awarded Jul 8, 2019 at 21:55

Nick Chammas

14.5k17 gold badges74 silver badges121 bronze badges

How do I get the current unix timestamp from PostgreSQL?

Awarded Jun 27, 2019 at 16:45

Jonas

31.6k27 gold badges59 silver badges64 bronze badges

How to insert values into a table from a select query in PostgreSQL?

Awarded Jun 19, 2019 at 19:50

Jonas

31.6k27 gold badges59 silver badges64 bronze badges

SQL Server Management Studio 18 won't open (only splash screen pops up)

Awarded Jun 13, 2019 at 8:50

Mitch

2,6182 gold badges17 silver badges23 bronze badges

List the database privileges using psql

Awarded May 23, 2019 at 13:50

pedrosanta

3,0933 gold badges15 silver badges7 bronze badges

PostgreSQL multi-column unique constraint and NULL values

Awarded May 11, 2019 at 4:15

Manuel Leduc

1,5612 gold badges10 silver badges5 bronze badges

Passing array parameters to a stored procedure

Awarded Apr 29, 2019 at 20:30

D. Lambert

1,0571 gold badge8 silver badges8 bronze badges

SQL: SELECT All columns except some

Awarded Apr 9, 2019 at 16:30

Adam Matan

11.1k29 gold badges79 silver badges94 bronze badges

Is it safe to use innodb_flush_log_at_trx_commit = 2

Awarded Mar 11, 2019 at 5:50

Bruce Dou

8151 gold badge9 silver badges8 bronze badges

What risks are there if we enable read committed snapshot in sql-server?

Awarded Jan 30, 2019 at 18:25

Adam Butler

1,5314 gold badges16 silver badges16 bronze badges

2 3 Next