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
Database Administrators

Top Questions

Ask Question
Active Hot Week Month
4 votes
4 answers
2k views

What's the order of operations in PostgreSQL?

Laurenz Albe's user avatar
Laurenz Albe
  • 47.8k
4 votes
5 answers
1k views

What are the idiomatic approaches to copying a table (and all of its data) from one server to another?

J. Mini's user avatar
J. Mini
  • 93
3 votes
1 answer
1k views

How can I determine if Oracle is installed on Microsoft Windows or Unix using SQL?

Peter Mortensen's user avatar
Peter Mortensen
  • 349
2 votes
1 answer
656 views

What's the difference between FETCH FIRST and FETCH NEXT in PostgreSQL?

Daniel Vérité's user avatar
Daniel Vérité
  • 30.8k
2 votes
2 answers
812 views

Do database connections get automatically reconnected if a database is restored?

Phill W.'s user avatar
Phill W.
  • 8,259
4 votes
1 answer
512 views

SQL Server memory requirements

Sean Gallardy's user avatar
Sean Gallardy
  • 29.9k
3 votes
1 answer
275 views

Are there any possibilties to mitigate data loss risk on delayed durability

Hannah Vernon's user avatar
Hannah Vernon♦
  • 69.7k
2 votes
2 answers
186 views

Why are these columns specified in the include clause of an index rather than as key columns

Erik Darling's user avatar
Erik Darling
  • 38.7k
0 votes
3 answers
111 views

Why sql server prefer index scan over the seek?

KumarHarsh's user avatar
KumarHarsh
  • 1,613
1 vote
4 answers
180 views

Query optimization question

philipxy's user avatar
philipxy
  • 754
3 votes
1 answer
226 views

Catch Block Inside of a Trigger Does Not Get Hit When a SP With Dynamic SQL Errors Out - Causing the Larger Transaction to Fail

David Browne - Microsoft's user avatar
David Browne - Microsoft
  • 45.9k
4 votes
2 answers
151 views

How can SQL Server's Query Store Reports show data for minute-length intervals, when "Statistics Collection Interval" is set to 1 hour?

Matthias L's user avatar
Matthias L
  • 83
3 votes
2 answers
127 views

How to sum up the distinct Total Time of an Event ignoring duplicate overlaps in Times?

Caleb Carl's user avatar
Caleb Carl
  • 301
0 votes
1 answer
395 views

how can I view deleted records in an ibd file?

Rick James's user avatar
Rick James
  • 76.9k
2 votes
2 answers
133 views

Understanding the Impact of ORDER BY in Window Functions on other Partitions in PostgreSQL

J.D.'s user avatar
J.D.
  • 35k
0 votes
2 answers
129 views

Convert varchar into datetime and use date diff on the where clause

Caleb Carl's user avatar
Caleb Carl
  • 301
3 votes
1 answer
75 views

Is the WITH (NOLOCK) hint ignored on the non-target tables of an UPDATE or DELETE statement?

Paradox's user avatar
Paradox
  • 155
0 votes
2 answers
105 views

What database to store 20~ billions rows

Paul White's user avatar
Paul White♦
  • 82.9k
0 votes
2 answers
88 views

How Does a Database that Supports TDE Work In Practice?

Paul White's user avatar
Paul White♦
  • 82.9k
-2 votes
2 answers
88 views

I've TABLOCKed a table. How can I read it?

Paul White's user avatar
Paul White♦
  • 82.9k
0 votes
1 answer
89 views

Is WHERE [FOO] IN (SELECT [BAR] FROM [...]) guaranteed to give the same execution plan as the equivalent WHERE EXISTS?

Paul White's user avatar
Paul White♦
  • 82.9k
3 votes
2 answers
86 views

MySQL chooses a slow execution plan for selecting rows by range condition with ORDER BY, LIMIT and OFFSET clauses

Rick James's user avatar
Rick James
  • 76.9k
0 votes
1 answer
51 views

