Nice Answer - Badge - Database Administrators Stack Exchange

Nice Answer

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

Awarded 7761 times.

Multiple Transaction Log files and performance impact

Awarded yesterday

Aaron Bertrand

181k28 gold badges401 silver badges617 bronze badges

When (or why even) use PLPython(3)u

Awarded 2 days ago

jjanes

40.4k3 gold badges37 silver badges50 bronze badges

Is the MySQL JSON data type bad for performance for data retrieval?

Awarded Jul 17 at 20:11

shamaseen

2012 silver badges4 bronze badges

How to copy & paste "Missing Index" in "Execution plan" tab of SSMS?

Awarded Jul 17 at 15:06

Henrico Bekker

8504 silver badges11 bronze badges

Storing personal data on an invoice to preserve data integrity

Awarded Jul 17 at 14:22

Walter Mitty

4,35620 silver badges22 bronze badges

SQL Server alerts not sending notification emails to the operator

Awarded Jul 17 at 0:21

AnswersInAnswers

11 silver badge3 bronze badges

Are unique filtered indexes considered an antipattern for enforcing constraints?

Awarded Jul 15 at 18:13

Charlieface

13.7k14 silver badges39 bronze badges

Change Data Capture vs trigger for logging changes

Awarded Jul 15 at 13:35

jyao

3,0731 gold badge13 silver badges27 bronze badges

Performance differences between RID Lookup vs Key Lookup?

Awarded Jul 15 at 9:41

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

How to check when statistics was last executed?

Awarded Jul 11 at 11:51

Grant Fritchey

4,40919 silver badges19 bronze badges

PgBouncer logging details for `query_wait_timeout` error

Awarded Jul 11 at 10:52

richyen

8005 silver badges10 bronze badges

OPTIMIZE FOR UNKNOWN in a Stored Procedure

Awarded Jul 11 at 7:58

Avarkx

2,37312 silver badges23 bronze badges

Why is this MySQL proc using cursors failing to retrieve results?

Awarded Jul 8 at 18:35

RolandoMySQLDBA

183k33 gold badges320 silver badges525 bronze badges

Cursoring over sys.databases skips databases

Awarded Jul 6 at 12:55

Paul White♦

87k30 gold badges414 silver badges647 bronze badges

Most efficient way to determine if a SQL Server database is using Read Committed Snapshot?

Awarded Jul 5 at 21:56

Martin Smith

85.4k15 gold badges248 silver badges340 bronze badges

Use array of composite type as function parameter and access it

Awarded Jul 4 at 9:15

Erwin Brandstetter

179k27 gold badges446 silver badges610 bronze badges

How to select functions that belong in a given extension in PostgreSQL?

Awarded Jul 4 at 8:25

oᴉɹǝɥɔ

5115 silver badges10 bronze badges

Multiple primary keys in PostgreSQL

Awarded Jul 3 at 12:20

Demitri

2212 silver badges4 bronze badges

In-memory OLTP databases take very long to recover during startup

Awarded Jul 2 at 21:33

Sean Gallardy

34k3 gold badges41 silver badges80 bronze badges

Is "ROW_NUMBER() OVER(ORDER BY xml.node)" well defined?

Awarded Jun 27 at 8:33

Paul White♦

87k30 gold badges414 silver badges647 bronze badges

View doesn't recognise a change to an underlying table when an existing column is dropped and replaced with one with the same name but as computed

Awarded Jun 25 at 17:18

Martin Smith

85.4k15 gold badges248 silver badges340 bronze badges

How to update complex jsonb column?

Awarded Jun 25 at 15:34

Erwin Brandstetter

179k27 gold badges446 silver badges610 bronze badges

Why am I getting permission denied on an ownership change?

Awarded Jun 24 at 13:45

Oto Shavadze

5351 gold badge7 silver badges15 bronze badges

View doesn't recognise a change to an underlying table when an existing column is dropped and replaced with one with the same name but as computed

Awarded Jun 24 at 13:28

Peter Vandivier

4,8261 gold badge24 silver badges46 bronze badges

Homebrew MariaDB Server Start Error with 'mysql.server start'

Awarded Jun 24 at 9:25

Sybil

2,5486 gold badges33 silver badges61 bronze badges

How to reset MariaDB into a "fresh install" state?

Awarded Jun 24 at 3:31

Kondybas

4,55617 silver badges14 bronze badges

How can I synchronize data between two RDS MySQL databases

Awarded Jun 21 at 14:06

Michael - sqlbot

22.6k2 gold badges48 silver badges76 bronze badges

Does Ordering of Columns in INCLUDE Statement of Index Matter?

Awarded Jun 21 at 11:48

Martin Smith

85.4k15 gold badges248 silver badges340 bronze badges

Mysql enable remote connection in centos,my.cnf does not have bind-address to comment out

Awarded Jun 21 at 8:34

jynus

