Enlightened - Badge - Database Administrators Stack Exchange

Enlightened

First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.

Awarded 3211 times.

Unable to drop non-PK index because it is referenced in a foreign key constraint

Awarded yesterday

Aaron Bertrand

178k27 gold badges391 silver badges602 bronze badges

How to get exception context for a manually raised exception in PL/pgSQL?

Awarded May 24 at 14:46

Craig Ringer

54.5k4 gold badges153 silver badges187 bronze badges

How do you drop a temporal table in SQL Server?

Awarded May 24 at 6:50

Bob Klimes

3,1441 gold badge16 silver badges29 bronze badges

Sort table rows and save the row numbers using UPDATE

Awarded May 24 at 6:02

Erwin Brandstetter

167k23 gold badges413 silver badges561 bronze badges

Benefit of having time dimension in a star schema?

Awarded May 21 at 12:25

Scott Hodgin - Retired

23.6k2 gold badges24 silver badges47 bronze badges

Why have both a postmaster and postgres executable?

Awarded May 19 at 17:57

Craig Ringer

54.5k4 gold badges153 silver badges187 bronze badges

pg_restore ERROR: "Relation does not exist" and creating new database

Awarded May 16 at 3:06

Daniel Vérité

29.8k3 gold badges68 silver badges78 bronze badges

AWS DMS creates tables with no auto_increment

Awarded May 15 at 18:07

Elliot Chance

3083 silver badges8 bronze badges

Rows with a variable number of columns?

Awarded May 12 at 1:50

Simon Righarts

4,72326 silver badges31 bronze badges

how to update a property value of a jsonb field?

Awarded May 11 at 20:12

a_horse_with_no_name

78.3k14 gold badges158 silver badges194 bronze badges

Return ResultSet with column names from functions

Awarded May 10 at 20:50

dezso

30.4k13 gold badges98 silver badges143 bronze badges

MySQL Replication Duplicate Entry for Primary Key

Awarded May 10 at 11:10

Rathish Kumar B

2,1945 gold badges22 silver badges35 bronze badges

Query performance on static, large PostgreSQL table

Awarded May 10 at 9:18

Erwin Brandstetter

167k23 gold badges413 silver badges561 bronze badges

SQL Server Error 8632 due to over 100,000 entries in WHERE clause

Awarded May 10 at 8:43

Brent Ozar

42.5k46 gold badges208 silver badges363 bronze badges

How does unnest() treat NULL values and empty arrays?

Awarded May 10 at 6:47

Erwin Brandstetter

167k23 gold badges413 silver badges561 bronze badges

Unable to execute query and not even able to generate Estimated execution plan

Awarded May 9 at 20:52

Martin Smith

81.2k15 gold badges232 silver badges327 bronze badges

What is the performance impact of pg_stat_statements?

Awarded May 8 at 16:33

Vérace

28.9k8 gold badges67 silver badges82 bronze badges

How to set 'timing on' permanently in PostgreSQL?

Awarded May 7 at 1:41

a_horse_with_no_name

78.3k14 gold badges158 silver badges194 bronze badges

How to backup/restore SQL Server database from command line similar to mysql

Awarded Apr 30 at 17:41

squillman

1,18712 silver badges23 bronze badges

Is this a bug or I did something wrong when I created the table?

Awarded Apr 27 at 10:31

Paul White♦

80.3k28 gold badges396 silver badges618 bronze badges

Alias using "AS" and without using "AS"

Awarded Apr 25 at 16:20

jynus

14.5k1 gold badge33 silver badges43 bronze badges

In SQL server is a check constraint applied before or after a default constraint on insert?

Awarded Apr 24 at 15:27

Martin Smith

81.2k15 gold badges232 silver badges327 bronze badges

T-SQL query for date of last full backup, size and location

Awarded Apr 24 at 15:27

spaghettidba

11.2k29 silver badges42 bronze badges

Join with comma separated values in SQL Server

Awarded Apr 18 at 10:05

Aaron Bertrand

178k27 gold badges391 silver badges602 bronze badges

MySQL event scheduler waiting on empty queue since server restarted 12 days ago

Awarded Apr 17 at 16:26

IGGt

2,0464 gold badges24 silver badges44 bronze badges

SQL Server: Grant access to all views in schema, but not tables

Awarded Apr 12 at 11:34

John Eisbrener

9,2426 gold badges27 silver badges60 bronze badges

MySQL Workbench, how to refresh EER diagram?

Awarded Apr 10 at 13:33

Stephen Senkomago Musoke

1,91714 silver badges12 bronze badges

BIGINT UNSIGNED value is out of range

Awarded Apr 7 at 1:41

Rick James

74.8k4 gold badges44 silver badges104 bronze badges

How to undo DROP TABLE statement?

Awarded Apr 6 at 17:52

John Moore

2662 silver badges3 bronze badges

How to get all distinct words in a column

Awarded Apr 5 at 23:26

Satyajit

2162 silver badges3 bronze badges

How long will an index take to create?

Awarded Apr 5 at 13:25

Oleg Dok

3,35724 silver badges29 bronze badges

