Popular Question - Badge - Database Administrators Stack Exchange

Popular Question

Question with 1,000 views. This badge can be awarded multiple times.

Awarded 46346 times.

MariaDB partitioning table and query performance

Awarded 42 mins ago

forke

153 bronze badges

Split intervals

Awarded 7 hours ago

Michael Green

24.9k13 gold badges53 silver badges98 bronze badges

What Account should SQL service use?

Awarded 8 hours ago

Depth of Field

2331 silver badge7 bronze badges

Storing many pandas DataFrames in SQLite with metadata

Awarded 9 hours ago

smcs

1135 bronze badges

How to execute a query based on the condition if a column exists?

Awarded 13 hours ago

T.H.

3073 gold badges8 silver badges14 bronze badges

Backing up Master-Master replicated MySQL databases

Awarded 14 hours ago

movieglass

113 bronze badges

Operation not allowed from within a pluggable database Pre-Built Developer VMs for Oracle VM VirtualBox

Awarded 14 hours ago

Tomas A

32 bronze badges

PARALLEL_MIN_TIME_THRESHOLD parameter when AUTO or MANUAL mode

Awarded 16 hours ago

shawn

2013 silver badges12 bronze badges

Is an anomaly possible if a serializable transaction interfers with another isolation level?

Awarded 18 hours ago

Markus Malkusch

1418 bronze badges

Why would a scheduled job fail in SQL Developer?

Awarded 23 hours ago

Andrew Hicks

1115 bronze badges

Failure to initialise MySQL Server 5.7 due to mysqlx_port=0.0

Awarded yesterday

Harold

1012 bronze badges

Modeling Polymorphic Relations in Postgres 15 with bi-directional (cyclic) FK constraints

Awarded yesterday

untitled90

112 bronze badges

confusion when converting unix timestamp to timestamp with timezone

Awarded yesterday

Stuck

1275 bronze badges

DB2 "activate database" command not working on the second instance

Awarded 2 days ago

user116722

11 bronze badge

Office Hours in PostgreSQL

Awarded 2 days ago

guettli

1,5315 gold badges24 silver badges51 bronze badges

How to force MySQL master to overwrite the slave

Awarded 2 days ago

kebugcheck

33 bronze badges

In ADF, are copy data activities wrapped in transactions?

Awarded Jul 5 at 20:51

Schmocken

1012 bronze badges

Restrict access on specific database from windows users

Awarded Jul 5 at 17:32

seb

12 bronze badges

Extended Event Session Keeps Stopping

Awarded Jul 5 at 13:09

William

1416 bronze badges

SQL server not listing records with NULL values

Awarded Jul 5 at 5:19

Midhun C N

3706 silver badges17 bronze badges

Large database partitioning and backups of only updated data (partial backups)

Awarded Jul 5 at 4:37

Ruben Obregon

212 bronze badges

Monitor FOR loop progress in postgres

Awarded Jul 5 at 3:33

amball

1235 bronze badges

Postgres default privileges do not seem to work

Awarded Jul 4 at 18:48

ACC

1055 bronze badges

Running mysql without password and default user in Ubuntu?

Awarded Jul 4 at 14:21

mommomonthewind

1011 bronze badge

Service Broker - Add to queue but don't process till later

Awarded Jul 4 at 14:07

Ste Bov

2,0911 gold badge13 silver badges19 bronze badges

ORA 01918: user '...' does not exist

Awarded Jul 4 at 11:52

tomiealff

12 bronze badges

Allow for dynamic result sets from plpgsql function by filtering based on an array passed in?

Awarded Jul 4 at 11:17

Wildcard

5886 silver badges17 bronze badges

Why can't postgres index a text casted enum

Awarded Jul 4 at 11:05

CY-OD

1093 bronze badges

Security Considerations/Risks/Best Practices for Enabling CLR Integration (Assemblies) for SSIS Catalog

Awarded Jul 4 at 9:51

user3621633

2752 silver badges10 bronze badges

SSRS and Informix connection

Awarded Jul 4 at 8:17

Tsukasa

3191 silver badge14 bronze badges

Issue with Time Zone while migrating MySQL on-premises DB to AWS RDS

Awarded Jul 4 at 2:05

Phanindra

1,0075 gold badges15 silver badges31 bronze badges