14.9k1 gold badge36 silver badges46 bronze badges

Avoid output disappearing in psql

Awarded Jun 19 at 12:48

Evan Carroll

63.9k48 gold badges246 silver badges486 bronze badges

What SQL Server edition supports CDC?

Awarded Jun 18 at 15:32

Randolph West

3,71312 silver badges27 bronze badges

How should MAXDOP be configured on stacked instances?

Awarded Jun 17 at 6:17

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Postgres cost of large volume of inserts in many tables in a single transaction

Awarded Jun 15 at 1:41

Evan Carroll

63.9k48 gold badges246 silver badges486 bronze badges

EXISTS() vs EXISTS() = TRUE in Postgres

Awarded Jun 14 at 16:48

Laurenz Albe

54k4 gold badges45 silver badges78 bronze badges

Debug query on big table that is sometimes slow

Awarded Jun 14 at 2:36

Erwin Brandstetter

179k27 gold badges446 silver badges610 bronze badges

Why does SQL-Server Management Studio change "Execute Query" into "Save Results"?

Awarded Jun 7 at 19:32

Paul White♦

87k30 gold badges414 silver badges647 bronze badges

XML Query keeps converting < to < and > to >

Awarded Jun 6 at 13:51

Mikael Eriksson

22.2k5 gold badges61 silver badges104 bronze badges

Improve The Performance Of Multiple Date Range Predicates

Awarded Jun 6 at 13:40

Paul White♦

87k30 gold badges414 silver badges647 bronze badges

Multiple concurrent connections to same large SQLite file on a network share

Awarded Jun 5 at 7:56

jynus

14.9k1 gold badge36 silver badges46 bronze badges

Double entry accounting schema design

Awarded Jun 5 at 7:06

Philᵀᴹ

31.8k10 gold badges84 silver badges108 bronze badges

issues with encoding and pg_dump/restore between windows and linux

Awarded Jun 4 at 23:42

Fr Jeremy Krieg

2012 silver badges4 bronze badges

%%LOCKRES%% - SQL Server - Row identifier causing Deadlocks - possible bug

Awarded Jun 4 at 7:11

Martin Smith

85.4k15 gold badges248 silver badges340 bronze badges

Error while restoring a Database from an SQL dump

Awarded Jun 3 at 2:27

Timothy L.J. Stewart

2012 silver badges2 bronze badges

Is the size limit of a json field before or after compression in Postgres?

Awarded Jun 2 at 16:06

Laurenz Albe

54k4 gold badges45 silver badges78 bronze badges

Best practices for updating data on a "live" table

Awarded May 31 at 12:41

Joe Obbish

32.5k4 gold badges72 silver badges152 bronze badges

Execution slow in stored procedure; fast when run ad hoc

Awarded May 29 at 16:19

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Avoid output disappearing in psql

Awarded May 29 at 14:15

Daniel Vérité

31.8k3 gold badges76 silver badges84 bronze badges

Giving server-role to login breaks stored procedures

Awarded May 28 at 5:49

Paul White♦

87k30 gold badges414 silver badges647 bronze badges

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

Awarded May 23 at 22:46

Simon Perepelitsa

2662 silver badges5 bronze badges

Syncing two databases in SQL Server

Awarded May 23 at 17:20

Vojtěch Dohnal

6291 gold badge11 silver badges24 bronze badges

Index seek to specific multi-column key, then get some rows in lexicographical order

Awarded May 21 at 2:47

Charlieface

13.7k14 silver badges39 bronze badges

What does SQL Server's Error Log actually log?

Awarded May 20 at 15:28

David Browne - Microsoft

47.2k3 gold badges49 silver badges98 bronze badges

MySQL settings useful to speed up a mysqldump import

Awarded May 19 at 11:22

RolandoMySQLDBA

183k33 gold badges320 silver badges525 bronze badges

VACUUM FREEZE vs. VACUUM FULL

Awarded May 18 at 9:05

Jimmy Stenke

9235 silver badges8 bronze badges

How to handle versions of an Entity in Database Design

Awarded May 17 at 12:00

FrustratedWithFormsDesigner

3,34520 silver badges21 bronze badges

Postgres choosing a filter instead of index cond when OR is involved

Awarded May 17 at 1:20

Laurenz Albe

54k4 gold badges45 silver badges78 bronze badges

MySQL - How to check for a value in all columns

Awarded May 17 at 0:49

donutguy640

4791 gold badge5 silver badges12 bronze badges

Determine consecutive occurrences of values

Awarded May 16 at 15:25

Błażej Ciesielski

3162 silver badges6 bronze badges

BLOBs or references in PostgreSQL

Awarded May 15 at 15:18

Peter Eisentraut

10.5k1 gold badge34 silver badges35 bronze badges

List all columns for a specified table

Awarded May 15 at 9:33

oᴉɹǝɥɔ

5115 silver badges10 bronze badges

2 3 4 5

…

130 Next