ERROR: could not find array type for datatype information_schema.sql_identifier

Awarded Apr 4 at 18:31

Daniel Vérité

29.8k3 gold badges68 silver badges78 bronze badges

I can't access any database diagram

Awarded Apr 1 at 14:42

Racer SQL

7,27410 gold badges58 silver badges116 bronze badges

Enabling trace flag 8048

Awarded Mar 28 at 19:10

Brent Ozar

42.5k46 gold badges208 silver badges363 bronze badges

MySQL binary logs - skip a table

Awarded Mar 27 at 13:56

redguy

9867 silver badges14 bronze badges

How does PostgreSQL physically order new records on disk (after a cluster on primary key)?

Awarded Mar 25 at 13:46

Eelke

9387 silver badges14 bronze badges

Storing more than 8000 bytes in a column

Awarded Mar 23 at 12:26

Paul White♦

80.3k28 gold badges396 silver badges618 bronze badges

SSIS export to CSV Flat File Destination task, error The code page on input column is ... and is required to be

Awarded Mar 21 at 17:20

Mark Sinkinson

10.4k3 gold badges44 silver badges54 bronze badges

How can you output UPDATE / INSERT query results when using MySQL -e,--execute?

Awarded Mar 15 at 12:50

atxdba

5,2035 gold badges39 silver badges57 bronze badges

how do I execute a void-returning procedure in pgsql 9.1?

Awarded Mar 9 at 4:35

dezso

30.4k13 gold badges98 silver badges143 bronze badges

Automatic conversion of anonymous records returned from an UDF to well known table-type

Awarded Mar 7 at 16:55

Erwin Brandstetter

167k23 gold badges413 silver badges561 bronze badges

Are there side effects to Postgres 12's NOT MATERIALIZED directive?

Awarded Mar 6 at 8:49

Vérace

28.9k8 gold badges67 silver badges82 bronze badges

Is "deadlock detected" really an error? Should I be suppressing them after handling them?

Awarded Mar 2 at 7:47

Laurenz Albe

42.6k4 gold badges36 silver badges60 bronze badges

Does With(NoLock) help with query performance?

Awarded Mar 1 at 22:41

Erik Darling

37.5k14 gold badges128 silver badges398 bronze badges

Why does TRY_CAST throw an error when attempting to convert VARCHAR to UNIQUEIDENTIFIER?

Awarded Mar 1 at 18:02

Paul White♦

80.3k28 gold badges396 silver badges618 bronze badges

Find out what setting were used for a given stored procedure

Awarded Mar 1 at 12:08

Aaron Bertrand

178k27 gold badges391 silver badges602 bronze badges

SQL Server 2012 Availability Group is it "AlwaysON"?

Awarded Feb 28 at 20:49

Brent Ozar

42.5k46 gold badges208 silver badges363 bronze badges

In a multi-database AG, what decides which databases will have more than 1 redo thread?

Awarded Feb 28 at 15:11

Paul White♦

80.3k28 gold badges396 silver badges618 bronze badges

UUID or BIGSERIAL Foreign Keys Postgres

Awarded Feb 27 at 18:11

Erwin Brandstetter

167k23 gold badges413 silver badges561 bronze badges

How to perform multiple inserts into postgresql database in one query

Awarded Feb 24 at 13:34

a_horse_with_no_name

78.3k14 gold badges158 silver badges194 bronze badges

Cannot INSERT Into Newly Created Column

Awarded Feb 22 at 21:03

spaghettidba

11.2k29 silver badges42 bronze badges

Why does sys.fn_xe_file_target_read_file require an explicit cast on datetime2 column?

Awarded Feb 22 at 16:51

Paul White♦

80.3k28 gold badges396 silver badges618 bronze badges

How do I specify a linked server to a remote database over tcp/ip?

Awarded Feb 21 at 11:26

spaghettidba

11.2k29 silver badges42 bronze badges

SELECT Statement with , * in column list is faster than same statement without *

Awarded Feb 18 at 12:09

Erik Darling

37.5k14 gold badges128 silver badges398 bronze badges

How to concatenate two column of different types in sql? (without getting some strange warning)

Awarded Feb 15 at 15:41

Paul White♦

80.3k28 gold badges396 silver badges618 bronze badges

how to test if XML = '' in sql server?

Awarded Feb 14 at 19:11

i-one

2,3342 gold badges11 silver badges22 bronze badges

Postgres - count of GROUP BY

Awarded Feb 13 at 0:18

ypercubeᵀᴹ

96.1k13 gold badges209 silver badges302 bronze badges

Why does SQL Server not do compound column statistics histograms?

Awarded Feb 12 at 20:34

Paul White♦

80.3k28 gold badges396 silver badges618 bronze badges

sp_WhoIsActive vs sp_BlitzFirst @ExpertMode = 1

Awarded Feb 12 at 16:58

Brent Ozar

42.5k46 gold badges208 silver badges363 bronze badges

How to backup an Oracle database from SQL Developer

Awarded Feb 10 at 16:57

John K. N.

16.6k10 gold badges47 silver badges106 bronze badges

2 3 4 5

…

54 Next