Nice Question - Badge - Database Administrators Stack Exchange

Nice Question

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

Awarded 4586 times.

Appropriate use of mysql Optimize Table

Awarded yesterday

Daniel A.

1011 silver badge5 bronze badges

Postgres - window function rank and count

Awarded Nov 27 at 12:04

DaveB

2992 gold badges6 silver badges16 bronze badges

Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4

Awarded Nov 21 at 18:21

Stephen Ostermiller

3532 silver badges10 bronze badges

Query that displays backup information (successful and failed) SQL Server

Awarded Nov 21 at 6:03

iamZel

1031 gold badge1 silver badge7 bronze badges

Full Text Search only performs 'starts with' searches

Awarded Nov 17 at 13:05

Phil

2772 silver badges9 bronze badges

What does KEY SHARE OF in a PostgreSQL statement mean?

Awarded Nov 17 at 8:45

D-K

4934 silver badges16 bronze badges

How can I disable parallel queries in PostgreSQL?

Awarded Nov 16 at 17:20

Evan Carroll

62.1k46 gold badges233 silver badges470 bronze badges

"ERROR:malformed array literal" when using json_to_record with a JSON array element in Postgres 9.4

Awarded Nov 16 at 13:27

Taytay

3252 gold badges3 silver badges11 bronze badges

Convert MySQL database from latin1 to utf8mb4 - and take care of German umlauts

Awarded Nov 13 at 13:25

Alexander Farber

4052 gold badges7 silver badges19 bronze badges

Rule of thumb for tmp_table_size and max_heap_table_size MySQL properties

Awarded Nov 11 at 9:31

Niko

2211 gold badge3 silver badges7 bronze badges

How exactly does the one-byte "char" type work in PostgreSQL?

Awarded Nov 10 at 13:20

Evan Carroll

62.1k46 gold badges233 silver badges470 bronze badges

What reason could cause AWS RDS connections to spike

Awarded Nov 7 at 23:30

TrungDQ

1991 gold badge1 silver badge7 bronze badges

Zeroing WAL segments in Postgres

Awarded Nov 7 at 2:57

Dave Turner

2031 silver badge6 bronze badges

Does it make sense to create index with all columns included

Awarded Nov 3 at 10:27

LukLed

2031 gold badge2 silver badges8 bronze badges

Are enums still evil (in MySQL 8.0)?

Awarded Nov 1 at 13:11

Florent Poujol

2132 silver badges4 bronze badges

psql denies access to file when using COPY FROM

Awarded Oct 30 at 7:03

Pete

2031 gold badge2 silver badges7 bronze badges

How to identify the ranges over which a postgres table was partitioned?

Awarded Oct 26 at 0:16

ConanTheGerbil

1,1254 gold badges23 silver badges40 bronze badges

SQL Server Job History Disappears After 5 Days

Awarded Oct 25 at 20:20

PseudoToad

8282 gold badges11 silver badges23 bronze badges

When should we use table partitioning in Postgresql?

Awarded Oct 25 at 2:36

Graham Slick

2012 silver badges3 bronze badges

Efficiently store large list structure in RocksDB so that the data can be retrieved in pages

Awarded Oct 24 at 12:06

Pinank Lakhani

1036 bronze badges

node is not in primary or recovering state

Awarded Oct 23 at 13:52

invzbl3

2571 gold badge4 silver badges10 bronze badges

Single sql query to select a record from parent table only if all it's records in child table has values

Awarded Oct 17 at 20:40

Harun

3673 gold badges5 silver badges11 bronze badges

Combining array_agg and unnest

Awarded Oct 17 at 8:41

OrangeDog

2961 gold badge3 silver badges12 bronze badges

Collation version mismatch

Awarded Oct 14 at 22:15

Miqueias Kevison

4011 gold badge1 silver badge8 bronze badges

how to dump a case-sensitive table within a specific schema

Awarded Oct 13 at 20:18

Bertuz

2352 silver badges7 bronze badges

How to make mysqldump use /*!40101 SET character_set_client = utf8mb4 */;?

Awarded Oct 12 at 15:02

zhouji

2111 gold badge2 silver badges4 bronze badges

Should arrays of IDs stored in Postgres use varchar, int, or another type?

Awarded Oct 10 at 6:07

crockpotveggies

2451 gold badge2 silver badges10 bronze badges

Variable inside another variable in SQLCMD mode

Awarded Oct 4 at 10:41

user193130

2233 silver badges6 bronze badges

Accessing the OLD/NEW table value in a trigger function in plain SQL

Awarded Oct 2 at 12:18

eComEvo

3791 gold badge3 silver badges14 bronze badges

SSDT Drop and Recreate Tables when nothing has changed

Awarded Oct 2 at 9:58

OJay

3512 silver badges11 bronze badges

PL/pgSQL issues when function used twice (caching problem?)

Awarded Sep 30 at 18:26

