Great Question - Badge - Database Administrators Stack Exchange

Great Question

Question score of 100 or more. This badge can be awarded multiple times.

Awarded 81 times.

How do I insert a row which contains a foreign key?

Awarded Jun 6 at 23:57

Stéphane

5,6655 gold badges19 silver badges13 bronze badges

Very slow DELETE in PostgreSQL, workaround?

Awarded Feb 20 at 15:15

jd.

1,1622 gold badges8 silver badges6 bronze badges

Difference between On Delete Cascade & On Update Cascade in mysql

Awarded Dec 7, 2023 at 20:11

Smokey

1,1312 gold badges8 silver badges8 bronze badges

Difference between now() and current_timestamp

Awarded Oct 4, 2023 at 8:07

JohnMerlino

1,8595 gold badges19 silver badges21 bronze badges

What is the search_path for a given database and user?

Awarded Aug 7, 2023 at 12:21

user664833

1,9392 gold badges21 silver badges19 bronze badges

How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora

Awarded Feb 1, 2023 at 18:43

Louis Rhys

1,2654 gold badges11 silver badges8 bronze badges

Postgres Count with different condition on the same query

Awarded Nov 29, 2022 at 9:12

jackhammer013

1,4592 gold badges12 silver badges11 bronze badges

Retrieving n rows per group

Awarded Nov 23, 2022 at 14:57

Paul White♦

88.3k30 gold badges417 silver badges655 bronze badges

How to run psql on Mac OS X?

Awarded Oct 14, 2022 at 17:45

Jonas

33.5k27 gold badges61 silver badges64 bronze badges

Best practice between using LEFT JOIN or NOT EXISTS

Awarded Aug 25, 2022 at 10:34

Michael Richardson

1,4552 gold badges10 silver badges9 bronze badges

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

Awarded Jul 25, 2022 at 15:56

daisy

1,3283 gold badges11 silver badges16 bronze badges

What is faster, one big query or many small queries?

Awarded Jun 9, 2022 at 2:57

sudo.ie

1,3112 gold badges9 silver badges5 bronze badges

Difference between database vs user vs schema

Awarded Jun 1, 2022 at 20:45

Ravi

1,5554 gold badges15 silver badges20 bronze badges

Connect to SQL Server with Windows Authentication in a different domain

Awarded May 30, 2022 at 14:41

stergosz

1,2052 gold badges10 silver badges7 bronze badges

How to list all constraints of a table in PostgreSQL?

Awarded Mar 9, 2022 at 11:56

Thirumal

2,4983 gold badges14 silver badges24 bronze badges

Default value for UUID column in Postgres

Awarded Nov 19, 2021 at 3:07

Basil Bourque

10.9k20 gold badges61 silver badges95 bronze badges

How to turn JSON array into Postgres array?

Awarded Oct 26, 2021 at 16:41

Christoph

1,6032 gold badges12 silver badges8 bronze badges

Safest way to perform mysqldump on a live system with active reads and writes?

Awarded Oct 16, 2021 at 2:30

user784637

1,2452 gold badges9 silver badges7 bronze badges

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

Awarded Aug 26, 2021 at 8:51

Maniero

2,7486 gold badges28 silver badges29 bronze badges

How to use psql with no password prompt?

Awarded Jul 11, 2021 at 18:01

Majid Azimi

2,3013 gold badges23 silver badges24 bronze badges

Best database and table design for billions of rows of data [closed]

Awarded May 26, 2021 at 4:33

Gecata

1,3133 gold badges9 silver badges5 bronze badges

Is adding the ‘tbl’ prefix to table names really a problem?

Awarded May 19, 2021 at 21:00

Racer SQL

7,43614 gold badges73 silver badges134 bronze badges

MySQL any way to import a huge (32 GB) sql dump faster?

Awarded Apr 23, 2021 at 13:58

SBhojani

1,4233 gold badges10 silver badges4 bronze badges

Is a composite index also good for queries on the first field?

Awarded Mar 13, 2021 at 6:27

Luciano

1,7413 gold badges12 silver badges8 bronze badges

Difference between Sharding And Replication on MongoDB

Awarded Mar 9, 2021 at 18:10

Saad Saadi

1,4212 gold badges10 silver badges7 bronze badges

PostgreSQL not running on Mac

Awarded Feb 23, 2021 at 17:56

Michael P.

2,1112 gold badges14 silver badges8 bronze badges

How can I specify the position for a new column in PostgreSQL?

Awarded Jan 4, 2021 at 14:02

Jonas

33.5k27 gold badges61 silver badges64 bronze badges

Postgres UPDATE ... LIMIT 1

Awarded Nov 19, 2020 at 17:20

vastlysuperiorman

1,5952 gold badges10 silver badges8 bronze badges

How to properly format sqlite shell output?

Awarded Nov 6, 2020 at 9:18

Kshitiz Sharma

3,3179 gold badges33 silver badges35 bronze badges

Measure the size of a PostgreSQL table row

Awarded Aug 14, 2020 at 20:46

Joe

1,6552 gold badges11 silver badges13 bronze badges

