Database Administrators

Promoter

 Promoter
First bounty you offer on your own question.
Awarded 826 times.
Find Ancestry From JSON
Awarded Jun 2, 2019 at 10:40
(post deleted or otherwise unavailable)
Awarded Jun 1, 2019 at 11:05
Table structure for entity versioning
Awarded May 29, 2019 at 14:45
Can't run the newest version of MySQL on phpMyAdmin
Awarded May 28, 2019 at 9:25
Differences Between Setting Up Transaction Log Shipping through Wizard vs Scripts
Awarded May 22, 2019 at 16:25
Tracking errors from prepared SQL statements
Awarded May 20, 2019 at 7:40
Postgres Row Level Security policy optimizes poorly compared to inline version
Awarded May 3, 2019 at 3:40
MySQL join has drastically worse performance after upgrading from 5.6 to 5.7
Awarded Apr 25, 2019 at 17:50
(post deleted or otherwise unavailable)
Awarded Apr 25, 2019 at 15:25
Update column without dropping dependancies
Awarded Apr 23, 2019 at 7:35
Database Design for Cars
Awarded Apr 21, 2019 at 7:45
How to handle failed Index Optimization (Ola Hallengren) step in SQL Azure Elastic Job Agent?
Awarded Apr 11, 2019 at 18:50
How to handle schema changes in source systems when running an ETL?
Awarded Mar 25, 2019 at 20:50
MongoDB - Mongorestore is not working as expected
Awarded Mar 22, 2019 at 7:55
(post deleted or otherwise unavailable)
Awarded Mar 20, 2019 at 15:10
Unexpected RAM usage on MySQL
Awarded Mar 3, 2019 at 11:40
Postgres partial index on IS NULL not working
Awarded Feb 19, 2019 at 4:45
Error Code: 1728. Cannot load from mysql.db. The table is probably corrupted
Awarded Feb 13, 2019 at 5:10
The merge process could not connect to the Publisher ' '. Check to ensure that the server is running. (
Awarded Feb 11, 2019 at 12:15
Should I redesign my "events" table
Awarded Feb 5, 2019 at 17:00
Why does msdb.dbo.backupset have entries for each database every 15 minutes?
Awarded Feb 5, 2019 at 13:50
Hosting Multiple MongoDB Databases on the same MongoDB Instance/Cluster
Awarded Feb 2, 2019 at 22:40
Postgres LIKE query using a GiST index is just as slow as a full scan
Awarded Jan 25, 2019 at 12:30
Mongo Db Update (upsert) taking several seconds
Awarded Jan 21, 2019 at 16:35
Postgres 9.6 - Taking differenctial backup
Awarded Jan 20, 2019 at 9:10
Is it safe to insert the newest row with SELECT INTO?
Awarded Jan 13, 2019 at 10:30
How does the recovery strategy of PostgreSQL exactly work?
Awarded Jan 8, 2019 at 19:05
MySQL Select Union; Filter by Shared Relation?
Awarded Jan 7, 2019 at 13:55
Concurrent update queries locking rows when `where` clause doesn't match
Awarded Dec 22, 2018 at 18:05
(post deleted or otherwise unavailable)
Awarded Dec 18, 2018 at 22:50
Percona Xtrabackup fails to backup InnoDB table with fulltext index
Awarded Dec 18, 2018 at 20:35
I need help creating an encrypted listener for my 11gR2 database using a wallet and SHA1 encryption
Awarded Dec 18, 2018 at 19:15
SQL Server one-to-many and index fragmentation
Awarded Nov 27, 2018 at 18:15
Service Principal as SQL Active Directory Admin, does it use Graph API?
Awarded Nov 26, 2018 at 9:20
Synchronize two MySQL databases between two servers
Awarded Nov 22, 2018 at 4:50
Group by range DATIME of 2h up or down - Mysql
Awarded Nov 19, 2018 at 8:05
Backing up a SQL 2008 DB, then restoring, gives a SQL 2005 (compatibility level 90) DB
Awarded Nov 15, 2018 at 17:50
Security considerations of allowing logical replication subscribers on PostgreSQL
Awarded Nov 14, 2018 at 19:00
Best practices for transferring data across long, wide tables
Awarded Oct 26, 2018 at 12:00
Design with inheritance and two 1 to many relationships to the same table
Awarded Oct 22, 2018 at 21:50
Is it better to store one tsvector column for all fields or one tsvector column per field?
Awarded Oct 20, 2018 at 13:40
(post deleted or otherwise unavailable)
Awarded Oct 15, 2018 at 16:30
Is this surprising deadlock reasonable or a MariaDB bug?
Awarded Oct 12, 2018 at 19:50
What is the optimal setting for innodb_buffer_pool_instances for a mid level AWS RDS server with 6gb buffer pool?
Awarded Oct 12, 2018 at 1:10
Best practice around non-production databases refreshes and TDE
Awarded Oct 8, 2018 at 10:30
(post deleted or otherwise unavailable)
Awarded Oct 3, 2018 at 18:50
When does Log shipping restore job mark itself to completion in standby mode
Awarded Sep 20, 2018 at 13:50
(post deleted or otherwise unavailable)
Awarded Sep 18, 2018 at 5:20
Purpose of SQL Server Application Roles
Awarded Sep 11, 2018 at 22:35
Is snapshot isolation good?
Awarded Aug 27, 2018 at 7:30
Changing a JSON object parsed with APEX_JSON
Awarded Aug 20, 2018 at 18:50
Query to split data in a column into multiple columns using id in another column (pivot table; crosstab)
Awarded Aug 6, 2018 at 19:45
Oracle 12 Startup upgrade throws error 443
Awarded Aug 3, 2018 at 7:10
(post deleted or otherwise unavailable)
Awarded Jul 25, 2018 at 14:10
Changing the use of GETDATE() in the entire database
Awarded Jul 9, 2018 at 13:42
What is an "ACCESS METHOD"?
Awarded Jul 7, 2018 at 14:06
MySql concurrency with COUNT
Awarded Jul 6, 2018 at 10:37
postgresql - Importing CSV Data with Custom Type
Awarded Jul 6, 2018 at 0:15
Row estimates always too low
Awarded Jul 5, 2018 at 16:17
Transfer row from 'parent' to 'child' without creating duplicate and without knowing all 'parent' columns
Awarded Jul 4, 2018 at 21:13
1
…
3 4
5
6 7
…
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.