Good Answer - Badge - Database Administrators Stack Exchange

Good Answer

Answer score of 25 or more. This badge can be awarded multiple times.

Awarded 1438 times.

Getting SELECT to return a constant value even if zero rows match

Awarded Mar 17 at 7:06

a_horse_with_no_name

77.2k14 gold badges154 silver badges192 bronze badges

Postgres JOIN conditions vs WHERE conditions

Awarded Mar 15 at 15:43

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

Blue icon with question mark - what does it mean?

Awarded Mar 14 at 20:17

John Eisbrener

9,2025 gold badges25 silver badges57 bronze badges

Get all partition names for a table

Awarded Mar 14 at 14:56

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

How to insert 10000 new rows?

Awarded Mar 13 at 6:31

ypercubeᵀᴹ

95.7k13 gold badges208 silver badges301 bronze badges

How can I change the default storage engine in phpmyadmin?

Awarded Mar 7 at 12:45

BenV

4,8437 gold badges38 silver badges38 bronze badges

List the database privileges using psql

Awarded Mar 6 at 10:31

Markofo

3513 silver badges2 bronze badges

Running total to the previous row

Awarded Feb 24 at 12:58

ypercubeᵀᴹ

95.7k13 gold badges208 silver badges301 bronze badges

Store output of sp_who2 in a table

Awarded Feb 23 at 7:19

Mihai

1,5351 gold badge13 silver badges16 bronze badges

MySQL: Which join is better between left outer join and inner join

Awarded Feb 22 at 15:22

jynus

14.4k1 gold badge32 silver badges42 bronze badges

PostgreSQL - insert/update violates foreign key constraints

Awarded Feb 20 at 4:51

dezso

30.1k13 gold badges97 silver badges142 bronze badges

Undesirable Nest Loop vs. Hash Join in PostgreSQL 9.6

Awarded Feb 19 at 20:31

Evan Carroll

59.6k43 gold badges219 silver badges450 bronze badges

Disable all constraints and table checks while restoring a dump

Awarded Feb 16 at 22:55

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

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

Awarded Feb 13 at 19:57

Erik Darling

36.9k14 gold badges127 silver badges367 bronze badges

Backup/Restore Users/Passwords/Privileges

Awarded Feb 9 at 15:00

mysqlrockstar

7596 silver badges18 bronze badges

Why would I NOT use the SQL Server option "optimize for ad hoc workloads"?

Awarded Feb 6 at 8:27

Kin Shah

61.6k5 gold badges116 silver badges235 bronze badges

DEFAULT CONSTRAINT, worth it?

Awarded Jan 30 at 18:16

Solomon Rutzky

67.4k7 gold badges145 silver badges280 bronze badges

Default value for UUID column in Postgres

Awarded Jan 29 at 17:41

bpieck

3613 silver badges3 bronze badges

Using PostgreSQL what is the difference between a smallint and a bool for storing boolean?

Awarded Jan 22 at 11:12

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

Constraint - one boolean row is true, all other rows false

Awarded Jan 20 at 0:26

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

UPDATE table based on the same table

Awarded Jan 13 at 11:27

RolandoMySQLDBA

178k32 gold badges309 silver badges509 bronze badges

Postgres query to return JSON object keys as array

Awarded Jan 13 at 1:27

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

Does running pg_dump on live db produce consistent backups?

Awarded Jan 11 at 10:41

Dennis Nolte

4255 silver badges14 bronze badges

Giving file system access to the SQLSERVERAGENT virtual account

Awarded Jan 9 at 3:20

Sting

2,73810 silver badges19 bronze badges

SQL not engaging parallelism for extremely large query

Awarded Jan 5 at 20:18

Paul White♦

78.8k28 gold badges394 silver badges617 bronze badges

Check if postgresql database exists (case insensitive way)

Awarded Jan 5 at 12:21

Craig Ringer

54.1k3 gold badges150 silver badges185 bronze badges

Display user-defined types and their details

Awarded Jan 3 at 21:33

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

Naming conflict between function parameter and result of JOIN with USING clause

Awarded Dec 31, 2022 at 17:56

ypercubeᵀᴹ

95.7k13 gold badges208 silver badges301 bronze badges

Get equivalent SQL query for any Postgres meta-command

Awarded Dec 30, 2022 at 16:17

KookieMonster

1,94718 silver badges18 bronze badges

PostgreSQL two different ways to generate a UUID: gen_random_uuid vs uuid_generate_v4?

Awarded Dec 23, 2022 at 18:06

Jasen

3,1281 gold badge12 silver badges15 bronze badges

PostgreSQL "size of temporary files"

Awarded Dec 22, 2022 at 14:45

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

Change existing column in PG to auto-incremental primary key

Awarded Dec 18, 2022 at 9:03

a_horse_with_no_name

