Notable Question - Badge - Database Administrators Stack Exchange

Notable Question

Question with 2,500 views. This badge can be awarded multiple times.

Awarded 27236 times.

How to solve Zabbix database is not available

Awarded 22 mins ago

W-P

11 silver badge2 bronze badges

New SQL Server with slow Index Spool (Eager Spool) and old server used index

Awarded 1 hour ago

RealYlem

311 silver badge4 bronze badges

Heartbeat frequency in AWS DMS (Database Migration Service)?

Awarded 5 hours ago

David Han

11 silver badge1 bronze badge

InnoDB buffer getting higher every day. How to flush the buffer pool?

Awarded 9 hours ago

Jose M Martin

1431 silver badge6 bronze badges

How to execute alter database commands from DbUp scripts?

Awarded 13 hours ago

ChrisS

1211 silver badge3 bronze badges

why mysql only works for root user?

Awarded 21 hours ago

xrfang

1431 silver badge8 bronze badges

database does not open and not mounted

Awarded yesterday

Media Abdo

11 silver badge1 bronze badge

PostgreSQL - when is pg_advisory_xact_lock released, and when will persisted data be visible to other transactions

Awarded yesterday

Justin Lowen

361 silver badge6 bronze badges

Getting Identity values to use as FK in an INSTEAD OF trigger

Awarded 2 days ago

JNK

18k5 gold badges62 silver badges98 bronze badges

'Number of referencing columns in foreign key differs from number of referenced columns' CONFUSION [closed]

Awarded 2 days ago

CBarrow

111 silver badge3 bronze badges

Remote Desktop SQL Server Management Studio Dialog boxes Font size too small

Awarded 2 days ago

Naveed Ahmed

1111 silver badge6 bronze badges

How to get data from different table having same column?

Awarded 2 days ago

Rehan

732 silver badges10 bronze badges

Is there a disk space impact when choosing NULL vs empty array {} for the default of an ARRAY[] column? [duplicate]

Awarded 2 days ago

GollyJer

4014 silver badges13 bronze badges

Sql server agent job question - maximum run time

Awarded Sep 13 at 6:35

GopiMth

311 silver badge4 bronze badges

How to use "regular expression" to separate specific strings in Oracle

Awarded Sep 12 at 18:21

Pantea

1,4325 gold badges26 silver badges58 bronze badges

Copying a table (and all of its data) from one server to another?

Awarded Sep 12 at 14:56

J. Mini

6356 silver badges20 bronze badges

Does UPDATE write a new row version for unchanged, TOASTed values?

Awarded Sep 12 at 12:57

Jason

1831 silver badge5 bronze badges

Postgres Updating only changed columns as against entire row

Awarded Sep 12 at 12:33

tuk

1,2431 gold badge14 silver badges22 bronze badges

Dealing with measure groups of different granularity

Awarded Sep 12 at 11:02

siride

1161 silver badge7 bronze badges

How to check if a PostgreSQL table is temporary?

Awarded Sep 12 at 8:41

tinlyx

3,67214 gold badges48 silver badges78 bronze badges

Postgres grant issue on select from view, but not from base table

Awarded Sep 11 at 15:20

polyglot

1331 silver badge4 bronze badges

RMAN restore of primary database - impact on standby database

Awarded Sep 11 at 14:51

Franco

513 silver badges14 bronze badges

SQL Server 2019 - using MSA as a proxy account

Awarded Sep 11 at 13:42

AnJ

1413 silver badges9 bronze badges

Verify if I can use a given directory

Awarded Sep 11 at 12:43

Álvaro González

1,0795 gold badges17 silver badges32 bronze badges

Do long names for jsonb keys use more storage?

Awarded Sep 11 at 11:58

davidtgq

7391 gold badge8 silver badges21 bronze badges

MySQL 8 not using Spatial Index?

Awarded Sep 11 at 11:33

Lee Armstrong

1331 silver badge7 bronze badges

'Ungroup' data based on column

Awarded Sep 11 at 10:06

Christophe Loeys

231 silver badge5 bronze badges

Efficiently finding distinct values

Awarded Sep 11 at 5:11

Bob Jansen

3955 silver badges15 bronze badges

What are the risks in moving from GDR to CU servicing option?

Awarded Sep 11 at 3:02

variable

3,4514 gold badges35 silver badges87 bronze badges

Surprising results for data types with type modifier

Awarded Sep 11 at 3:02

Erwin Brandstetter

180k28 gold badges450 silver badges611 bronze badges

select data from table which dont have row in another table

Awarded Sep 10 at 19:33