How to easily convert utf8 tables to utf8mb4 in MySQL 5.5

Awarded Aug 13, 2020 at 3:36

geoaxis

1,7972 gold badges12 silver badges11 bronze badges

Is it a bad practice to always create a transaction?

Awarded Jul 21, 2020 at 3:03

elranu

1,3132 gold badges9 silver badges7 bronze badges

mysql: Show GRANTs for all users

Awarded Jun 12, 2020 at 13:48

Adam Matan

11.8k29 gold badges81 silver badges95 bronze badges

How do I get the current unix timestamp from PostgreSQL?

Awarded Apr 26, 2020 at 23:57

Jonas

33.5k27 gold badges61 silver badges64 bronze badges

Storing vs calculating aggregate values

Awarded Apr 12, 2020 at 1:10

BenV

4,9037 gold badges39 silver badges38 bronze badges

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

Awarded Mar 3, 2020 at 10:15

Amelio Vazquez-Reina

2,2052 gold badges14 silver badges8 bronze badges

PostgreSQL multi-column unique constraint and NULL values

Awarded Feb 27, 2020 at 15:45

Manuel Leduc

1,6912 gold badges11 silver badges5 bronze badges

Pattern matching with LIKE, SIMILAR TO or regular expressions

Awarded Feb 7, 2020 at 13:00

Lucas Kauffman

1,8154 gold badges17 silver badges18 bronze badges

Guid vs INT - Which is better as a primary key?

Awarded Dec 27, 2019 at 22:30

BrunoLM

3,5137 gold badges27 silver badges22 bronze badges

Optimizing queries on a range of timestamps (two columns)

Awarded Dec 21, 2019 at 0:40

Stephane Rolland

8,78111 gold badges33 silver badges40 bronze badges

Good explanation of cascade (ON DELETE/UPDATE) behavior

Awarded Nov 19, 2019 at 17:50

Johntron

1,9032 gold badges12 silver badges7 bronze badges

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

Awarded Nov 5, 2019 at 12:55

Curtis

1,2552 gold badges8 silver badges9 bronze badges

Why use both TRUNCATE and DROP?

Awarded Oct 11, 2019 at 16:35

user606723

1,5264 gold badges14 silver badges16 bronze badges

Force drop db while others may be connected

Awarded Jul 30, 2019 at 13:40

Alex

2,6952 gold badges17 silver badges7 bronze badges

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

Awarded Jul 26, 2019 at 8:50

Mitch

2,6482 gold badges18 silver badges24 bronze badges

ALTER TABLE - Rename a column

Awarded Jul 23, 2019 at 14:25

Bojan

1,1332 gold badges7 silver badges4 bronze badges

SQL: SELECT All columns except some

Awarded May 29, 2019 at 6:50

Adam Matan

11.8k29 gold badges81 silver badges95 bronze badges

Advantages and Disadvantages to using ENUM vs Integer types?

Awarded Feb 18, 2019 at 15:35

Jake Wilson

2,4478 gold badges22 silver badges23 bronze badges

Where are some useful SQL puzzles to teach SQL in a workplace?

Awarded Feb 8, 2019 at 5:20

testerab

4773 gold badges8 silver badges13 bronze badges

How to safely change MySQL innodb variable 'innodb_log_file_size'?

Awarded Jan 23, 2019 at 18:45

Derek Downey

23.5k11 gold badges78 silver badges104 bronze badges

Help installing SQL Server 2017 - VS Shell installation has failed with exit code 1638

Awarded Jan 1, 2019 at 4:00

Jonathan Allen

3,5927 gold badges24 silver badges25 bronze badges

List the database privileges using psql

Awarded Dec 18, 2018 at 8:20

pedrosanta

3,4233 gold badges17 silver badges7 bronze badges

How do I find PostgreSQL's data directory?

Awarded Dec 17, 2018 at 9:45

randomguy

2,1812 gold badges13 silver badges6 bronze badges

Create a MySQL database with charset UTF-8

Awarded Nov 23, 2018 at 11:25

user3397998

2,3212 gold badges13 silver badges4 bronze badges

How to determine if an Index is required or necessary

Awarded Jul 29, 2018 at 23:50

misterjaytee

1,4133 gold badges12 silver badges8 bronze badges

Granting a user account permission to create databases in PostgreSQL

Awarded Jul 3, 2018 at 5:09

GSto

2,4532 gold badges14 silver badges6 bronze badges

Why are numbers tables "invaluable"?

Awarded Jun 19, 2018 at 1:40

Jeff Atwood

2,3642 gold badges21 silver badges15 bronze badges

Possible to make MySQL use more than one core?

Awarded May 18, 2018 at 8:06

gbn

70k8 gold badges165 silver badges242 bronze badges

Should binary files be stored in the database?

Awarded Apr 29, 2018 at 1:15

Jack Douglas

40.1k15 gold badges103 silver badges177 bronze badges

Why shouldn't we allow NULLs?

Awarded Apr 17, 2018 at 6:40

Thomas Stringer

42.4k9 gold badges119 silver badges154 bronze badges

2 Next