Database Administrators

Editor

 Editor
First edit.
Awarded 29110 times.
PostgreSQL: difference between collations 'C' and 'C.UTF-8'
Awarded 5 hours ago
Locking/Isolation - MariaDB
Awarded 15 hours ago
get items from database with minimum records
Awarded 19 hours ago
Which is the best way to model different types of people and relationships in a database?
Awarded yesterday
How to swap the paths of two records (and their children) using a postgresql ltree?
Awarded yesterday
How to organize a database for storing text\csv files?
Awarded yesterday
Why can SQL Server not perform a TOP N SORT between an Index Seek and the Key Lookup?
Awarded 2 days ago
IF EXISTS doesn't stop errors on RDS Postgres 11.19 instance
Awarded 2 days ago
Compare two tables for discrepencies
Awarded 2 days ago
Calculate (n) workdays from a given date, using a calendar table
Awarded 2 days ago
Connecting to MariaDB server: ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11
Awarded 2 days ago
better database design for nested relation (many-to-many-to-many?)
Awarded Sep 30 at 23:34
Migrating from PostgreSQL to MySQL (data with \r\n)
Awarded Sep 30 at 17:57
Convert a list-of-IDs column into a junction table
Awarded Sep 30 at 1:33
(post deleted or otherwise unavailable)
Awarded Sep 29 at 15:25
Configuring a Failover Cluster Fileshare Witness?
Awarded Sep 29 at 14:31
List all tables being used in a function
Awarded Sep 29 at 8:43
How to design tables for airbnb style booking system
Awarded Sep 29 at 7:56
Configuring Always On Availability Groups sql Server 2019 and log backup
Awarded Sep 28 at 16:20
MySQL: Why is auto_increment limited to just primary keys?
Awarded Sep 28 at 10:55
SQL Server 2019 CU22 error Using 'dbghelp.dll' version '4.0.5' & non-yielding on Scheduler
Awarded Sep 27 at 23:12
Mongodb database hosting limitations and options
Awarded Sep 27 at 18:57
`pg_restore` unable to read `toc.dat` created by `pg_dump -Fd`: `pg_restore: error: expected format (1) differs from format found in file (3)`
Awarded Sep 27 at 18:35
Double Entry Accounting Schema
Awarded Sep 27 at 17:05
New column that subtacts 2 rows from a different column and pushing out the difference number
Awarded Sep 27 at 8:06
UPDATE QUERY ACROSS TWO TABLES JOINED BY ANOTHER MSSQL
Awarded Sep 27 at 7:50
Please I received this error on a scrub process “scrub failed, no running scrub jobs”
Awarded Sep 26 at 19:49
Almost identical MySQL server totally different performance
Awarded Sep 26 at 18:07
What does it mean when a session is highlighted in red in the PgAdmin dashboard?
Awarded Sep 26 at 15:10
Slow join on geometry fields
Awarded Sep 26 at 13:48
What is Oracle Wallet?
Awarded Sep 26 at 12:35
Read MySQL undo logs
Awarded Sep 26 at 7:49
Percona XtraDB Cluster: State transfer failed: -13 (Permission denied)
Awarded Sep 25 at 20:15
Optimize MySQL server configuration insertion
Awarded Sep 25 at 12:34
(post deleted or otherwise unavailable)
Awarded Sep 25 at 2:51
Cassandra 3.11.16 cannot be installed due to dependencies
Awarded Sep 25 at 0:42
How do I query out the largest value using an index
Awarded Sep 24 at 21:33
Slow mysql load times for database statistics in database table
Awarded Sep 24 at 9:42
Best solution for storing metadata and data from documents?
Awarded Sep 23 at 16:18
How can I perform a sanity check to confirm data is consistent after a repair?
Awarded Sep 22 at 12:27
How to use WITH in a better way to parametrise a date
Awarded Sep 22 at 9:40
SQL Server High memory at startup
Awarded Sep 22 at 7:41
Create new postgres database from pg_dump plain-text Script
Awarded Sep 21 at 23:33
"lock request time out period exceeded" Error When Trying to See DB Hierarchies
Awarded Sep 21 at 17:12
SELECT inside SELECT in Redshift
Awarded Sep 21 at 16:25
column size differing when querying from all_tab_columns
Awarded Sep 20 at 14:41
Track all modifications to a PostgreSQL table
Awarded Sep 19 at 21:40
How to pass parameters to a Snowflake query in SSRS
Awarded Sep 19 at 20:32
SQL Server 2017 Availability Group now thinks it is in a cluster - it isn't and never was!
Awarded Sep 19 at 16:17
PostgreSQL to MS SQL Server bridge/gateway
Awarded Sep 19 at 13:52
Why did the number of live rows fetched by index scans drop after table ANALYZE?
Awarded Sep 19 at 8:19
Failed MSSQL Backup Restoration Due to Defunct State in a File: How to Resolve?
Awarded Sep 19 at 8:10
Is high logical read terrible for performance? AFAIK this is reading from memory, which is fast
Awarded Sep 19 at 7:21
Reuse of space after TRUNCATE TABLE by other tables
Awarded Sep 19 at 2:22
How to optimize a query in postgres?
Awarded Sep 18 at 20:47
Why does PostgreSQL want max_wal_senders equal to 0 and greater than 0 at the same time?
Awarded Sep 18 at 18:41
How to update multiple records after insert/update in SQL Trigger?
Awarded Sep 18 at 12:18
Request on a copied table is faster than on original table, why?
Awarded Sep 18 at 8:57
Collation version mismatch
Awarded Sep 17 at 14:32
SQL Maintenance Plan 'Could not find part of the path' - where is it getting the path from?
Awarded Sep 16 at 22:47
1
2 3 4 5
…
486

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.