77.2k14 gold badges154 silver badges192 bronze badges

"ORA-01950: no privileges on tablespace 'SYSTEM' " : What error is it?

Awarded Dec 13, 2022 at 12:57

YasirA

3,0853 gold badges20 silver badges29 bronze badges

PostgreSQL alternative to SQL Server’s `try_cast` function

Awarded Dec 12, 2022 at 16:02

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

Are junction tables a good practice?

Awarded Dec 8, 2022 at 19:33

Federico Razzoli

6785 silver badges15 bronze badges

Why does PostgreSQL allow querying for array[0] even though it uses 1-based arrays?

Awarded Dec 8, 2022 at 15:33

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

PostgreSQL crash recovery

Awarded Nov 28, 2022 at 17:18

Craig Ringer

54.1k3 gold badges150 silver badges185 bronze badges

SQL: SELECT All columns except some

Awarded Nov 18, 2022 at 7:28

mlt

3913 silver badges7 bronze badges

Granting Select access to all tables within a specific Database in MS SQL

Awarded Nov 16, 2022 at 11:11

ndonohoe

3663 silver badges3 bronze badges

Join tables in two databases make query slow? is better to partition db?

Awarded Nov 15, 2022 at 14:17

Brent Ozar

42.4k46 gold badges206 silver badges363 bronze badges

Can I retrieve all database objects owned by a particular user?

Awarded Nov 14, 2022 at 17:58

Thomas Stringer

41.7k9 gold badges115 silver badges154 bronze badges

How to do a case sensitive search in WHERE clause?

Awarded Nov 4, 2022 at 14:31

Matt Fenwick

1,2783 gold badges12 silver badges28 bronze badges

Why can't rows inserted in a CTE be updated in the same statement?

Awarded Nov 4, 2022 at 8:50

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

How to set a search_path default on a psql cmd execution?

Awarded Nov 3, 2022 at 12:22

Whimusical

5131 gold badge6 silver badges13 bronze badges

Why do wildcards in GROUP BY statements not work?

Awarded Nov 1, 2022 at 1:03

Aaron Bertrand

178k27 gold badges388 silver badges599 bronze badges

SQL Server Cannot drop database <dbname> because it is currently in use... but no sessions displayed

Awarded Oct 28, 2022 at 17:42

yrushka

1,9341 gold badge16 silver badges21 bronze badges

Using PostgreSQL 8.4, how to convert bytea to text value in postgres?

Awarded Oct 23, 2022 at 23:03

rogerdpack

1,0541 gold badge14 silver badges16 bronze badges

Try catch equivalent in Postgres

Awarded Oct 23, 2022 at 16:27

McNets

23.2k9 gold badges46 silver badges84 bronze badges

Transaction in a stored procedure

Awarded Oct 23, 2022 at 12:47

Hannah Vernon♦

68.5k22 gold badges166 silver badges303 bronze badges

CREATE DATABASE vs. CREATE ANY DATABASE permissions

Awarded Oct 21, 2022 at 10:42

Tohuw

6011 gold badge5 silver badges9 bronze badges

What are the valid formats of a PostgreSQL schema name?

Awarded Oct 20, 2022 at 20:32

gsiems

3,0352 gold badges19 silver badges26 bronze badges

DDL_admin vs db_owner permissions

Awarded Oct 20, 2022 at 12:25

IT Thug Ninja

2,22814 silver badges18 bronze badges

Queries without Good Enough Plan Found

Awarded Oct 16, 2022 at 19:41

Paul White♦

78.8k28 gold badges394 silver badges617 bronze badges

what is "planSummary: IDHACK"?

Awarded Oct 14, 2022 at 20:45

JJussi

5,5781 gold badge14 silver badges19 bronze badges

Is it possible to use SQLite as a client-server database?

Awarded Oct 12, 2022 at 10:56

ddeimeke

4323 silver badges7 bronze badges

Querying JSONB in PostgreSQL

Awarded Oct 7, 2022 at 2:41

Erwin Brandstetter

164k22 gold badges406 silver badges551 bronze badges

How do I list all tables in all schemas owned by the current user in Postgresql?

Awarded Oct 6, 2022 at 3:21

Sahap Asci

2,66112 silver badges25 bronze badges

What does the GO statement do in SQL Server?

Awarded Sep 30, 2022 at 18:58

Vladislav Zalesak

1,5231 gold badge9 silver badges15 bronze badges

How to get all roles that a user is a member of (including inherited roles)?

Awarded Sep 28, 2022 at 18:50

Daniel Vérité

29.3k3 gold badges66 silver badges75 bronze badges

Alter table on live production databases

Awarded Sep 27, 2022 at 20:06

Craig Ringer

54.1k3 gold badges150 silver badges185 bronze badges

2 3 4 5

…

24 Next