Database Administrators

database professionals who wish to improve their database skills and learn from others in the community
Solved Questions
Unsolved Questions
  1. mySQL trigger to prevent insert won't work

  2. SQL MDX Average query issue

  3. Posting JSON data a formatting issue?

  4. Diagnosing high write throughput on RDS Postgres

  5. Update stats w/full scan on SQL Server 2014 uses 100% cpu, on SQL Server 2008R2 15%, thoughts?

  6. Joining multiple subqueries

  7. Backing up Master-Master replicated MySQL databases

  8. Problem with only_full_group_by

  9. 'Can't create thread to handle new connection' on RDS

  10. Store and search leveled categories with mysql json

  11. MySQL Query/Connect to eximstats?

  12. MySQL taking significantly longer to query via PHP than CLI
  13. Missing Oracle Schema in SSMA Object Explorer

  14. Can I use a rule to insert aggregate data into a new table?

  15. Access denied to user 'root'@'localhost'
  16. How can I remove a channel from replication slave?
  17. Kafka Partitions vs Mongo Sharding which one is better throughput
  18. Error Code: 1109. Unknown table 'revers' in field list
  19. What are minimum configurations for mongodb replica set though a java program
  20. Does SQL Server support GREATEST and LEAST, if not what is the common workaround?

  21. Why does `row_to_json(...)` accept a sub-query?
  22. Single slave for multiple masters in AWS AuroraDB
  23. Aurora Postgres method to exclude one instance from reader endpoint?

  24. deadlock in mariadb: with non-index & fk table

  25. Optimize index on a 2,135,044,521 row table

  26. How to group records by a two-value column ignoring small gaps?

  27. Analyzing SQL Server query plan

  28. Move large mysql table data from one server to another

  29. What do I need to restore an encrypted MSSQL database?

  30. What is the correct statement in order to prevent inserting duplicate value into MYSQL database

  31. ORA-01031: insufficient privileges while connecting with sys as sysdba

  32. When should a primary key be meaningful?

  33. how to resolve innodb cluster conflict

  34. Finding out the exact size of the database after inserting records?

  35. MySQL Semi-synchronous replication with Multi-Master

  36. Quantity of entries

  37. MSSQL - GRANT EXECUTE permission inside stored procedure

  38. To Normalize or Not to Normalize
  39. Every batch causes a compile
  40. Condition in WHERE vs condition in CONNECT BY

  41. What are the side effects of changing MySQL `character_set_server`?

  42. Compare 2 databases and get the renamed objects

  43. Query to retrieve index details for a particular column in all tables
  44. Synchronisation of multiple databases with GUID type

  45. MySQL killed query with status "copying to tmp table"

  46. PHP / MYSQL connection failures via socket under moderate load
  47. SELECT COUNT(*) returning incorrect results
  48. do MYSQL views occupy physical space?

  49. Oracle file permissions expdp vs dbms_datapump

  50. Help restoring a mongodump 3.4 backup into a different instance
  51. What type of rows does `SELECT my_table FROM my_table` return?
  52. T-SQL - AOAG Health state Healthy or Not Healthy in a Single row

  53. MySQL stored procedure updates twice

  54. SQL Deadlock on the same exclusively locked clustered Key (with NHibernate) on delete / insert
  55. MS Access M:N Relationship query: exclude records with more than the requested values

  56. Linking MS Access 2010 to Outlook Inbox: Including Attachments
  57. A good use case for Postgres Schemas?
  58. How to optimize a Full Text Search

  59. connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host
  60. MySQL slave server getting stopped after each replication request from Master
  61. Oracle 12c - Minimal memory configuration

  62. iSeries / DB2 Declare DATETIME Variable

  63. Once daily AWS Postgres CPU spike caused by mysterious "OS processes"

  64. "Temporary file write failure" when trying to change primary key in MySQL

  65. Syncing data from primary member to secondary after election
  66. MongoDB 3.6 - Journal files are not getting cleaned up and they keep building everyday and use up a lot of disk space
  67. How can I dump a set of tables with including where data time clause?

  68. In point of view concept normalization is it allowed referenced a foreign from another foreign key?

  69. postgresql 10 for Ubuntu 17.10 artful?
  70. Schema design for user activity logging

  71. What is a “transition table" in Postgres?

  72. postgresql column referencing issue
  73. How do I extract text from string between underscores with mysql?

  74. Indexed view doesn't exist on the subscriber

  75. Select Record With Higher Value

  76. Small query on shared view takes a long time when someone else is running a big query on the same view

  77. Botched migration from 9.4 to 9.5 and I'm not sure how to fix it

  78. MariaDB Fails to log in error log

  79. Two versions of Postgres installed, how do I clean this up?
  80. Reorder data in one column based on data in another column

  81. How do I change the default external text editor in psql?
  82. Question about "RMAN-06169:" and Oracle

  83. separate databases for simplicity
  84. Performance in a single SQL Server 2014 database is slower than the rest

  85. DB2 big strange problem - database is returned to CIRCULAR mode but archive logs keep coming to old archive location
  86. Always ON synchronization issue

  87. After moving the shards, database is very slow

  88. SQL Server fulltext / freetexttable
  89. Security implications of running SSRS and an OLTP database on the same server
  90. Internal Stored Procedure Failure - ID_TransUserActionCreate

  91. Linked Server interoperability across different server versions

  92. Extended Events: Specify Session Data Storage left blank
  93. SQL Server system views VERY slow at one computer

  94. How do I synchronize parallel imports with COPY?
  95. Bidirectional realtime synchronization between Oracle and SQL Server tables
  96. Clustered index update, how changing the index only at different column value?

  97. How to load balance mongodb replica cluster

  98. Git as distributed and decentralized storrage with regard to ACID and CAP

  99. Mongodb Not Restarting with Collections, WiredTiger.wt may be corrupt
  100. Consistency in ACID and CAP theorem, are they the same?