Popular Question - Badge - Database Administrators Stack Exchange

Popular Question

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

Awarded 46468 times.

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

2471 silver badge11 bronze badges

Mysql: Any way to properly index 3 ENUM columns with the same options ? (A OR B OR C)

Awarded Jul 1 at 14:00

John

4021 gold badge6 silver badges16 bronze badges

find error log for streaming replication

Awarded Jul 1 at 11:11

padjee

3071 gold badge9 silver badges24 bronze badges

Validate a column if it contains a character, using check constraint in postgresql

Awarded Jul 1 at 10:04

jerin kj

335 bronze badges

Why is this postgres query ignoring the index in the subquery?

Awarded Jul 1 at 9:22

Richard Wheeldon

1335 bronze badges

Trigger function error: Record "old" not yet assigned

Awarded Jul 1 at 8:18

Spiran

1331 silver badge5 bronze badges

Table design for ticket sales

Awarded Jul 1 at 2:51

mgaldieri

531 silver badge6 bronze badges

Facing deadlock after introducing a new Non-clustered Index on Heap

Awarded Jun 30 at 20:18

Learning_DBAdmin

3,90416 silver badges37 bronze badges

Should I stop my PostgreSQL server before reboot?

Awarded Jun 30 at 18:07

Tom

4281 gold badge6 silver badges20 bronze badges

DBCC CHECKDB error

Awarded Jun 30 at 9:05

LeraningDBA

3311 gold badge3 silver badges16 bronze badges

"SQL_NO_CACHE" for innodb buffer pool

Awarded Jun 30 at 7:52

atxdba

5,2735 gold badges40 silver badges61 bronze badges

New SQL Server 2022 slower than old 2014 server

Awarded Jun 29 at 14:51

JulioQc

1431 silver badge9 bronze badges

Resolving high VLF count when database is part of an Availability Group

Awarded Jun 29 at 11:01

Jim Vogler

1231 silver badge7 bronze badges

MySQL/PHP - SELECT DISTINCT column based on another column with ORDER and LIMIT

Awarded Jun 29 at 7:04

amatek

1012 bronze badges

Postgresql import csv failing on quoted \r\n

Awarded Jun 29 at 2:48

JHerbst

15 bronze badges

Restoring databases using only .frm, .ibd files

Awarded Jun 29 at 2:48

Buttered_Toast

1034 bronze badges

Export varbinary to file (image) from multiple rows

Awarded Jun 28 at 17:26

H. Salem

112 bronze badges

How to sort by joined table property in PostgreSQL?

Awarded Jun 28 at 15:25

Lance

2112 silver badges14 bronze badges

How to sort values starting with a letter followed up by a number?

Awarded Jun 28 at 13:57

A.bakker

1116 bronze badges

Can sequential queries result in concurrent transactions?

Awarded Jun 28 at 12:41

ben

1555 bronze badges

Extract date from string t-sql

Awarded Jun 28 at 11:17

snorlaks

11 bronze badge

Does MySql event will start if the previous event doesn't finish yet?

Awarded Jun 28 at 5:33

zer09

4531 gold badge4 silver badges12 bronze badges

How to sort strings with special characters in Hibernate?

Awarded Jun 28 at 4:17

a3.14_Infinity

1114 bronze badges

Unknown column 'Rating' in 'having clause'

Awarded Jun 28 at 1:40

Bernardo Castanheira

112 bronze badges

How to make sure change_tracking statistics stays updated

Awarded Jun 28 at 0:16

Danielle Paquette-Harvey

2,0291 gold badge17 silver badges28 bronze badges

How to determine the collation of an index in PostgreSQL?

Awarded Jun 27 at 15:17

soliz

2931 silver badge10 bronze badges

PSQL avoid insert failing because a trigger failed

Awarded Jun 27 at 14:57

Eugenio.Gastelum96

1011 bronze badge

is it safe to compress backups for databases with TDE enabled?

Awarded Jun 27 at 14:32

Racer SQL

7,41614 gold badges72 silver badges134 bronze badges

Short circuit evaluation in CASE in PostgreSQL

Awarded Jun 27 at 13:16

Nebehr Gudahtt

374 bronze badges

MySQL: how to replicate users in master-master configuration

Awarded Jun 27 at 12:49

petob

32 bronze badges

How to optimize information schema table in mysql?

