Notable Question - Badge - Database Administrators Stack Exchange

Notable Question

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

Awarded 26250 times.

Log for database tempdb is not available

Awarded 5 hours ago

Learning_DBAdmin

3,89416 silver badges36 bronze badges

Oracle database doesn't go to upgrade mode

Awarded 6 hours ago

Saurabh

211 silver badge4 bronze badges

Is there a way to dynamically update records based on values in one column and using that value to find a matching column name?

Awarded 10 hours ago

Dolfandave

11 silver badge2 bronze badges

How to get number of begin transactions in PostgreSQL?

Awarded 13 hours ago

hunterex

1473 silver badges7 bronze badges

postgres how to modify composite primary key order

Awarded 13 hours ago

Ziqi Liu

1151 silver badge5 bronze badges

Converting PostgreSQL dump file into CSV files

Awarded 15 hours ago

sreejan patel

111 silver badge3 bronze badges

Bitmap Creation in Execution Plan Causes bad Estimate on Clustered Index Scan

Awarded 18 hours ago

SE1986

1,9604 gold badges25 silver badges55 bronze badges

Is there a use for a READ COMMITTED READ ONLY transaction?

Awarded yesterday

Eloff

1431 silver badge5 bronze badges

error 15466 An error during decryption

Awarded yesterday

user183067

11 silver badge1 bronze badge

How do You concatenate a value to an array that was retrieved through a query in sql?

Awarded yesterday

M.Templeman

782 silver badges7 bronze badges

select string that doesn't contain a substring/field

Awarded yesterday

jkcrosby3

111 silver badge3 bronze badges

Does PostgreSQL ever retry failed transactions internally?

Awarded yesterday

lijat

1231 silver badge4 bronze badges

PostgreSQL relation size does not sum up

Awarded yesterday

Adam Matan

11.7k29 gold badges81 silver badges95 bronze badges

Corrupted ibdata1 and can't run server

Awarded yesterday

karatecode

1211 silver badge3 bronze badges

Understanding composite BTREE + GIN_TRGM_OPS index prioritization & odd lower() behavior

Awarded yesterday

Jeff B.

1411 silver badge3 bronze badges

Problem with SELECT CASE WHEN THEN, 0 result [closed]

Awarded yesterday

Vladimir Ch

1391 silver badge8 bronze badges

creating new table partition with values already existing in the default partition

Awarded yesterday

moshevi

1971 silver badge8 bronze badges

Error Severity 16 Alert being raised for events where is_event_logged = 0

Awarded yesterday

SE1986

1,9604 gold badges25 silver badges55 bronze badges

ROLLBACK TO SAVEPOINT syntax error at or near "TO"

Awarded 2 days ago

unknownUser

294 silver badges11 bronze badges

How to change SQL sever configuration manager settings using TSQL?

Awarded 2 days ago

StanleyJohns

5,9622 gold badges23 silver badges44 bronze badges

SELECT LATEST ENTRY ON GROUP BY

Awarded 2 days ago

dumebi

131 silver badge4 bronze badges

Postgres evaluates syntax error as boolean in Update statement

Awarded 2 days ago

BjornTuroque

211 silver badge2 bronze badges

pg_waldump: command not found

Awarded Apr 14 at 15:18

Slava Rozhnev

1471 silver badge9 bronze badges

Query for lowest price for product in same row

Awarded Apr 14 at 13:43

lakyller

131 silver badge3 bronze badges

How do I query only rows where multiple instances with the same ID exist with Postgres?

Awarded Apr 14 at 10:50

Alexis Wilke

1252 silver badges11 bronze badges

Are idx_scan statistics reset automatically (default)?

Awarded Apr 14 at 8:09

Gabriel

1531 silver badge5 bronze badges

Get id, distinct idLocal of the MIN(datetime) in MySQL

Awarded Apr 13 at 16:47

Carlos Quiroga

1131 silver badge5 bronze badges

How to clean sysaux table in Oracle 19c SE2

Awarded Apr 13 at 3:26

Tomasz Myszak

191 silver badge3 bronze badges

DDL changes Tracking

Awarded Apr 13 at 2:17

Tharun

191 silver badge2 bronze badges

Postgres JSON field for many to many relationships

Awarded Apr 12 at 20:11

swastik

231 silver badge4 bronze badges

Postgres - How to get Multi-Count Query using a Where Clause for a Join Table

Awarded Apr 12 at 12:27

daniel9x

