Database Administrators

database professionals who wish to improve their database skills and learn from others in the community
Solved Questions
Unsolved Questions
  1. PDO Select all tables who are beginning with a prefix

  2. Is there a standard implementation of a Users Database?

  3. Netezza SQL - Where in the Logical Order Are Computed Columns Calculated?

  4. How to combine these two queries and have them be as fast?

  5. Sql server bulk insert remove text qualifier

  6. MySQL NDB Cluster architecture?
  7. Can I extend SQL Server with C++ or C?

  8. Why does sqlcmd truncate varbinary(max)?
  9. Can I get shell access through SQL Server 2017 on Linux?

  10. Unable to connect to pluggable database using TNS but EZCONNECT is OK
  11. macOS homebrew: database system was not properly shut down; automatic recovery in progress
  12. Why does CAST(1 AS SIGNED INTEGER) return a BIGINT on MySQL?
  13. How do I log into the Dedicated Admin Console (DAC) on Linux?
  14. dumping the database from Linux to Windows in Mysql

  15. Can't restart or stop Firebird 1.5 on linux

  16. Access view based on table in another database without account in that other database

  17. Iterating through a record set and selecting certain records

  18. SQL Server clears plan cache and execution stats periodically

  19. Access denied for user 'root'@'localhost' (using password: NO) on 'service mysql start'

  20. Concurrent UPDATE deadlock (updating 2 fields, selecting by PK)

  21. Grouping Sessions using a DATETIME stamp which can Span across a DAY

  22. MySQL Load Data Infile extremely slow
  23. Blank space In Rolls and Columns

  24. Multiple databases, one backup file

  25. Are My Tables Correct and How do I Solve the Validations?

  26. Reduce a huge number of possibilites to something manageable?
  27. Import all csv files into a table oracle

  28. The ER diagram is complying with the context rules?

  29. Select Permissions Across Multiple Schemas Within the Same Database
  30. Mysql replication, error 13 (permission denied) with slave_load_tmpdir

  31. Query doesn't end if limit is not added - AWS RDS MariaDB

  32. Update records that match like regex from another table

  33. Lookup performance of Numeric vs String
  34. I keep getting an error 10060 trying to connect object explorer in Visual Studio 2013 to an Azure Database

  35. If MAX(id) != COUNT(id), does that mean rows have been deleted?

  36. Convert rfc822 to either a GMT DATETIME or Unix timestamp in SQL Server
  37. T-SQL MINUS operator

  38. Help with removing duplicate reversed pairs in relational algebra

  39. Looking for simple contains method when searching text in postgresql
  40. How to fetch the started on date when a price is changed (price is not incremental)

  41. Slow Linked Server INSERTs on SQL Server 2014

  42. How to create a conditional index in MySQL?

  43. How do I know what requires DAC?

  44. Creating my own database

  45. How to load textfiles into SQL Server Database?
  46. want to import exported xml file in wamp phpmyadmin

  47. SQL Server 2008 R2 DB grows overnight and slow

  48. Clients timing out with no apparent reason

  49. Is it possible to estabilish Dedicated Administrator Connection (DAC) using SSMS?
  50. DAC connection error

  51. No DAC connection could be established on the default port. Make sure DAC is enabled

  52. Why am I getting "Invalid object name 'sys.sysobjvalues'."

  53. Error on re-import: #1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

  54. Simulate pipelined order by in oracle 11g
  55. Check Oracle Service is Started from Batch Command

  56. Mysql 5.7 not starting automatically on server reboot

  57. Automysqlbackup fix error "Skipping the data of table mysql.event. Specify the --events option explicitly"

  58. Upgrading SQL Server with Integration Services

  59. Sample Sybase ASE 15.0.3 database
  60. Following mysql query is taking too much time for excecution

  61. MongoDB instance for production
  62. Postgres 10 shutting down on installation in Ubuntu 14

  63. Cannot Delete FileStream Group from Sql Server 2008
  64. MySQL replication slave hangs after encountering SET @@SESSION.GTID_NEXT= 'ANONYMOUS';

  65. ERROR 2003 (HY000): Can't connect to MySQL server on '' (10060)
  66. Performance of XML to Table Function in Stored Procedures

  67. SQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog file

  68. Postgres backup and WAL to S3

  69. MySQL Slave missing table

  70. What differences are there with SQL Server 2017's packaging of `Binn` on Linux and Windows?
  71. Oracle high Paging Faults
  72. How to compact the current MS Access database from VBA function
  73. Database anonymization and security

  74. Cross Cluster Migration 2012 to 2016
  75. SHOW CREATE PROCEDURE procedure_name not showing the procedure content
  76. How to connect to remote MySQL from a specific IP?

  77. Counting show variable result in mysql

  78. Cannot start XAMPP MySQL InnoDB

  79. How get list of items in one column if satisfy condition in other column

  80. MySQL – BLObs Hitting Performance
  81. Capitalize first letter with exceptions
  82. MySQL server: Unable to connect with root because of skip-name-resolve option
  83. Feature of database-level audit in SQL Server 2012 Express edition

  84. How can I query matching MongoDB documents and return a subset of fields from an array of embedded documents?

  85. mariadb (mysql) innodb not optimizing SELECT for partitions?
  86. Find most frequent values for a given column

  87. Does CREATE/DROP VIEW require a SCH-M Lock

  88. SQL Server Buffer Pool Extension in FullText Index Population

  89. table type parameter vs temp table vs table variable
  90. What are minimum configurations for mongodb replica set though a java program

  91. SQL AlwaysOn & System Center Configuration Manager TP 4 1601
  92. Approaches for handling nvarchar sources to data warehouse
  93. Linked server to Oracle doesn't use filters. Are there any performance changes in different versions of SQL Server?
  94. pgAgent doesn't run on another database than "postgres"

  95. Representing Aggregation of entities in Erwin data modeler

  96. Common TVF in SQL server to get results from differnt schema
  97. SQL Server - How is a row updated under the hood?

  98. trend analysis database schema

  99. PostgreSQL: Foreign key on string column

  100. Is it a good practice to build in as many foreign keys as possible?