Database Administrators

Promoter

 Promoter
First bounty you offer on your own question.
Awarded 826 times.
MariaDB starts from cmd prompt but not as service
Awarded Feb 19, 2021 at 16:56
Execution plan changed for existing query - high CPU usage
Awarded Feb 18, 2021 at 9:18
Many to Many - Concept
Awarded Feb 17, 2021 at 13:06
Configure Connection String to Use Target Machine Credentials
Awarded Feb 12, 2021 at 13:55
Storing data for machine learning in MySQL
Awarded Feb 11, 2021 at 10:10
Can't restore master/slave replication from Percona backup (slave server)
Awarded Feb 10, 2021 at 13:35
Could not receive data from WAL stream: ERROR: requested WAL segment has already been removed
Awarded Jan 31, 2021 at 5:41
Server quit without updating PID file when trying to start MySQL server?
Awarded Jan 28, 2021 at 21:55
Create cyclic pointers in postgresql 9.5
Awarded Jan 9, 2021 at 21:11
How do I measure the overhead of a Postgres extended statistics object?
Awarded Jan 6, 2021 at 19:16
What could explain a 30 second MySQL SELECT query latency when profiling records an execution time of <1 second?
Awarded Dec 30, 2020 at 21:35
Find filtered indexes on an Oracle table
Awarded Dec 28, 2020 at 17:57
Missing mysql, sys, performance_schema
Awarded Dec 19, 2020 at 19:25
innodb_autoinc_lock_mode = 2, real danger if not using AUTO_INCREMENT columns
Awarded Dec 7, 2020 at 15:55
Multi-insert batch executed remotely 5x slower than locally
Awarded Dec 3, 2020 at 17:10
What type of locks are needed when creating a Postgres index concurrently?
Awarded Nov 29, 2020 at 22:36
Postgresql Database leaking t99_8989898 files in db directory or db size is showing incorrect in postgres
Awarded Nov 24, 2020 at 5:34
Demystification of SQL Server optimization process [duplicate]
Awarded Nov 22, 2020 at 18:20
Oracle Procedure alter pivoted data to unpivot and push into different destination
Awarded Nov 13, 2020 at 10:08
How trigger update in replica database on Postgres?
Awarded Nov 10, 2020 at 5:28
Does binlog_group_commit_sync_delay affect existing binary logging in MySQL
Awarded Oct 28, 2020 at 7:57
InfluxDB with Zabbix or Telefraf?
Awarded Oct 27, 2020 at 13:40
Reduce file header block
Awarded Oct 14, 2020 at 7:12
SQL query for FIFO allocation of items
Awarded Oct 12, 2020 at 7:26
How to efficiently recompute the data in a rather large X table?
Awarded Sep 30, 2020 at 8:17
is there a DDL generator out there where you can start with CSV/TSV to create DDL for Cassandra
Awarded Sep 19, 2020 at 18:32
Backend on server keeps getting into an inconsistent state
Awarded Sep 16, 2020 at 18:56
How to turn on the expanded mode in Oracle SQL*Plus?
Awarded Sep 15, 2020 at 13:12
CREATE VIEW WITH LEFT JOIN - FILTER RIGHT DEPENDING ON LEFT
Awarded Sep 14, 2020 at 8:04
Is it possible to run SQL Server as 'NT Service\MSSQLSERVER' and EXECUTE AS a domain account?
Awarded Sep 11, 2020 at 17:21
(post deleted or otherwise unavailable)
Awarded Sep 10, 2020 at 12:15
How to ensure no duplicate records are added when using multiple Node JS processes
Awarded Sep 8, 2020 at 6:27
(post deleted or otherwise unavailable)
Awarded Sep 7, 2020 at 8:42
Why is PDO::ATTR_EMULATE_PREPARES = false causing "MySQL server has gone away" errors?
Awarded Sep 5, 2020 at 7:05
MySQL reuse select aliases
Awarded Sep 3, 2020 at 19:37
Debugging T-Sql code using Visual Studio 2019. Error message: frame not in module
Awarded Sep 3, 2020 at 14:43
(post deleted or otherwise unavailable)
Awarded Sep 3, 2020 at 8:18
Model multiple 1-m relationship to a single entity
Awarded Sep 2, 2020 at 18:07
(post deleted or otherwise unavailable)
Awarded Aug 26, 2020 at 6:12
Cassandra nodetool repair open files issue
Awarded Aug 23, 2020 at 7:56
Apply cardinality estimation problem in SQL Server
Awarded Aug 23, 2020 at 7:31
How to store a (record which holds a) reference to any other column (attribute) in another table (relation)
Awarded Aug 12, 2020 at 20:55
Oracle - Monitoring tablespace warnings and critical events via Microsoft Windows Event log
Awarded Aug 10, 2020 at 11:48
(post deleted or otherwise unavailable)
Awarded Aug 1, 2020 at 19:32
Consistent data in dimension and fact tables from multiple incrementally loaded staging tables
Awarded Jul 30, 2020 at 8:10
Choosing right database for storing bank transactions
Awarded Jul 29, 2020 at 13:25
Percona XtraDB Cluster - do I add arbiter IP in gcomm://?
Awarded Jul 22, 2020 at 8:50
(post deleted or otherwise unavailable)
Awarded Jul 15, 2020 at 6:56
Cannot use "ON CONFLICT" with postgres updatable view and partial index
Awarded Jul 14, 2020 at 13:06
Source Control Dynamics
Awarded Jul 14, 2020 at 12:34
Postgresql sudden storage increase at regular interval?
Awarded Jul 13, 2020 at 10:48
Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?
Awarded Jun 27, 2020 at 21:10
(post deleted or otherwise unavailable)
Awarded Jun 23, 2020 at 11:27
Multiple queries in phpmyadmin - Distance using coordinates, Slope, Intercept, Angle, and few more
Awarded Jun 22, 2020 at 14:51
Slow performance when joining a small table and filtering out on a non-key column in MariaDB (MySQL)
Awarded Jun 7, 2020 at 18:52
MySQL 8.0 table with JSON column that uses JSON "merge" operations has 500k rows but analyze table shows 7MM
Awarded May 26, 2020 at 21:40
SQL Server 2000\2005 compatibility with Active Directory 2016
Awarded May 25, 2020 at 7:25
Transfer data from MS SQL to PostgreSQL with SSIS ODBC destination
Awarded May 2, 2020 at 17:26
How to automatically rename columns from same table join?
Awarded Apr 29, 2020 at 15:32
Unable to connect to Mysql via JDBC but works fine with Mysql
Awarded Apr 27, 2020 at 2:04
1 2
3
4 5
…
14

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.