3611 gold badge11 silver badges20 bronze badges

How do I intentionally fragment a SQL Server Index?

Awarded Apr 12 at 12:07

mororo

1931 silver badge6 bronze badges

Inserting data into the VIEW , result in data being inserted into the original table, why is this happening?

Awarded Apr 12 at 8:55

Pantea

1,4125 gold badges24 silver badges53 bronze badges

How do I find out what's causing processes to wait for table flush?

Awarded Apr 12 at 7:40

kenshin9

1191 silver badge3 bronze badges

Uniquely Append to Array on Conflict PostgreSQL

Awarded Apr 12 at 4:32

Craslam

331 silver badge3 bronze badges

Constrain array values to an allowed set of values

Awarded Apr 11 at 22:05

AndreKR

5877 silver badges18 bronze badges

Group by with limit

Awarded Apr 11 at 17:41

omri

44010 silver badges21 bronze badges

Oracle SQL Creating Copy of Table Using DBMS_metadata

Awarded Apr 11 at 16:04

Blued00d

111 silver badge3 bronze badges

Pre Caching Index on a large table in PostgrSQL

Awarded Apr 11 at 14:06

Karlson

1811 silver badge7 bronze badges

SQL - select latest 100 records and group by a column that is not the key or date

Awarded Apr 11 at 10:49

Tessaract

1672 silver badges7 bronze badges

Users who are connected into the database

Awarded Apr 11 at 10:49

alexsilviu05

151 silver badge4 bronze badges

Upgrade from MySQL 5.7 to MySQL 8 massive drop in performance occasionally

Awarded Apr 11 at 8:35

Colm Canavan

311 silver badge3 bronze badges

SQL Server Agent Services not Coming Up

Awarded Apr 11 at 7:40

SSS

3971 gold badge8 silver badges16 bronze badges

SQL Server PIVOT returns only one row [duplicate]

Awarded Apr 11 at 7:32

Arturo Gonzalez

171 silver badge4 bronze badges

Why do I get Invalid identifier error even though column exist [closed]

Awarded Apr 10 at 16:55

Sly

111 silver badge7 bronze badges

Postgresql: how to enable pg_stat_replication_slots?

Awarded Apr 10 at 16:55

Thiago Sayão

4578 silver badges16 bronze badges

How to select data in a sub query only once?

Awarded Apr 10 at 15:35

Kshitiz Sharma

3,2479 gold badges32 silver badges35 bronze badges

Oracle Database XE : [FATAL] [DBT-50000] Unable to check available system memory

Awarded Apr 10 at 13:40

eng ahmed

31 silver badge2 bronze badges

SST not starting on a new node on MariaDB Galera Cluster

Awarded Apr 10 at 13:18

Mat

1432 silver badges10 bronze badges

Does freeing up disk space improve the performance of MySQL?

Awarded Apr 10 at 13:10

Kryten

2851 gold badge5 silver badges9 bronze badges

SQL Server stored procedure permissions

Awarded Apr 10 at 12:19

Eric Smith

2931 gold badge3 silver badges7 bronze badges

SQL Server query across several linked servers - abysmal performance

Awarded Apr 10 at 8:36

AcePL

3491 gold badge4 silver badges15 bronze badges

Database design: Dividing multiple identical tables, good or bad?

Awarded Apr 10 at 8:15

Kalec

1731 silver badge5 bronze badges

design database for electrical meter data?

Awarded Apr 10 at 6:52

NinjaDeveloper

2451 gold badge6 silver badges16 bronze badges

How can I disable mysql_native_password and mysql_old_password on MariaDB / MySQL?

Awarded Apr 10 at 6:15

NoExpert

1011 silver badge2 bronze badges

PostgreSQL's record type returning null?

Awarded Apr 9 at 20:51

rdnobrega

1231 silver badge4 bronze badges

Enabling admin connection on SQL Server Express to fix logon trigger

Awarded Apr 9 at 19:22

Racer SQL

7,38614 gold badges70 silver badges130 bronze badges

Install Express/Standard side-by-side

Awarded Apr 9 at 14:58

InteXX

5592 gold badges7 silver badges17 bronze badges

How to fetch latest rows from oracle db [duplicate]

Awarded Apr 9 at 14:35

muniya

111 silver badge3 bronze badges

Optimising a query for matching multiple values on a related table

Awarded Apr 9 at 13:25

M Polak

1131 silver badge6 bronze badges

2 3 4 5

…

438 Next