Skip to main content
Database Administrators

Explore our questions

Ask Question
more tags
Active Hot Week Month
0 votes
1 answer
152 views

How to efficiently clone database records together with all child elements

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
34 views

When querying for recently run queries, can I group them by some connection identifier?

Alberto Morillo's user avatar
Alberto Morillo
  • 1,867
0 votes
1 answer
793 views

Restore backup global using pgadmin

Community's user avatar
CommunityBot
  • 1
2 votes
2 answers
2k views

MariaDB 11.2 using too much RAM

Community's user avatar
CommunityBot
  • 1
0 votes
2 answers
169 views

mysql query performance... got to be a better way

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
15 views

Does DBCC CHECKDB on a secondary replica prevent ghost cleanup on the primary Availability Group replica?

Sean Gallardy's user avatar
Sean Gallardy
  • 39.4k
1 vote
1 answer
183 views

Potentially Improper Row Count Read in Parallel Bitmap Hash Match Plan

Erik Darling's user avatar
Erik Darling
  • 46.6k
7 votes
1 answer
768 views

Two servers, different execution plans. Several orders of magnitude difference in run time

Erik Darling's user avatar
Erik Darling
  • 46.6k
4 votes
1 answer
599 views

Is it best practice to use surrogate keys when creating foreign key constraints in SQL Server?

Erik Darling's user avatar
Erik Darling
  • 46.6k
1 vote
3 answers
512 views

Clustered Primary Key that is never used vs. Non-Clustered Primary Key on Multiple Columns

Erik Darling's user avatar
Erik Darling
  • 46.6k
0 votes
2 answers
435 views

Different lock types on source table when I change method of inserting data?

Erik Darling's user avatar
Erik Darling
  • 46.6k
6 votes
2 answers
274 views

Why do we have Top N Sort in this example?

Erik Darling's user avatar
Erik Darling
  • 46.6k
0 votes
1 answer
62 views

Why when I JOIN to a casted field in an index view, the execution plan warns about "type conversion in expression"?

Erik Darling's user avatar
Erik Darling
  • 46.6k
0 votes
2 answers
4k views

How can I design address table?

Community's user avatar
CommunityBot
  • 1
Browse more Questions