Nice Answer

Nice Answer

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

Awarded 6411 times.

Update request using table alias

Awarded 11 hours ago

ypercubeᵀᴹ

88.6k12 gold badges170 silver badges261 bronze badges

Databases: are there universal datatypes?

Awarded 20 hours ago

a_horse_with_no_name

61.6k12 gold badges116 silver badges154 bronze badges

What are the sp_send_dbmail return values?

Awarded yesterday

Josh Darnell

24k5 gold badges49 silver badges93 bronze badges

PostgreSQL alternative to SQL Server’s `try_cast` function

Awarded 2 days ago

a_horse_with_no_name

61.6k12 gold badges116 silver badges154 bronze badges

How are indexes represented in an ERD?

Awarded 2 days ago

Rob Farley

15.4k2 gold badges34 silver badges60 bronze badges

Postgresql: How to add a role that inherits from another?

Awarded Feb 26 at 18:36

Up_One

1,43610 silver badges15 bronze badges

Postgresql: How to index jsonb array of objects column

Awarded Feb 26 at 16:48

Mad Scientist

8808 silver badges16 bronze badges

SELECT FOR UPDATE locking other tables in PostgreSQL

Awarded Feb 26 at 10:03

ypercubeᵀᴹ

88.6k12 gold badges170 silver badges261 bronze badges

How to unnest and GROUP BY elements of a JSON array?

Awarded Feb 26 at 8:57

Erwin Brandstetter

128k16 gold badges297 silver badges442 bronze badges

What is the difference between a “record” and a “row” in SQL Server?

Awarded Feb 25 at 22:46

Grijesh Chauhan

5412 gold badges5 silver badges18 bronze badges

Size Requirement of SQL Database

Awarded Feb 25 at 14:07

J.D.

12.4k3 gold badges23 silver badges55 bronze badges

Size Requirement of SQL Database

Awarded Feb 25 at 14:07

Dan Guzman

20.5k2 gold badges30 silver badges58 bronze badges

How to disable annoying MySql update console

Awarded Feb 25 at 0:05

Jon Onstott

2012 silver badges4 bronze badges

Select multiple values in LIKE Operator

Awarded Feb 24 at 16:40

McNets

21.3k8 gold badges39 silver badges75 bronze badges

Why aren't primary key / foreign key matches used for joins?

Awarded Feb 24 at 15:34

James Anderson

2721 silver badge5 bronze badges

How to have a one-to-many relationship with a privileged child?

Awarded Feb 24 at 6:20

Aaron Bertrand

170k24 gold badges358 silver badges566 bronze badges

Error 1236 - “Could not find first log file name in binary log index file”

Awarded Feb 23 at 15:34

Andy Beverley

2012 silver badges4 bronze badges

Difference between row-based and statement-based replication in MySQL?

Awarded Feb 23 at 6:57

shantanuo

5592 gold badges6 silver badges16 bronze badges

Postgres - Encoding, Collation and CType

Awarded Feb 22 at 8:21

Daniel Vérité

23.7k3 gold badges51 silver badges65 bronze badges

Get a truly RANDOM row from a PostgreSQL table quickly

Awarded Feb 20 at 22:40

Vérace

22.4k5 gold badges49 silver badges67 bronze badges

How do I include nulls during comparisons in SQL Server?

Awarded Feb 20 at 15:48

Sean Gallardy - Retired User

20.7k2 gold badges33 silver badges64 bronze badges

How do I include nulls during comparisons in SQL Server?

Awarded Feb 20 at 15:48

usr

7,0004 gold badges26 silver badges57 bronze badges

Are auto incrementing identities always given in the order of inserts in SQL Server?

Awarded Feb 20 at 11:33

Chad Mattox

2,1216 silver badges13 bronze badges

How to specify trigger execution order under PostgreSQL?

Awarded Feb 19 at 18:47

Eelke

8486 silver badges12 bronze badges

What is the difference between an after update and a before update in PostgreSQL

Awarded Feb 19 at 18:36

Joishi Bodio

2,7182 gold badges11 silver badges16 bronze badges

Make Postgres database temporarily read-only (for performing volume snapshots)

Awarded Feb 18 at 21:21

Otheus

3841 gold badge2 silver badges13 bronze badges

How can I enter Mongo as a superuser or reset users?

Awarded Feb 18 at 19:50

Ivanov

1,9282 gold badges24 silver badges44 bronze badges

Is there a way to back up agent jobs?

Awarded Feb 18 at 14:45

BradC

9,1417 gold badges42 silver badges75 bronze badges

Is it okay to have a fill factor of 100 on the clustered index that is on an ID column?

Awarded Feb 18 at 12:20

Solomon Rutzky

61.7k6 gold badges126 silver badges253 bronze badges

Insert values from a record variable into a table

Awarded Feb 18 at 10:32

Erwin Brandstetter

128k16 gold badges297 silver badges442 bronze badges

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

Awarded Feb 17 at 20:27

Jasen

1,9807 silver badges13 bronze badges

