Notable Question - Badge - Database Administrators Stack Exchange

Notable Question

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

Awarded 24816 times.

MongoDB: is order guaranteed deep into the aggregation pipeline?

Awarded 44 mins ago

Adam Rackis

1952 silver badges7 bronze badges

Using ODBC drivers to connect to Postgres database via Powershell

Awarded 6 hours ago

ConanTheGerbil

1,0654 gold badges23 silver badges38 bronze badges

E/R diagram for sports league database

Awarded 17 hours ago

chaitra

311 silver badge2 bronze badges

Does MERGE use tempdb?

Awarded 20 hours ago

Craig Efrein

9,63012 gold badges56 silver badges96 bronze badges

Create trigger to insert rows from one table to another with sum operation (group by)

Awarded 22 hours ago

Yogesh Patel

31 silver badge4 bronze badges

Approximate MySQL Query Time For A Where Clause On A 10 Million Records Table

Awarded yesterday

Omar Tariq

1091 silver badge4 bronze badges

Tracking the last execution date of a query

Awarded yesterday

Shawn

231 silver badge3 bronze badges

JSONB: Finding an element with a null attribute in array of objects

Awarded 2 days ago

jprado

1031 silver badge4 bronze badges

Null Values in a CASE statement

Awarded 2 days ago

user2921015

1111 silver badge3 bronze badges

Do we have to run auto update statistics after index rebuild?

Awarded 2 days ago

Red Devil

2274 silver badges12 bronze badges

How do I stop WAL streaming in BARMAN cron?

Awarded 2 days ago

Troy Meyerink

11 silver badge1 bronze badge

Difference between PRIMARY KEY and SERIAL (with index)

Awarded 2 days ago

ConanTheGerbil

1,0654 gold badges23 silver badges38 bronze badges

postgresql handle conflict on delete

Awarded 2 days ago

samf

311 silver badge4 bronze badges

count(*) queries are too slow even with an index only scan

Awarded 2 days ago

greekblog

1291 silver badge3 bronze badges

what is oracle shiphome?

Awarded 2 days ago

malatesh

1946 silver badges14 bronze badges

Does UPDLOCK guarantee concurrency

Awarded 2 days ago

user1786107

2252 silver badges6 bronze badges

Where can I find the SQL standard document?

Awarded 2 days ago

Philᵀᴹ

31.6k10 gold badges81 silver badges107 bronze badges

How to tell if there are currently any long running queries executing?

Awarded 2 days ago

Shaul Behr

2,9138 gold badges31 silver badges41 bronze badges

Postgres Repeatable Read vs Serializable

Awarded 2 days ago

user4184113

1611 silver badge2 bronze badges

MySQL dead-locking with UPDATE JOIN and INSERT SELECT statements

Awarded 2 days ago

Arth

1251 silver badge5 bronze badges

Automatically invoke `SET ROLE` when connecting to PostgreSQL

Awarded Sep 28 at 19:27

pat

1631 silver badge5 bronze badges

postgresql database cluster vs one server with many databases

Awarded Sep 28 at 14:09

padjee

1576 silver badges15 bronze badges

Oracle Materialized View Refresh Group - Montly Interval

Awarded Sep 28 at 11:06

Diomedes

1111 silver badge2 bronze badges

Is it possible to use OPENROWSET to import fixed width UTF8 encoded files?

Awarded Sep 28 at 10:21

Martin Smith

83.1k15 gold badges235 silver badges329 bronze badges

Dynamically update JSONB rows - POSTGRESQL

Awarded Sep 28 at 9:25

Gregorio Meraz Jr.

311 silver badge6 bronze badges

Primary Key Int vs String [duplicate]

Awarded Sep 28 at 9:25

Nicholas Hamilton

1111 silver badge3 bronze badges

How to startup the Oracle Database 19c without using parameter pfile?

Awarded Sep 28 at 7:36

Clickmit Wg

1031 silver badge3 bronze badges

slow select query on datetime column

Awarded Sep 28 at 4:18

indago

5154 gold badges12 silver badges23 bronze badges

Do valid to/from columns on a fact table make sense?

Awarded Sep 28 at 3:09

Matt

1,0439 silver badges20 bronze badges

What is best for a primary key? Bigint of 20 numbers or varchar / varbinary of 15 characters? [duplicate]

Awarded Sep 28 at 2:37

Fernando VR

1331 silver badge4 bronze badges

How do you use SOURCE in a MySQL query?

Awarded Sep 27 at 23:57

Jason210

1211 silver badge3 bronze badges

