Skip to main content
Database Administrators

Benefactor

 Benefactor
First bounty you manually award on your own question.
Awarded 374 times.
Meaning of the precision and the scale, in an oracle's reference?
Awarded Jul 29 at 3:45
Postgres Query Slow 0.05% of the time
Awarded May 30 at 5:05
with composite keys, do I still need index for all columns separately?
Awarded Apr 17 at 20:34
Grouping and arranging data using FOR JSON PATH and INCLUDE_NULL_VALUES
Awarded Apr 16 at 2:27
How to optimize following subnet that is decomposed into multiple sub-one?
Awarded Jul 31, 2024 at 13:41
High Memory Usage for SqlBulkCopy
Awarded Jun 23, 2024 at 2:49
Why is 'ParameterCompiledValue' missing from execution plan XML?
Awarded Jun 22, 2024 at 13:06
How to determine the global primary instance in a SQL Server distributed availability group using T-SQL?
Awarded Apr 29, 2024 at 3:03
How to query for aggregated streaks?
Awarded Apr 24, 2024 at 14:12
Transaction management work under Instance or database
Awarded Feb 11, 2024 at 16:45
CASCADE DELETE per statement
Awarded Dec 28, 2023 at 23:03
Optimize query with many joins
Awarded Dec 28, 2023 at 12:09
How to add index to a big table with 60M records without downtime?
Awarded Dec 22, 2023 at 14:09
Query optimization question
Awarded Nov 28, 2023 at 18:05
Is there a stronger guarantee of minimal logging when running INSERT INTO [...] WITH (TABLOCK) on a heap than on a B-tree?
Awarded Nov 16, 2023 at 11:40
Table size increased after changing datatype from nchar to varchar
Awarded Oct 16, 2023 at 19:57
MYSQL workbench like gui tool for oracle 10 g or more
Awarded Sep 28, 2023 at 2:37
Slow query in a created view. How can I fix it?
Awarded Sep 18, 2023 at 7:41
How to design a database that needs to merge similar data from different sources?
Awarded Aug 23, 2023 at 13:49
Resultset from jsonb array
Awarded May 3, 2023 at 12:20
What difference between columnar and wide column databases?
Awarded Feb 5, 2023 at 0:51
How to interpret "transactions per second"?
Awarded Jan 4, 2023 at 9:26
Structuring a relational database to run an automatic process
Awarded Dec 29, 2022 at 11:36
More efficient calculations of stock splits
Awarded Nov 9, 2022 at 21:01
How to have uniqueness constraints for structures across multiple tables?
Awarded Aug 11, 2022 at 19:40
Is there a way to use time series databases effectively without absolute timestamps?
Awarded Jul 10, 2022 at 10:15
Design database for history data
Awarded Jun 18, 2022 at 13:18
Cannot connect to SQL Server, cannot start SQLEXPRESS service
Awarded Jun 16, 2022 at 9:52
help with improve query
Awarded May 4, 2022 at 22:10
Display and sort data from 2 tables
Awarded May 3, 2022 at 7:56
Efficient unique Inner Join
Awarded Apr 19, 2022 at 11:35
How to migrate the permissions of logins - for example - grant/remove/deny permissions on system objects and server instance?
Awarded Apr 8, 2022 at 5:27
Query result precedence if filter columns have values
Awarded Apr 4, 2022 at 13:06
How to modify the Replication Subscription Job/script to make it point an IP Address and a Port number?
Awarded Apr 3, 2022 at 17:21
Problems with pg_upgradecluster
Awarded Jan 23, 2022 at 22:41
Detecting inline, inline-compressed and TOAST storage
Awarded Jan 4, 2022 at 23:15
Class Table Inheritance combined with running searches and paging
Awarded Oct 8, 2021 at 15:50
Why is Index causing bad estimation and execution plan
Awarded Aug 4, 2021 at 2:50
Importing a 16 GB MySQL file silently fails
Awarded Jul 29, 2021 at 22:05
row level security using roles in SQL Server
Awarded Jul 21, 2021 at 19:27
How do I do a JOIN in ANSI SQL 89 syntax?
Awarded Jun 30, 2021 at 13:45
Reckless behavior of psql \e
Awarded Jun 17, 2021 at 13:41
Table is full even with innodb_file_per_table
Awarded Jun 15, 2021 at 18:21
How to turn a set of flat trees into a single tree with multiple leaves?
Awarded Jun 12, 2021 at 10:05
How do I recover data from the postgres data directory on my hard drive?
Awarded May 7, 2021 at 10:36
Space consumed by a column in non clustered index
Awarded Apr 27, 2021 at 5:07
Counting MAX event simultaniusly (based in datatime2) within a tallytable
Awarded Mar 23, 2021 at 20:08
Executions/min and CPI ms/sec inside Activity Monitor is too high
Awarded Mar 10, 2021 at 6:27
Many to Many - Concept
Awarded Feb 24, 2021 at 14:07
Configure Connection String to Use Target Machine Credentials
Awarded Feb 19, 2021 at 15:27
Server quit without updating PID file when trying to start MySQL server?
Awarded Jan 30, 2021 at 0:26
Create cyclic pointers in postgresql 9.5
Awarded Jan 17, 2021 at 2:57
What could explain a 30 second MySQL SELECT query latency when profiling records an execution time of <1 second?
Awarded Jan 4, 2021 at 20:06
Find filtered indexes on an Oracle table
Awarded Jan 2, 2021 at 16:05
What type of locks are needed when creating a Postgres index concurrently?
Awarded Dec 6, 2020 at 12:42
Does binlog_group_commit_sync_delay affect existing binary logging in MySQL
Awarded Nov 2, 2020 at 8:05
How to efficiently recompute the data in a rather large X table?
Awarded Oct 6, 2020 at 11:07
PostgreSQL complaining about shared memory, but shared memory seems to be OK
Awarded Sep 24, 2020 at 19:02
Model multiple 1-m relationship to a single entity
Awarded Sep 2, 2020 at 18:07
Apply cardinality estimation problem in SQL Server
Awarded Aug 27, 2020 at 8:58
1
2 3 4 5
…
7