Eric Ly

1,21212 silver badges20 bronze badges

Merge row size overflow in SQL Server - "Cannot create a row of size.."

Awarded Sep 27 at 12:09

Yosi Dahari

5175 silver badges15 bronze badges

Array integer[]: how to get all distinct values in a table and count them?

Awarded Sep 22 at 7:07

Sergey

2031 gold badge2 silver badges6 bronze badges

Is it a good or bad idea to use "ON UPDATE CASCADE ON DELETE CASCADE" for foreign keys? Why does this mechanism exist at all?

Awarded Sep 20 at 14:49

pgphant

1111 gold badge1 silver badge3 bronze badges

How can I set a column to NOT NULL without locking the table during a table scan?

Awarded Sep 20 at 10:11

John Bachir

7831 gold badge11 silver badges28 bronze badges

How to convert a bytea column to text?

Awarded Sep 19 at 10:51

ryanzidago

3751 gold badge3 silver badges10 bronze badges

SQL Server Error while creating User

Awarded Sep 18 at 9:12

Hiral

1091 gold badge1 silver badge3 bronze badges

Parent/Child Relationship Table Design - What's The Best Practice?

Awarded Sep 17 at 18:27

Kevin

5332 gold badges11 silver badges19 bronze badges

What is the optimal solution for storing real time time-series in MariaDB / MySQL?

Awarded Sep 13 at 13:57

dbdemon

6,2514 gold badges19 silver badges38 bronze badges

CONCAT used in INDEX causes ERROR: functions in index expression must be marked IMMUTABLE

Awarded Sep 12 at 18:49

andilabs

6052 gold badges6 silver badges11 bronze badges

How do I use the input from a \prompt in a conditional (\if)?

Awarded Sep 12 at 12:16

Evan Carroll

62.1k46 gold badges233 silver badges470 bronze badges

How do I connect to localDB from SQL Server 2014 Express

Awarded Sep 12 at 6:55

J.S.Orris

2031 gold badge2 silver badges7 bronze badges

How to use RETURNS TABLE with an existing table in PostgreSQL?

Awarded Sep 8 at 21:30

tinlyx

3,42511 gold badges42 silver badges67 bronze badges

Select pairs (a,b) excluding (b,a) with same value

Awarded Sep 7 at 12:47

McNets

23.6k9 gold badges48 silver badges88 bronze badges

How can I get individual rowcounts like SSMS?

Awarded Sep 6 at 5:17

RBarryYoung

3,0314 gold badges22 silver badges42 bronze badges

Using COLLATE with UNION

Awarded Sep 4 at 18:17

Anja

1512 gold badges2 silver badges4 bronze badges

Delete rows older than x days without locking table

Awarded Sep 4 at 8:41

user2992455

1011 gold badge1 silver badge4 bronze badges

Applying indexes on columns used in join condition

Awarded Aug 31 at 13:26

Madhusudan

2232 gold badges4 silver badges10 bronze badges

MySQL timestamp timezone handling

Awarded Aug 31 at 6:35

fejesjoco

4471 gold badge5 silver badges14 bronze badges

Converting rows to columns

Awarded Aug 28 at 21:16

user91740

1111 gold badge1 silver badge3 bronze badges

Show sql statements from mysql binlog (GTID)

Awarded Aug 28 at 14:57

Glasnhost

4681 gold badge6 silver badges17 bronze badges

Is there a query to check the current WAL size in PostgreSQL?

Awarded Aug 28 at 14:07

Antonius Bloch

2231 gold badge2 silver badges7 bronze badges

How to swap primary key between records in postgres

Awarded Aug 25 at 6:36

Pedro Borges

2132 silver badges7 bronze badges

Improve The Performance Of Multiple Date Range Predicates

Awarded Aug 24 at 11:04

Erik Darling

38.8k14 gold badges128 silver badges415 bronze badges

Won't start: InnoDB: Corrupted page ... Tablespace was not found

Awarded Aug 22 at 7:50

Felipe Alonso

2131 gold badge2 silver badges6 bronze badges

Why does Postgres ORDER BY seem to halfway ignore leading underscores?

Awarded Aug 18 at 19:51

orokusaki

1,1692 gold badges11 silver badges20 bronze badges

cannot execute as the database principal because the principal does not exist - DB Restoration

Awarded Aug 16 at 9:34

KishanRSojitra

2321 gold badge2 silver badges5 bronze badges

Example where schema are better than multiple databases

Awarded Aug 9 at 21:09

rlandster

3653 silver badges11 bronze badges

Azure Data Studio - Intellisense does not detect tables, yet queries work. How do I fix this?

Awarded Aug 9 at 20:40

Krausladen

1491 silver badge6 bronze badges

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

Awarded Aug 9 at 12:45

John K. N.

17.3k11 gold badges51 silver badges110 bronze badges

2 3 4 5

…

77 Next