Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

Sign up to join this community
Anybody can ask a question
Anybody can answer
The best answers are voted up and rise to the top

Top Questions

4 votes
3 answers
859 views

How to recover from a SQL server log file drive crash?

5 votes
1 answer
273 views

Minimise duration of table lock

2 votes
2 answers
175 views

Non-clustered Primary Key and Clustered Index

4 votes
2 answers
55 views

Are enums still evil (in MySQL 8.0)?

0 votes
3 answers
73 views

Using Boolean Fields in a View to Identify Linked Tables

2 votes
1 answer
55 views

Is an SSL Certificate Authority Chain "Secret"

-1 votes
2 answers
37 views

How does the read committed snapshot isolation level relate (link) the row in tempdb to the original row?

-2 votes
1 answer
28 views

How to estimate cpu based on peak rate of query requests?

1 vote
2 answers
41 views

Temporarily turn on Cascade Delete

0 votes
1 answer
48 views

Is there a deterministic relation between the page life expectancy and disk IO throughput?

1 vote
1 answer
44 views

Unlike FCI, doesn't AG make use of heartbeat to check for server down?

-2 votes
1 answer
43 views

What is recommended approach for fixing corruption related errors?

-1 votes
1 answer
40 views

What is the reasoning behind allocating the OS 1GB for each 4GB of RAM?

0 votes
1 answer
39 views

How to incrementally optimize a `COUNT(*) ... GROUPBY` query in PostgreSQL?

1 vote
1 answer
44 views

MySQL information.schema.tables shows create_time later than update_time?

3 votes
2 answers
34 views

Inconsistent data when combining (LEFT) JOIN with SELECT FOR UPDATE

0 votes
0 answers
52 views

sp_BlitzFirst - SQL Server - slow data reads - huge wait stats

-3 votes
1 answer
51 views

Does max SQL memory include SQL AG memory requirements?

1 vote
1 answer
30 views

Junction table or denormalize?

1 vote
1 answer
36 views

Sql Server Large amount of unused database users and logins

0 votes
1 answer
45 views

How to figure out which procedure or function is causing the most logical reads on a particular table?

1 vote
0 answers
45 views

Database becoming unresponsive after time (4 to 24 hours)

1 vote
1 answer
35 views

How to deal with invoices that reference products that don't exist any more?

-1 votes
0 answers
44 views

Could not find an entry for table or index with partition ID in SQL

0 votes
1 answer
34 views

How is the size of the buffer pool (data cache) calculated?

0 votes
1 answer
25 views

How does SQL server handle the password change of the service account?

1 vote
1 answer
41 views

Inconsistent results with MySQL, query never ends on MariaDB

-3 votes
0 answers
41 views

SQL Server differential backups too much slow and big

-2 votes
1 answer
19 views

Does tempdb recommended count depend on the total processors on the computer or on the processors in a single NUMA node?

0 votes
2 answers
40 views

Can't identify which server is primary and which is secondary in a SQL Server Availability group

0 votes
1 answer
24 views

Remove third coordinate from string

2 votes
1 answer
24 views

"column new.total does not exist" error while creating a trigger

2 votes
2 answers
38 views

Rotate passwords with zero down time

0 votes
0 answers
37 views

How to Force Drop a Database that is in Emergency Mode and corrupt?

1 vote
1 answer
22 views

Is there a way to see which tables contribute most to WAL size?

0 votes
0 answers
35 views

Resource consuming query

1 vote
1 answer
27 views

Get the difference for a column value by all its previous rows data

1 vote
2 answers
27 views

Could MySQL perform better on a 10GB network storage with raid vs local HDD?

1 vote
1 answer
27 views

Is it possible to reference an inserted column within the same INSERT?

-1 votes
0 answers
34 views

Does restart in FCI/AG mean node restart or sql server cluster aware services restart?

0 votes
1 answer
34 views

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

2 votes
0 answers
33 views

Postgresql 14 Performance regression versus PG13

0 votes
2 answers
33 views

how to execute mysql queries concurrently/parallelly

0 votes
0 answers
33 views

database structure for many to many to many relationships

2 votes
0 answers
33 views

How to get the specific queries that are contributing to high lock wait times?

0 votes
1 answer
33 views

Fuzzy searching through multiple fields in postgreSQL


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