Awarded Jun 27 at 6:19

open source guy

1011 bronze badge

Regex replace to ignore certain pattern at the beginning if exists and format the rest

Awarded Jun 27 at 5:26

ma1169

1135 bronze badges

Can I revert a transaction after a certain number of days

Awarded Jun 26 at 21:42

SP1

2432 gold badges4 silver badges10 bronze badges

Multi-expression indexes in PostgreSQL not using being used as expected

Awarded Jun 26 at 20:01

Jake Feasel

6072 gold badges7 silver badges23 bronze badges

Link DAX OpenQuery Output to SQL Server Temp Table

Awarded Jun 26 at 19:26

DimUser

3821 gold badge2 silver badges16 bronze badges

How and when is the transaction logs truncated in MSSQL in AWS RDS?

Awarded Jun 26 at 13:58

Dmitry

513 bronze badges

impdp syntax for schema that is not available on other database

Awarded Jun 26 at 13:47

Newbie-oracle

112 bronze badges

Using two transactions at the same time without getting Lock wait timeout exceeded

Awarded Jun 26 at 12:16

Steve Moretz

1034 bronze badges

Does a MySQL dump that contains triggers double data on import?

Awarded Jun 26 at 12:11

SAGAR Nair

1872 silver badges10 bronze badges

Time-Based Partition Function Split Moving Data to New FG Despite Boundary in the Future

Awarded Jun 26 at 11:48

MattyZDBA

1,9333 gold badges19 silver badges30 bronze badges

Temporarily Turn Off Table Type Reference Checking On A Development Database

Awarded Jun 26 at 8:18

ΩmegaMan

4091 gold badge8 silver badges22 bronze badges

Why am I getting this ANSI warning about NULL values and aggregate functions?

Awarded Jun 26 at 6:56

Matt

3951 gold badge4 silver badges11 bronze badges

How to select name by 2 fields in another 2 tables in mySQL

Awarded Jun 26 at 6:40

Leepotchi

32 bronze badges

designing a database with type and sub type

Awarded Jun 26 at 6:26

StillLearningToCode

1134 bronze badges

Auto created Statistics vs Manually created Statistics

Awarded Jun 25 at 21:36

Pரதீப்

1,3895 gold badges18 silver badges37 bronze badges

Update with rolling sum grouped by another column

Awarded Jun 25 at 20:35

Daniel

1116 bronze badges

XML Query keeps converting < to < and > to >

Awarded Jun 25 at 18:20

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Deleting hundreds milion of rows in single MySQL query

Awarded Jun 25 at 17:31

Pavol Hejný

11 bronze badge

Duplicating a Database with RMAN

Awarded Jun 25 at 16:51

Cell-o

1,0888 gold badges21 silver badges40 bronze badges

Why is MySQL InnoDB table copied despite using ALGORITHM=INPLACE for ALTER TABLE

Awarded Jun 25 at 14:48

FBB

1136 bronze badges

Temporal Table: Multiple inserts on each update?

Awarded Jun 25 at 13:21

Paul Perrick

1535 bronze badges

Why are connections to Cassandra nodes timing-out during low traffic periods?

Awarded Jun 25 at 12:41

Erick Ramirez

3,8401 gold badge7 silver badges26 bronze badges

Memory distribution across numa nodes within Sql server

Awarded Jun 25 at 11:16

BeginnerDBA

2,1803 gold badges26 silver badges51 bronze badges

postgresql change clustername but pg_lsclusters say it not changed

Awarded Jun 25 at 9:47

jian

4474 silver badges17 bronze badges

Index for date part of field?

Awarded Jun 25 at 8:01

Glasnhost

4781 gold badge6 silver badges18 bronze badges

Finding MySQL Tables with no primary key OR no composite key

Awarded Jun 25 at 7:56

tadamhicks

1094 bronze badges

Insert select - using selected value in ON DUPLICATE KEY UPDATE

Awarded Jun 25 at 6:07

cb7

1351 silver badge3 bronze badges

AG node getting "misaligned log IOs which required falling back to synchronous IO" events in error log

Awarded Jun 25 at 5:08

Ollie2308

113 bronze badges

How to change query tool font and colors in PgAdmin 4?

Awarded Jun 25 at 3:47

Joe M

1219 bronze badges

Prev 1 2 3

…

775 Next