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
3 answers
3k views

Does killing an application kill the SQL connection?

15 votes
3 answers
2k views

What's the use case of disabling an index?

4 votes
2 answers
862 views

What is the SQL server mechanism to ensure that the page being restored isn't corrupted?

8 votes
2 answers
458 views

MS SQL Server DB Transaction Log Growth Rate

3 votes
2 answers
516 views

How database engine of SQL swap two columns values?

5 votes
3 answers
489 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
2 answers
548 views

Is pgAdmin adding query time overhead?

2 votes
3 answers
295 views

What is the meaning of scan count in SET STATISTICS IO ON?

6 votes
3 answers
707 views

How does this piece of TSQL work?

9 votes
2 answers
545 views

Why SQL Server scans all rows when updating bit column even for primary key via linked server

3 votes
4 answers
551 views

How to check if WHERE = value does not exist and make it zero by default?

4 votes
4 answers
333 views

How to update table records in reverse order?

5 votes
1 answer
462 views

How does SQL Server update lock work?

6 votes
1 answer
767 views

How to get a user's password in PostgreSQL?

6 votes
1 answer
570 views

IF statement not being evaluated

3 votes
2 answers
416 views

Inserting dummy data into an empty table having a primary key integer field GENERATED ALWAYS AS IDENTITY

4 votes
2 answers
110 views

Are results from UNION ALL clauses always appended in order?

7 votes
1 answer
289 views

Why does an inequality search on an indexed column give constant scans

1 vote
2 answers
327 views

How to optimize Where clause with a billion rows in PostgreSQL?

4 votes
1 answer
219 views

Change Column Data Type from numeric(18, 2) to numeric(22, 6) on a BIG Table

3 votes
1 answer
216 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"

4 votes
1 answer
199 views

Which of those parameters is default in DBCC SHRINKFILE command?

5 votes
1 answer
306 views

Generate sequential numbers on a join

2 votes
2 answers
168 views

Self-referential record, potentially referencing the same row, with a uuid pkey and a not null and foreign key constraint?

5 votes
3 answers
74 views

Select telemetry data based on relational data in PostgreSQL/TimescaleDB

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
171 views

0 and 1 FROM DUAL Matrix

6 votes
1 answer
202 views

What am I missing in my crosstab query here?

2 votes
2 answers
182 views

Join with comma separated values in SQL without direct relation between tables

4 votes
1 answer
140 views

Index on expression (regular expression pattern matching) is not used in query

3 votes
2 answers
87 views

How do I migrate from PropertyFileSnitch to GossipingPropertyFileSnitch in DataStax Enterprise?

0 votes
2 answers
111 views

TSQL Slow Query, not using index as expected

3 votes
1 answer
134 views

Are client-side JOINs preferred in Cassandra?

2 votes
2 answers
156 views

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

2 votes
1 answer
151 views

A way to filter out parseonly statements from extended events?

6 votes
1 answer
146 views

SQL Server generating sporadic Memory Dumps

0 votes
1 answer
90 views

Doesn't T-SQL support correlated CROSS JOINs?

3 votes
1 answer
98 views

Implement foreign key constraint when there are several parent tables

5 votes
1 answer
59 views

Index Design: clustered index using a DATE

2 votes
2 answers
75 views

Optimizing select count result in Postgresql

5 votes
2 answers
94 views

At finding a substring, find the end position as well

0 votes
2 answers
44 views

sp_BlitzCache and encrypted procedure

2 votes
2 answers
143 views

Compare two table and update with endDate

3 votes
1 answer
67 views

sys.dm_exec_describe_first_result_set returns wrong data type

1 vote
1 answer
81 views

Given SQL Server's ability to adjust I/O block sizes based on operation, how does formatting the disk with 64K allocation unit help a read query?


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