char or smallint for a column with numeric codes?

Awarded Jul 3 at 19:27

axdna

1111 silver badge10 bronze badges

Is it a good idea to join data from two different databases?

Awarded Jul 3 at 18:55

jaffer_syed

132 bronze badges

AWS Aurora Mysql seemingly not picking PRIMARY or secondary index

Awarded Jul 3 at 17:19

Randoneering

1358 bronze badges

Performance degradation while updating tables having 10s of millions of records

Awarded Jul 3 at 14:16

Bhavik Ambani

1671 gold badge2 silver badges13 bronze badges

Oracle database won't start, ORA-03113

Awarded Jul 3 at 12:42

user46688

1498 bronze badges

Query to list all the databases that have a specific user

Awarded Jul 3 at 12:12

sqllover2020

832 silver badges12 bronze badges

WordPress MySQL writes during "Flush Tables With Read Lock" are rejected instead of being queued

Awarded Jul 3 at 12:07

Dan

12 bronze badges

Restoring old raw backup in MariaDB 10.8.1+ without ib_logfile0

Awarded Jul 3 at 11:56

VirtualVoid

1135 bronze badges

How can I handle cycles / infinite loops in recursive CTEs in MySQL

Awarded Jul 3 at 10:30

ahron

8132 gold badges10 silver badges19 bronze badges

Using "sp_execute_external_script" as alternative of "sp_invoke_external_rest_endpoint" in SQL Server

Awarded Jul 3 at 7:27

gotqn

4,02611 gold badges50 silver badges85 bronze badges

Sort pivot result

Awarded Jul 3 at 4:55

Glenn

33 bronze badges

DBATools :: how to query Azure SQL Databases with MFA

Awarded Jul 3 at 0:55

Francesco Mantovani

1,60912 silver badges27 bronze badges

SQL Server : how to decide if FULL backup or DIFFERENTIAL

Awarded Jul 2 at 22:47

Remo

12 bronze badges

how to avoid hash right join

Awarded Jul 2 at 19:27

Daria

12 bronze badges

How to use UNNEST hint in Oracle Database?

Awarded Jul 2 at 13:57

Astora

7613 gold badges20 silver badges52 bronze badges

Set simple parameterization for a json_value query (without using plan guides)

Awarded Jul 2 at 13:11

Factor Mystic

2412 silver badges9 bronze badges

MySQL replication - Follower stuck and behind

Awarded Jul 2 at 11:58

Sisir

1414 bronze badges

Large hexadecimal PRIMARY KEY - how to index substrings of the PK field?

Awarded Jul 2 at 10:35

Deele

1435 bronze badges

Are online index REBUILD operation possible on every Azure SQL database?

Awarded Jul 2 at 9:06

Alexandre D.

1013 bronze badges

Why do I have multiple (unassociated) temporal history tables?

Awarded Jul 2 at 9:06

MrB

833 bronze badges

Database in simple recovery to save space

Awarded Jul 2 at 1:55

A_V

1,3644 gold badges18 silver badges31 bronze badges

What is the best strategy for changing a primary key from int to bigint in postgres when the column has dependencies?

Awarded Jul 2 at 0:50

Doug Mill

213 bronze badges

MySQL indexes on temp tables

Awarded Jul 1 at 23:25

im123

12 bronze badges

Why does postgres use more space for a time with timezone than a timestamp with timezone?

Awarded Jul 1 at 23:07

Matthew Finlay

1754 bronze badges

Equivalent of utf8_general_ci in Postgres/ICU?

Awarded Jul 1 at 22:37

AndreKR

5977 silver badges19 bronze badges

Why a backup created on SQL Server 2016 is significantly larger than one created on SQL Server 2012?

Awarded Jul 1 at 21:11

Wesley

212 bronze badges

Which hard disks for PostgreSQL? [closed]

Awarded Jul 1 at 20:50

guettli

1,5315 gold badges24 silver badges51 bronze badges

Access table field inside CREATE TRIGGER statement

Awarded Jul 1 at 16:48

user3325976

1312 bronze badges

Optimal order for creating a composite index in PostgreSQL with multiple conditions

Awarded Jul 1 at 15:50

sujeet

2451 silver badge10 bronze badges

2 3 4 5

…

773 Next