2022 Developer Survey is open! Take survey.

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

15 votes
5 answers
3k views

Can ransomware embed itself in to a SQL backup file?

12 votes
2 answers
2k views

Should I call my UUID primary key column ID or not?

7 votes
3 answers
2k views

What does SQL server do with the query output once it is read by the client?

5 votes
5 answers
1k views

Optimize MYSQL Select query in large table

6 votes
2 answers
513 views

DateTime2 and Page Life Expectancy (PLE)

4 votes
3 answers
863 views

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

1 vote
3 answers
515 views

Can setting max dop = number of cpu's cause situation where a single query blocks other queries?

5 votes
1 answer
452 views

Sort order with numbers as strings

6 votes
1 answer
792 views

Do datatypes of columns affect query performance?

2 votes
2 answers
294 views

how to find out the `Key Lookups` in the current query plan?

3 votes
4 answers
462 views

The term Database Migration

-2 votes
1 answer
291 views

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

3 votes
2 answers
359 views

Can I write a FULL OUTER JOIN without OR IS NULL?

5 votes
1 answer
281 views

Minimise duration of table lock

3 votes
2 answers
318 views

In SQL Server / Azure SQL is there a way to see the locks a query produced or wants to produce?

2 votes
2 answers
237 views

how can I convert this SQL statement with nested IN clauses to a JOIN format

2 votes
1 answer
285 views

Trying to get a large amount of data (column type is "text") from an MS SQL Server

2 votes
1 answer
203 views

SQL Server timeout on DB and into connection string

2 votes
1 answer
175 views

PostgreSQL crash due to lack of device space

3 votes
2 answers
79 views

Does selecting data from heap (table without clustered index) with nolock block writers?

2 votes
2 answers
197 views

jsonb_array_elements() fails with "ERROR: cannot extract elements from an object"

2 votes
2 answers
180 views

Non-clustered Primary Key and Clustered Index

2 votes
1 answer
230 views

SQL Server: Is it worth checking for change in a field before the update?

0 votes
1 answer
76 views

How to decrypt zipped data in MSSQL table

4 votes
1 answer
97 views

Execution plan with a lot of ComputeScalar operations

4 votes
2 answers
58 views

Are enums still evil (in MySQL 8.0)?

-1 votes
2 answers
41 views

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

2 votes
1 answer
134 views

Azure SQL Database - contained users password

3 votes
3 answers
75 views

Why is total and target server memory never reaching the configured memory value?

0 votes
2 answers
115 views

help with improve query

1 vote
3 answers
53 views

slow mysql query need help

-1 votes
2 answers
51 views

Why does MAXDOP = 0 result in high CXPACKET wait time?

1 vote
2 answers
50 views

Temporarily turn on Cascade Delete

2 votes
1 answer
57 views

Is an SSL Certificate Authority Chain "Secret"

0 votes
3 answers
73 views

Using Boolean Fields in a View to Identify Linked Tables

3 votes
1 answer
91 views

Is it safe to use default value with not null when adding a new column?

-3 votes
2 answers
62 views

Is the master db aware of user dbs?

-1 votes
2 answers
37 views

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

0 votes
4 answers
77 views

Foreign key location

1 vote
2 answers
58 views

Bypassing LCK_M_SCH_S lock when requesting partition information

0 votes
3 answers
45 views

How does FCI guarantee data consistency and integrity?

3 votes
2 answers
69 views

How to Join two tables with SUM and GROUP BY in SQL server

3 votes
1 answer
67 views

Change the definition of an Index with Expression without dropping/recreating the index

-2 votes
2 answers
85 views

SQL Server 2017 transaction log does not shrink logfile after rebuild index [closed]

1 vote
1 answer
51 views

Why does `Is Clustered` show as No for a AG SQL Node?

0 votes
1 answer
78 views

What is the num of NUMA nodes for MAXDOP calculation when there is discrepancy between various ways to count the NUMA nodes?

2 votes
3 answers
47 views

Generate JSON with property names that include dot using SELECT FOR JSON

0 votes
3 answers
46 views

What does 0 memory grants pending, but low PLE, high lazy writes/sec and free list stalls/sec indicate?


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