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

10 votes
1 answer
720 views

If you disable a non-clustered index, are the statistics still used?

3 votes
2 answers
232 views

Tuning Postgresql for writing of a non-critical DB

5 votes
1 answer
378 views

Compare a credential secret against a known value

3 votes
2 answers
225 views

indexing multiple columns in a table in MySQL

3 votes
2 answers
231 views

Differences in PostgreSQL 14 collation behavior on Linux and Mac

3 votes
2 answers
133 views

MySQL 8 - Access denied when dropping procedures

2 votes
1 answer
123 views

How do I get the date next week in SQL (Firebird)?

2 votes
3 answers
156 views

Join twice on same table with different conditions and no PK / FK relations

2 votes
1 answer
146 views

Creating indexes in an amazon aws aurora mysql does have a cost?

1 vote
2 answers
53 views

How does SQL Server handle data during backup operations?

-2 votes
1 answer
74 views

What is the correct way to check and delete temp table?

2 votes
1 answer
88 views

Different query result in SQL Server high availability group's nodes

0 votes
2 answers
41 views

Try Catch w/Transaction and executing stored procedures

1 vote
1 answer
51 views

Query for MAX/MIN of non-clustered index field for partitioned table

0 votes
2 answers
44 views

Set up PL/SQL Developer

2 votes
2 answers
66 views

Why does Cassandra lose data when there is an outage on one node with RF=2?

0 votes
1 answer
50 views

Why query takes ages when I filter by an indexed boolean column?

2 votes
1 answer
52 views

SQL Server JOIN vs sparse table

0 votes
1 answer
39 views

How to update ALL folder locations after server upgrade?

3 votes
0 answers
80 views

Why does my query take a long time to run, and why does changing the order of the joins make it quicker?

0 votes
1 answer
31 views

Convert an Int column to BigInt in a stored procedure in SQL Server 2012

0 votes
1 answer
36 views

Zero time when previous row = Parked

1 vote
2 answers
46 views

Using binlog format row, is there any possibility to omit the statement text itself, and only having the binary part?

0 votes
1 answer
34 views

How to Insert Select from last table auto increment Id

0 votes
1 answer
33 views

is Max() not counted as a aggregation function?

-1 votes
2 answers
40 views

Unable To Execute restore Operation

1 vote
0 answers
50 views

Is my food-tracker's database designed properly? (ER diagram + SQL Relations)

1 vote
1 answer
38 views

Get table data not in pivot table

1 vote
1 answer
38 views

Is there a way to monitor which data items are queried in SQL Server?

0 votes
1 answer
48 views

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

0 votes
1 answer
48 views

Different performance of SQL Server instances on same server

1 vote
1 answer
48 views

Same primary key for multiple tables vs separate primary keys

0 votes
1 answer
37 views

how to create an auto-increment column with a prefix in Adminer with MySQL

-1 votes
0 answers
47 views

SQL Server has encountered 3449 occurrence(s) of I/O requests taking longer than 15 seconds to complete [duplicate]

0 votes
1 answer
22 views

Merge rows values if the FK is same

0 votes
1 answer
27 views

Oracle Database - Can I create a table and reserve some space for it?

1 vote
1 answer
33 views

ORA-04091 table is mutating trigger/function may not see it when cascading, works otherwise

0 votes
0 answers
42 views

Verify the syntax of a 20GB SQL text file through a command line tool

0 votes
1 answer
32 views

Where is Oracle TNS redirection configured?

1 vote
0 answers
41 views

Restart a Running Sum after Static Threshold

2 votes
1 answer
28 views

SYSCTRL like role in PostgreSQL

3 votes
1 answer
28 views

Calculate user availability base on schedule table

2 votes
1 answer
27 views

Drop privileges for the current connection in MSSQL

0 votes
1 answer
27 views

How to remove remaining traces of a detached database from a server?

1 vote
0 answers
33 views

Update fails on linked server after upgrading to SQL Server 2022

1 vote
1 answer
25 views

Optimize querying 100 million records- Postgres - indexes

0 votes
1 answer
32 views

making query more efficient when there is a millions of row

2 votes
1 answer
19 views

How to get the most recent result sets when grouping key and date are in separate tables


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