Huge PREEMPTIVE_OS_GETPROCADDRESS Waits From sp_OAMethod. How to debug?

J. Mini's user avatar
J. Mini
  • 93
0 votes
2 answers
101 views

Does the logical query processing change when indexes are involved?

LoztInSpace's user avatar
LoztInSpace
  • 833
2 votes
2 answers
124 views

SQL Server: Trigger with UPDATE statement causes deadlocks

Paul White's user avatar
Paul White♦
  • 82.9k
2 votes
1 answer
57 views

Insert gives error code 1366 even though charset is utf8mb4

Rick James's user avatar
Rick James
  • 76.9k
-1 votes
2 answers
72 views

Extended events query in User Database

Dyllon Gagnier's user avatar
Dyllon Gagnier
  • 31
0 votes
1 answer
54 views

Windows Power Plans for SQL Server

Erik Darling's user avatar
Erik Darling
  • 38.7k
-1 votes
2 answers
54 views

SQL breaking my query where there is NULL value

Paul W's user avatar
Paul W
  • 465
0 votes
2 answers
69 views

formating date colums causing performance issues

J.D.'s user avatar
J.D.
  • 35k
1 vote
1 answer
88 views

Log file auto growth SQL-Server

Sean Gallardy's user avatar
Sean Gallardy
  • 29.9k
0 votes
1 answer
140 views

How can I simplify the process of importing only changed data?

Check12's user avatar
Check12
  • 53
1 vote
2 answers
50 views

How do I get the object that executed the query from a query handle?

Charlieface's user avatar
Charlieface
  • 11.7k
0 votes
2 answers
101 views

How to apply JOIN only if there are rows available

Caleb Carl's user avatar
Caleb Carl
  • 301
1 vote
1 answer
60 views

Questions about the @DatabasesInParallel parameter for the Ola Hallengren Index and Statistics Maintenance scripts?

John K. N.'s user avatar
John K. N.
  • 17.3k
1 vote
1 answer
98 views

What are the idiomatic approaches to cross-server upserts?

J. Mini's user avatar
J. Mini
  • 93
0 votes
2 answers
46 views

Changing Isolation Level after retiring database from active/production use

Charlieface's user avatar
Charlieface
  • 11.7k
2 votes
1 answer
75 views

Should I use this partitioning/indexing strategy for a table that grows by about a billion rows per year?

Ken Schnetz's user avatar
Ken Schnetz
  • 23
-3 votes
1 answer
96 views

How to exclude some column from history table in temporal table

Randolph West's user avatar
Randolph West
  • 3,673
1 vote
2 answers
72 views

View memory usage by database on an SQL server

Aleksey Vitsko's user avatar
Aleksey Vitsko
  • 5,452
0 votes
1 answer
56 views

Managing very large VLF

Erik Darling's user avatar
Erik Darling
  • 38.7k
-1 votes
3 answers
56 views

Should i care about field names in JSON datatypes?

John K. N.'s user avatar
John K. N.
  • 17.3k
0 votes
1 answer
54 views

How to find out when Oracle table statistics became stale?

Paul W's user avatar
Paul W
  • 465
1 vote
1 answer
54 views

potgresql uses only one worker for index creation

jjanes's user avatar
jjanes
  • 38.5k
0 votes
1 answer
54 views

Sql Server Open Transactions

Sean Gallardy's user avatar
Sean Gallardy
  • 29.9k
-2 votes
1 answer
42 views

Why force plan is not working with failure "NO_PLAN"?

Paul White's user avatar
Paul White♦
  • 82.9k
1 vote
1 answer
67 views

Does SQL implementations (or at least SQL Azure) skip obvious duplicate data with joins when returning data?

simon coleman's user avatar
simon coleman
  • 246
1 vote
2 answers
65 views

Why is Postgres so slow to order those 200 rows that are already ordered?

jjanes's user avatar
jjanes
  • 38.5k

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

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.