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

8 votes
2 answers
458 views

MS SQL Server DB Transaction Log Growth Rate

5 votes
3 answers
476 views

Is there a performance penalty when there are two unique indexes on a table with all of the colums in one index are also in the other index?

6 votes
3 answers
707 views

How does this piece of TSQL work?

4 votes
4 answers
333 views

How to update table records in reverse order?

6 votes
1 answer
765 views

How to get a user's password in PostgreSQL?

3 votes
1 answer
215 views

Is this valid SQL Server Update syntax?

5 votes
2 answers
208 views

Advantage of "LOAD DATA ... REPLACE INTO TABLE" over "UPDATE table_name SET"

3 votes
2 answers
91 views

Unique Constraint on 2 columns or single column and null exists

2 votes
1 answer
246 views

How much resources does a sleeping connection require in SQL Server?

3 votes
1 answer
233 views

Postgres: Create unique index with conditional

2 votes
2 answers
156 views

Does large tempdb file size have impact on sql server startup time?

3 votes
1 answer
98 views

Implement foreign key constraint when there are several parent tables

2 votes
2 answers
75 views

Optimizing select count result in Postgresql

3 votes
1 answer
67 views

sys.dm_exec_describe_first_result_set returns wrong data type

2 votes
1 answer
57 views

Install SQL Server 2016 SP2 on SP3 - Windows Updates says that?

0 votes
1 answer
34 views

SQL Server compressed backup firstly huge?

2 votes
3 answers
47 views

How to add a column to a table with populated data? [POSTGRES]

-1 votes
1 answer
29 views

How to work around sp_blitzwho lock timeout?

1 vote
1 answer
36 views

Understanding of database master key in SQL Server

1 vote
1 answer
28 views

How to format a fixed-length number as a binary string?

2 votes
2 answers
44 views

How to order by cumulative value?

0 votes
1 answer
42 views

N-to-many relationship

4 votes
0 answers
69 views
+50

Error with pg_trgm indexes while upgrading postgres on RDS

0 votes
1 answer
30 views

SQL: Single VS multiple join tables

0 votes
1 answer
29 views

PostgreSQL: does the WAL group commit affect synchronous replication performance?

0 votes
1 answer
37 views

How to optimize SQL Server query that might be doing parameter sniffing

2 votes
0 answers
61 views

Postgresql full text search without diacritics (effective unaccent)

-1 votes
0 answers
58 views

SQL Server Stored Procedure performance slows from 30min to 22 hours overnight

-1 votes
1 answer
44 views

SQL Server 2014: Why is Clustered Index Rebuild MUCH faster than initial index creation?

-1 votes
0 answers
56 views

2 almost identical queries (with a TVF) produce wildly different performance!

0 votes
1 answer
43 views

pg_restore error when using the --single-transaction: options c/--clean and -a/--data-only cannot be used together (even so the -a flag was not used)

0 votes
1 answer
52 views

Routinely deleting data from tables using stored procedure

3 votes
1 answer
31 views

Creating a new view or table from the last record

0 votes
1 answer
28 views

How to merge and transform data in Postgres

0 votes
1 answer
28 views

If a table column corresponding to different target columns in different tables, how to join this column in SQL?

0 votes
1 answer
21 views

ON CONFLICT with index column name is a syntax error

0 votes
1 answer
33 views

SQL Server - how to disable case sensitive in my query window?

0 votes
0 answers
41 views

What's the best practices / recommendations for paginating data from different tables?

-1 votes
1 answer
31 views

Does SQL Server support join type "LEFT SEMI JOIN" in your query?

-1 votes
1 answer
31 views

What does `same WSFC cluster can run multiple FCIs (multiple resource groups)` mean?

3 votes
2 answers
31 views

Find duplicated rows between multiple same tables

0 votes
0 answers
39 views

"There is insufficient system memory in resource pool 'default' to run this query" error with MEMORY_OPTIMIZED tables

-1 votes
1 answer
23 views

How to combine multiple rows into one, based on event id, datetime, and an action into their own columns?

-3 votes
1 answer
23 views

Where to download a backup of the stack overflow to use for SQL Server 2019

1 vote
1 answer
29 views

When I use group_concat on two fields, can I count on the two concatenations having the same order?

0 votes
1 answer
22 views

Unable to change password in postgres even though I'm logged in as that user [duplicate]

0 votes
1 answer
27 views

How to configure the listener in a read scale SQL AG post failover?

3 votes
1 answer
34 views

Incorrect database name `` after mysql@8 upgrade


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