Database Administrators
Sponsored by
Sponsored logo

Scholar

 Scholar
Ask a question and accept an answer.
Awarded 22959 times.
Problem setting up postgres
Awarded 10 mins ago
why does this correlated subquery return an error in PostgreSQL?
Awarded 2 hours ago
postgresql blocking behavior
Awarded 3 hours ago
Oracle simple count(*) SQL query takes "forever"
Awarded 7 hours ago
Does postgresql have native support for a HA cluster?
Awarded 10 hours ago
What happens to written WAL logs if a transaction is aborted in the middle?
Awarded 11 hours ago
\dt says "Did not find any relations."
Awarded 23 hours ago
postgresql Modifying existing unique index
Awarded yesterday
What's the best practices for storing visits?
Awarded yesterday
Column collision in Left join with many columns vs PHPMyAdmin resultset
Awarded yesterday
How to split one column into two using different tables?
Awarded yesterday
i need answer for this problem [closed]
Awarded yesterday
FATAL: no pg_hba.conf entry for replication connection from host
Awarded yesterday
Calculate Percentage for Values Exist in Only One or Both Tables
Awarded yesterday
MySQL is not allowing me to insert rows when I do not include a value for the auto incrementing field in the sql statement
Awarded 2 days ago
Index on VARCHAR(MAX) column
Awarded 2 days ago
Returning data count from a particular day after comparing 2 tables
Awarded 2 days ago
Trigger that can update a column in the row being inserted with value from another table
Awarded Oct 18 at 16:05
How to design banking financial transactions database schema?
Awarded Oct 18 at 11:31
Query with CASE in subquery join clause is very slow on PostgreSQL but fast on Oracle and MariaDB
Awarded Oct 18 at 10:52
Update Postgres-12.2 to Postgres-12.8
Awarded Oct 18 at 8:41
Generate all combinations of a list of strings
Awarded Oct 18 at 6:20
PostgreSQL IO Cost logic
Awarded Oct 17 at 18:05
Passing a python list into plpy execute for the in operator without string interpolation
Awarded Oct 16 at 14:55
How to run SELECT only if condition is met
Awarded Oct 16 at 9:31
Optimal index for a nested query?
Awarded Oct 15 at 13:48
How can I use a table as a GUID pool without suffering race conditions?
Awarded Oct 14 at 14:42
How to use pg_get_viewdef(view_oid) to get a view definition?
Awarded Oct 14 at 12:05
MariaDB Galera 3-Node Cluster Sometimes Doesn't Serves
Awarded Oct 14 at 8:30
Is it safe to add indexes after checking for missing indexes?
Awarded Oct 13 at 21:20
Query planner showing identical row counts for MCV and non-MCV values with a partial expression index of a JSONB field
Awarded Oct 13 at 18:36
table or view does not exist while updating a table from private temporary
Awarded Oct 13 at 13:41
Performing operation on transactional insert
Awarded Oct 13 at 9:02
Query for getting the sum of all unique entries in a column
Awarded Oct 13 at 4:16
Postgres custom type with constraints
Awarded Oct 12 at 15:11
How to find type mismatches (implicit conversion) between sprocs and tables?
Awarded Oct 12 at 14:42
PostgreSQL: adding a few columns more than triples the original table size
Awarded Oct 12 at 11:43
PostgreSQL how to add ordinal numbers to rows created by regexp_split_to_table()?
Awarded Oct 11 at 19:35
In a food composition database, how would you model a food's relationship with its nutrients?
Awarded Oct 11 at 13:20
8000 character limit in OPENQUERY against Analysis Server
Awarded Oct 11 at 10:16
How to increase database size in Microsoft SQL Server Express?
Awarded Oct 11 at 9:18
How to perform hundreds of thousands to millions of inserts/updates without killing the database?
Awarded Oct 11 at 7:25
Filtering a large number of rows in Cassandra
Awarded Oct 10 at 20:08
SQL Server log_reuse_wait_desc is ACTIVE_TRANSACTION but there are no active transactions
Awarded Oct 10 at 12:05
Store value of subquery in update for later use
Awarded Oct 9 at 17:18
Sub query not working as expected trying to order by then group by, MySQL 5.5 vs 5.7
Awarded Oct 9 at 7:25
SQL Server create cron job without SQL Server Agent
Awarded Oct 9 at 2:10
Self-deadlocked process on a table variable
Awarded Oct 8 at 17:26
Postgres RLS: how to error instead of ignoring rows not matched by the policy? [duplicate]
Awarded Oct 7 at 23:46
Create new sql table based on a query from another table MariaDb
Awarded Oct 7 at 20:31
postgres set null will improve performance in sparse data?
Awarded Oct 7 at 17:35
T-SQL : Grouping based on chronological switch periods
Awarded Oct 7 at 16:50
How to evaluate whether it's time to optimize a MySQL InnoDB table?
Awarded Oct 7 at 16:22
Is it better practice to have a column which is null part of the time, or a separate table with a foreign key?
Awarded Oct 7 at 16:00
How to select the latest continuous set of rows of a certain type?
Awarded Oct 7 at 15:42
Configuring space symbols in text search configuration
Awarded Oct 7 at 14:40
Select * - Why or Why Not?
Awarded Oct 7 at 14:06
Finding the minimum of a column depending the value of a second column
Awarded Oct 7 at 12:41
SQL case problem [duplicate]
Awarded Oct 7 at 6:50
Data from other user not visible
Awarded Oct 6 at 13:43
1
2 3 4 5
…
383

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.