Database Administrators

Promoter

 Promoter
First bounty you offer on your own question.
Awarded 826 times.
Default Postgres privileges not showing on \ddp
Awarded Apr 22, 2020 at 21:27
How to write a wrapper for a heterogeneous VARIADIC function like jsonb_build_object()?
Awarded Apr 7, 2020 at 21:20
MYSQL Select query stuck at "Sending data"
Awarded Mar 29, 2020 at 19:00
How is this called in a snowflake schema?
Awarded Mar 29, 2020 at 13:00
How can Cumulative Updates to SQL Server 2019 be Slipstreamed into a Single Installer?
Awarded Mar 27, 2020 at 5:35
Why is an Oracle Package Variable Intermittently Incorrect after Multiple Updates
Awarded Mar 10, 2020 at 16:55
Fastest way to choose distinct rows and a different order by without using a subquery
Awarded Mar 1, 2020 at 23:30
Unrelated tables and time intervals
Awarded Feb 25, 2020 at 23:25
Designing a database structure for a permissions system
Awarded Feb 25, 2020 at 8:40
Setup VIP for PostgreSQL Replication
Awarded Feb 19, 2020 at 10:30
MySQL LIKE IN with Input Parameter of stored procedure Comma Separated Values
Awarded Feb 12, 2020 at 5:55
Grant MonitorAdmin / PROCESS privilege to user
Awarded Feb 8, 2020 at 16:15
Column length error querying SQLite via SQL Server Linked Server
Awarded Jan 26, 2020 at 4:25
Understanding INSERT ... ON DUPLICATE KEY UPDATE deadlock scenario
Awarded Jan 23, 2020 at 15:40
Fastest way to shrink LOB data in SQL Server
Awarded Jan 20, 2020 at 6:15
How can I reduce the memory usage of a tiny MEMORY table in MySQL?
Awarded Jan 17, 2020 at 20:35
Replication Hung - Seconds_Behind_Master Increasing
Awarded Jan 16, 2020 at 20:05
(post deleted or otherwise unavailable)
Awarded Jan 15, 2020 at 15:20
Database design issue, with multiple variables and constraints
Awarded Jan 7, 2020 at 16:30
SSRS 2016 subscriptions error - Something went wrong. Please try again later
Awarded Jan 6, 2020 at 20:30
troubleshooting mysqlimport very large text file
Awarded Jan 4, 2020 at 1:35
"Change user" command slow query
Awarded Dec 22, 2019 at 6:45
SQL Server experiencing THREADPOOL waits while still having plenty of available workers
Awarded Dec 16, 2019 at 4:40
SQL Server 2017 Stored Proc & TVF Performance Problem
Awarded Dec 13, 2019 at 14:10
Help performance tuning master/detail (email like inbox) SQL query
Awarded Dec 9, 2019 at 16:50
What exactly triggers the UPDATE of the column is_media_read_only on sys.database_files?
Awarded Dec 9, 2019 at 16:25
Operator used tempdb to spill data . The estimated row are less than real rows
Awarded Dec 4, 2019 at 9:35
How to maintain a query that runs forever?
Awarded Dec 2, 2019 at 8:00
Why am I getting a snapshot isolation issue on INSERT?
Awarded Nov 25, 2019 at 5:55
(post deleted or otherwise unavailable)
Awarded Nov 18, 2019 at 19:20
Can't Connect to MySQL database through PuTTY [closed]
Awarded Nov 8, 2019 at 20:35
Mysql Partitioning Query
Awarded Nov 6, 2019 at 9:15
SQL Server Agent runs a job on one server, not on the other
Awarded Oct 23, 2019 at 10:00
Does postgres single-user mode use postgresql.conf settings?
Awarded Oct 21, 2019 at 13:45
(post deleted or otherwise unavailable)
Awarded Oct 17, 2019 at 6:45
(post deleted or otherwise unavailable)
Awarded Oct 14, 2019 at 18:10
MySQL - Column value depends on values from two different tables
Awarded Oct 11, 2019 at 23:55
`CHANGE_TRACKING = AUTO` fails to populate full-text index
Awarded Oct 7, 2019 at 20:30
sqlite database changes not commited immediately
Awarded Oct 3, 2019 at 9:55
How to replicate CREATE USER command?
Awarded Oct 2, 2019 at 10:20
Authentication failed when deploy an Analysis Services project
Awarded Sep 30, 2019 at 17:10
How can I reduce time spent acquiring the mongodb schema lock?
Awarded Sep 30, 2019 at 12:55
Implementing a table that maintains a max heap property
Awarded Sep 29, 2019 at 13:05
mariabackup slave info and multi-master replication
Awarded Sep 26, 2019 at 21:10
Permissions issue in Docker SQL Server 2017 while restoring certificate
Awarded Sep 24, 2019 at 4:15
Oracle 12c query performance varies based on schema/user
Awarded Sep 23, 2019 at 18:45
Postgresql 11 logical replication - stuck in `catchup` state
Awarded Sep 18, 2019 at 11:45
Fast alter column NVARCHAR(4000) to NVARCHAR(260)
Awarded Sep 16, 2019 at 17:10
Cardinality estimate outside the histogram
Awarded Aug 16, 2019 at 17:20
Do long-running and locking queries on subscriber databases cause performance issues on the publisher dbs?
Awarded Aug 16, 2019 at 14:00
Converting SELECT subquery to LEFT JOIN doesnt return same value
Awarded Aug 9, 2019 at 7:15
Monthly Date and Hour wise report generation using PHP MYSQL
Awarded Jul 20, 2019 at 16:35
Can oscillating number of fragment decrease FTS query performance?
Awarded Jul 18, 2019 at 14:40
Replace column by LEFT OUTER join to save space
Awarded Jul 18, 2019 at 7:15
(post deleted or otherwise unavailable)
Awarded Jul 11, 2019 at 7:35
Calculate Inventory Costing Based on First in, First Out (FIFO)
Awarded Jul 10, 2019 at 22:00
Deadlock free MERGE-alike in MySQL?
Awarded Jun 21, 2019 at 7:55
(post deleted or otherwise unavailable)
Awarded Jun 17, 2019 at 4:15
Wordcount in a field (all and unique) - is there a more elegant/optimal way?
Awarded Jun 14, 2019 at 13:15
same query gets slower after other queries get called (using a lot of prepared statements inside stored procedures)
Awarded Jun 9, 2019 at 9:30
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.