vdonis

231 silver badge5 bronze badges

MySQL 8.0 memory usage continuously growing

Awarded Sep 10 at 18:04

deem

1132 silver badges6 bronze badges

MySQL - using result of Procedure in Trigger to Insert in new table

Awarded Sep 10 at 16:42

IGGt

2,1666 gold badges31 silver badges48 bronze badges

Create column for values between a range sql

Awarded Sep 10 at 13:52

Christopher Karsten

3196 silver badges11 bronze badges

PostgreSQL jsonb_set performance

Awarded Sep 10 at 11:20

Kaplan Ilya

1731 silver badge7 bronze badges

Amazon RDS index creation on large table over 300 M records

Awarded Sep 10 at 10:27

nomad123

211 silver badge3 bronze badges

ReFS Vs NTFS for SQL Server 2019, server 2019

Awarded Sep 10 at 9:10

Cheerful DBA

711 silver badge4 bronze badges

Create event trigger as non-superuser in Postgres

Awarded Sep 10 at 2:47

matt

1411 silver badge2 bronze badges

Restrict access to a new schema to a specific role despite users having db_datareader?

Awarded Sep 9 at 21:11

Crescent

131 silver badge5 bronze badges

sp_executesql - What is wrong with my Parameter-string?

Awarded Sep 9 at 17:17

krystah

7479 silver badges19 bronze badges

How to set CHECK_POLICY OFF in the sql script

Awarded Sep 9 at 15:38

StackUser

1011 silver badge1 bronze badge

PostgreSQL equivalent to Oracle's ANY_VALUE(...) KEEP (DENSE_RANK FIRST/LAST ORDER BY ...)

Awarded Sep 9 at 1:00

User1974

1,49724 silver badges53 bronze badges

What's the difference between partitions and many tables?

Awarded Sep 8 at 21:10

user2189731

1411 silver badge3 bronze badges

How to migrate from MySQL to MariaDB or Percona with minimum downtime?

Awarded Sep 8 at 20:22

Daniel Cukier

1652 silver badges9 bronze badges

Restore Verify Only w/ Transaction Log Backups

Awarded Sep 8 at 16:34

Dave Mason

8851 gold badge7 silver badges19 bronze badges

MySQL on Ubuntu consuming almost all RAM

Awarded Sep 7 at 15:28

Nick

1111 silver badge3 bronze badges

Is a clustered index on column A the same as creating a table ordered by A?

Awarded Sep 7 at 5:20

pietrop

7261 gold badge7 silver badges16 bronze badges

Seemingly identical WHERE clauses returning different results

Awarded Sep 6 at 20:17

Philip Stratford

2352 silver badges7 bronze badges

How to store tax in the database when tax consists of multiple taxes

Awarded Sep 6 at 20:17

j10

2891 gold badge8 silver badges16 bronze badges

Insert/update loop ORACLE function

Awarded Sep 6 at 19:30

Luc

11 silver badge2 bronze badges

Tempdb data file disappearing

Awarded Sep 6 at 14:20

Mansfield

1,0318 gold badges18 silver badges33 bronze badges

SQL Cursor vs WHILE loop

Awarded Sep 6 at 11:12

Craig

5031 gold badge5 silver badges11 bronze badges

What are the possible downsides or consequences of using ALGORITHM=INPLACE, LOCK=NONE when running alters on a table?

Awarded Sep 6 at 9:32

user3509128

411 silver badge2 bronze badges

Can't enable wal2json in postgres 12 docker image

Awarded Sep 6 at 7:19

Ayush

1211 silver badge4 bronze badges

PERCENT_RANK does not distribute over 100

Awarded Sep 6 at 6:47

Saeed Neamati

1,4853 gold badges20 silver badges34 bronze badges

How do I build a PostgreSQL ORDER BY expression based on a concatenation of columns?

Awarded Sep 6 at 6:17

Dave

72310 gold badges22 silver badges38 bronze badges

How to use FIRST_VALUE window function in MySQL/MariaDB to get one row per group?

Awarded Sep 5 at 16:48

artfulrobot

4279 silver badges19 bronze badges

Compare byte value to bytea column

Awarded Sep 5 at 15:09

maax

1752 silver badges6 bronze badges

Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?

Awarded Sep 5 at 13:35

AngryHacker

1,9515 gold badges21 silver badges33 bronze badges

Having problems joining a database to an Availability Group on the secondary replica

Awarded Sep 5 at 13:26

PTL_SQL

3733 gold badges9 silver badges18 bronze badges

2 3 4 5

…

454 Next