Missing rows under read committed isolation

Awarded Feb 17 at 16:41

Dan Guzman

20.5k2 gold badges30 silver badges58 bronze badges

How to relate two rows in the same table

Awarded Feb 16 at 21:32

ypercubeᵀᴹ

88.6k12 gold badges170 silver badges261 bronze badges

Need separate columns that calculate percentage

Awarded Feb 16 at 12:25

Erwin Brandstetter

128k16 gold badges297 silver badges442 bronze badges

Why mongo is choosing the wrong index / execution plan?

Awarded Feb 15 at 6:04

Stennie

8,9402 gold badges23 silver badges39 bronze badges

How do I cleanup Postgres WAL?

Awarded Feb 13 at 19:06

jjanes

25.2k3 gold badges21 silver badges33 bronze badges

How to treat numbers within strings as numbers when sorting (“A3” sorts before “A10”, not after)

Awarded Feb 12 at 16:42

Solomon Rutzky

61.7k6 gold badges126 silver badges253 bronze badges

Local Backup from Amazon RDS PostgreSQL database

Awarded Feb 12 at 15:55

Eric Ly

1,10211 silver badges19 bronze badges

Can I use hypertables in timescaledb merely to get better insert rates?

Awarded Feb 12 at 10:02

Mike Freedman

3262 silver badges4 bronze badges

Is it possible to store and query JSON in SQLite?

Awarded Feb 11 at 19:56

redneckProgrammer

1011 silver badge3 bronze badges

Postgres Upsert Performance Considerations (millions of rows/hour)

Awarded Feb 11 at 18:45

Laurenz Albe

20k3 gold badges17 silver badges33 bronze badges

Carry over long sequence of missing values with Postgres

Awarded Feb 10 at 14:47

Erwin Brandstetter

128k16 gold badges297 silver badges442 bronze badges

PostgreSQL doesn't use all the RAM it could

Awarded Feb 10 at 3:21

Craig Ringer

47.9k3 gold badges123 silver badges160 bronze badges

How to set MySQL binlog retention in hours?

Awarded Feb 9 at 5:35

jynus

13.4k1 gold badge25 silver badges37 bronze badges

Trace flag and which need to be turned off and Why

Awarded Feb 8 at 21:42

Raadee

3612 silver badges6 bronze badges

how to use index to speed up sorting in postgres

Awarded Feb 8 at 18:19

Erwin Brandstetter

128k16 gold badges297 silver badges442 bronze badges

Is it okay to put dots in SQL Server database names?

Awarded Feb 8 at 18:03

Daniel

1711 silver badge8 bronze badges

Efficient merging (removing duplicates) of arrays

Awarded Feb 7 at 0:42

Erwin Brandstetter

128k16 gold badges297 silver badges442 bronze badges

Can I generate a list of all combinations between two columns

Awarded Feb 5 at 15:36

ypercubeᵀᴹ

88.6k12 gold badges170 silver badges261 bronze badges

How can I get the page size of a Postgres database?

Awarded Feb 5 at 13:03

Erwin Brandstetter

128k16 gold badges297 silver badges442 bronze badges

In PostgreSQL, how do I make it so that either column A or column B must be non-null?

Awarded Feb 4 at 23:26

a_horse_with_no_name

61.6k12 gold badges116 silver badges154 bronze badges

UPSERT with ON CONFLICT using values from source table in the UPDATE part

Awarded Feb 4 at 21:27

Ezequiel Tolnay

4,6331 gold badge11 silver badges21 bronze badges

Backup SQL Server 2016 Instance Logins

Awarded Feb 4 at 16:25

John K. N.

12.9k8 gold badges35 silver badges81 bronze badges

In PostgreSQL, how do I make it so that either column A or column B must be non-null?

Awarded Feb 4 at 0:49

Colin 't Hart

8,21714 gold badges32 silver badges38 bronze badges

Using a CREATE TABLE AS SELECT how do I specify a WITH condition (CTE)?

Awarded Feb 3 at 20:50

Evan Carroll

48.6k27 gold badges165 silver badges353 bronze badges

Deadlock with multi-row INSERTs despite ON CONFLICT DO NOTHING

Awarded Feb 3 at 14:02

Erwin Brandstetter

128k16 gold badges297 silver badges442 bronze badges

Why choose a top query and temporary table instead of a cursor for a loop?

Awarded Feb 3 at 9:08

RLF

13.5k2 gold badges28 silver badges42 bronze badges

How do others know what is delivery address and invoice address if they are in the same table?

Awarded Feb 2 at 19:49

Ivan Kahl

2211 silver badge5 bronze badges

MySQL Editor Hangs on attempt to Launch

Awarded Feb 2 at 9:56

macio.Jun

2112 silver badges5 bronze badges

SQL Server cardinality hint

Awarded Feb 2 at 1:18

Tom V

15.3k7 gold badges54 silver badges85 bronze badges

2 3 4 5

…

107 Next

Stack Exchange Network

current community

your communities

more stack exchange communities