What is SYSRAC SESSION?

Awarded Sep 27 at 19:40

Potter

5502 gold badges14 silver badges41 bronze badges

Is it possible to never run vacuum full in PostgreSQL

Awarded Sep 27 at 19:06

Dolphin

7053 gold badges18 silver badges31 bronze badges

SQL Server Transactional Replication delay [closed]

Awarded Sep 27 at 18:28

SQLPRODDBA

1,8982 gold badges31 silver badges47 bronze badges

Postgres 12 JSONB key selection with array value

Awarded Sep 27 at 18:08

B-M

1551 silver badge8 bronze badges

PostgreSQL: Query DB for rows containing integer[] > or < than specified value

Awarded Sep 27 at 15:32

Joshua Burns

6151 gold badge7 silver badges11 bronze badges

Stored Procedure on a read-only AlwaysOn Availability Group replica

Awarded Sep 27 at 13:47

SQL_NoExpert

1,0211 gold badge15 silver badges34 bronze badges

MS SQL Server Copy Database Wizard vs Backup / Restore Script

Awarded Sep 27 at 13:17

senel34

31 silver badge2 bronze badges

SQL Server Deadlock between two selects and one update on one table

Awarded Sep 27 at 13:09

final

3152 silver badges10 bronze badges

Large Table Times out - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Awarded Sep 27 at 0:01

SamoanProgrammer

1011 silver badge2 bronze badges

Oracle: REGEXP_LIKE: Strings with angle brackets aren't found (whether they are escaped or not)

Awarded Sep 26 at 22:56

John

1994 silver badges7 bronze badges

Busy table is not getting vacuumed

Awarded Sep 26 at 20:05

Barry

2232 silver badges6 bronze badges

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); not working

Awarded Sep 26 at 17:41

Roy Hinkley

4492 gold badges8 silver badges14 bronze badges

update column based on sum of data from another table

Awarded Sep 26 at 17:16

Mehdi Boussarhane

1031 silver badge2 bronze badges

SQL Cannot patch the latest CU4 for SQL 2014 SP3

Awarded Sep 26 at 16:40

DBALUKE HUANG

4295 silver badges17 bronze badges

SQL Query with ODBC, Joins and Group Bys

Awarded Sep 26 at 15:18

KNG

311 silver badge2 bronze badges

SQL Sever Alwayson - Increase the WSFC failover threshold

Awarded Sep 26 at 14:56

TheDataGuy

1,9005 gold badges32 silver badges64 bronze badges

HIVE + understanding the hive-metastore logs

Awarded Sep 26 at 14:56

King David

1111 silver badge4 bronze badges

Listener IP not changing after failover

Awarded Sep 26 at 14:56

SQL_NoExpert

1,0211 gold badge15 silver badges34 bronze badges

Synonyms and transactions

Awarded Sep 26 at 14:56

RaoulRubin

9692 gold badges10 silver badges12 bronze badges

How to insert into temp table on Server A results from dynamic SQL open query stored proc call to remote server B via Remote Query showplan operator?

Awarded Sep 26 at 13:35

J.D.

34k8 gold badges48 silver badges109 bronze badges

Looping through JSON and insert data to Postgres DB

Awarded Sep 26 at 11:42

Itzblend

381 silver badge6 bronze badges

Error while opening SQL worksheet in SQL Developer

Awarded Sep 26 at 11:42

Bibhuti Bhusan Padhi

3371 gold badge4 silver badges15 bronze badges

Best way to divide CPU along all sql instances on 1 server

Awarded Sep 26 at 11:21

e90fleet

572 silver badges5 bronze badges

How to update table records in reverse order?

Awarded Sep 26 at 10:50

TAHER El Mehdi

3022 silver badges8 bronze badges

Postgresql return results of dynamic SQL

Awarded Sep 26 at 4:58

Jacob

352 silver badges6 bronze badges

Is it possible to bulk insert using CTE in MySQL?

Awarded Sep 26 at 4:25

Søren Pedersen

1031 silver badge3 bronze badges

Why are there no "Daylight Time" time zones in SQL Server?

Awarded Sep 25 at 22:25

Jer

1411 silver badge4 bronze badges

Getting error USE statement is not supported to switch between databases with Azure Synapse formerly SQLDW

Awarded Sep 25 at 19:57

Carltonp

1011 silver badge1 bronze badge

Repeat row in the result based on the value of a column

Awarded Sep 25 at 19:06

sakthivel

291 silver badge3 bronze badges

2 3 4 5

…

414 Next