Skip to main content
Stack Overflow's 2025 Annual Developer Survey is still open — take the Survey before it closes
Database Administrators

Top Questions

Ask Question
Active 1 Bountied Hot Week Month
1 vote
1 answer
8 views

What are better approaches than loops for frequent operations?

Charlieface's user avatar
Charlieface
  • 16.8k
0 votes
2 answers
217 views

Oracle: Corrupt datafile will not turn back online?

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
217 views

Passing filter params to a sub query

Community's user avatar
CommunityBot
  • 1
1 vote
0 answers
9 views

PG 17.5 pg_ctl output not being logged on Windows Server 2019

sevzas's user avatar
sevzas
  • 313
2 votes
2 answers
453 views

Is it possible to limit the scope of a SYNONYM in SQL Server?

Community's user avatar
CommunityBot
  • 1
-1 votes
0 answers
7 views

Having access to a database that a service user created on RDS

Racer SQL's user avatar
Racer SQL
  • 7,514
1 vote
0 answers
56 views

Is it possible to make a batch of “Alter procedure” that are stored in a table?

Sean Gallardy's user avatar
Sean Gallardy
  • 37.8k
0 votes
0 answers
13 views

MongoDB refineShardKey unbalanced chunks

Pobe's user avatar
Pobe
  • 101
0 votes
1 answer
252 views

MariaDB threads goes around 10K suddenly

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
226 views

Running select filename from dbo.sysfiles returns short foldernames with tilde

Community's user avatar
CommunityBot
  • 1
0 votes
0 answers
14 views

Mysql replica is up and running but I can't see updates on my slave

Rohit Gupta's user avatar
Rohit Gupta
  • 2,024
1 vote
2 answers
228 views

How to work around "row is too big" for role definitions without recreating the database?

Community's user avatar
CommunityBot
  • 1
0 votes
2 answers
22 views

PSQL: passing variables into a select 'create user ... ' subquery

mustaccio's user avatar
mustaccio
  • 27.9k
0 votes
1 answer
4k views

how to efficiently move and compress LOBs in ORACLE?

Community's user avatar
CommunityBot
  • 1
25 votes
6 answers
139k views

MySQL: Return JSON from a standard SQL Query

Константин Прыкин's user avatar
Константин Прыкин
  • 3
1 vote
1 answer
234 views

How to get aggregate data from a dynamic number of related rows in adjacent table

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
219 views

pgAdmin4 version 3.1 how to update to the last version

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
222 views

ignored in stored procedure with clause

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
242 views

Optimizing Cassandra Table Design for Queries Involving Two Partition Keys

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
2k views

Query All Tables In PostgreSQL Database For Text

Community's user avatar
CommunityBot
  • 1
1 vote
2 answers
3k views

Reading SQL Server .sqlaudit Files Stored in S3

Community's user avatar
CommunityBot
  • 1
1 vote
2 answers
245 views

Postgres Foreign Data Wrappers for Data Migration. Do transactions hold across databases?

Community's user avatar
CommunityBot
  • 1
1 vote
1 answer
221 views

mysql data node not connecting to node manager on AWS EC2

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
233 views

Why does the column content say “Array”?

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
225 views

Error "No catalog entry found for partition ID ..."

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
218 views

MySQL database cluster vs. replication setup for large crawler indexes

Community's user avatar
CommunityBot
  • 1
3 votes
1 answer
440 views

Installing Postgresql parray_gin extension on mac, include not found

Community's user avatar
CommunityBot
  • 1
1 vote
2 answers
259 views

Get-SqlAgentJobHistory Invoked By

Community's user avatar
CommunityBot
  • 1
3 votes
0 answers
1k views

Use or include external schema in search_path on Redshift

combinatorist's user avatar
combinatorist
  • 233
2 votes
2 answers
3k views

Processes can not be terminated on Sybase ASE

Community's user avatar
CommunityBot
  • 1
0 votes
0 answers
9 views

How do you add server connections on ubuntu version of pgAdmin?

Biller Builder's user avatar
Biller Builder
  • 286
0 votes
1 answer
1k views

How do I terminate a running SELECT query without restarting MySQL?

Community's user avatar
CommunityBot
  • 1
1 vote
1 answer
747 views

CDC Capture Instance or State to ensure referential integrity

Shooter McGavin's user avatar
Shooter McGavin
  • 886
2 votes
1 answer
1k views

powershell problem when running on a remote server - access is denied

Ricko's user avatar
Ricko
  • 1
0 votes
1 answer
487 views

SQL Server 2016 -number of SQL agent replication jobs(transaction log repl)

Community's user avatar
CommunityBot
  • 1
0 votes
2 answers
228 views

I am unable to install MySQL on any of my Debian servers. How do I get the signature to the repo?

Otto's user avatar
Otto
  • 276
3 votes
1 answer
256 views

What's the reason for too much unused space in a table, but not being able to allocate a new page

siggemannen's user avatar
siggemannen
  • 163
1 vote
1 answer
13 views

Why Maxscale doesn't switch master?

Otto's user avatar
Otto
  • 276
0 votes
1 answer
38 views

SQL Server Extended Events - collecting SP Object_name

Charlieface's user avatar
Charlieface
  • 16.8k
0 votes
1 answer
990 views

Goldengate timestamp (FFF)

Community's user avatar
CommunityBot
  • 1
1 vote
2 answers
3k views

Select Column Values from all the tables of database ORACLE

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
20 views

Mysql ubuntu solution (failover, failback)

Bill Karwin's user avatar
Bill Karwin
  • 16.8k
0 votes
1 answer
22 views

Shrinking log files on AG to manage VLF's

Sean Gallardy's user avatar
Sean Gallardy
  • 37.8k
0 votes
2 answers
24 views

pg_basebackup duration of 500G

Johannes's user avatar
Johannes
  • 1
0 votes
1 answer
746 views

How does different forms of EXISTS() affect performance in MS Sql Server?

Charlieface's user avatar
Charlieface
  • 16.8k
1 vote
1 answer
627 views

Why findOne() hangs on a sharded collection?

Community's user avatar
CommunityBot
  • 1
22 votes
3 answers
35k views

Why not rebuild indexes with page count <1000?

HenrikRClausen's user avatar
HenrikRClausen
  • 1
0 votes
1 answer
264 views

Audit Admin rights use on SQL Server 2019

Community's user avatar
CommunityBot
  • 1

Looking for more? Browse the complete list of questions, or popular tags. Help us answer unanswered questions.

X