Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.
Awarded 3179 times.
Can a PostgreSQL Trigger be used to ignore an insert?
Awarded Mar 24, 2021 at 18:32
How to limit rows in PostgreSQL update statement
Awarded Mar 23, 2021 at 18:32
MySQL DELETE becomes exceptionaly slow with a large number of rows
Awarded Mar 23, 2021 at 10:48
If NoSQL stands for "Not only SQL", is SQL a subset of NoSQL?
Awarded Mar 20, 2021 at 18:26
Sql Server Fix Users
Awarded Mar 19, 2021 at 12:32
Oracle insert max from two date
Awarded Mar 17, 2021 at 11:27
How to get MAX() with an upper bound?
Awarded Mar 17, 2021 at 0:03
How to get 0 as array_length() result when there are no elements
Awarded Mar 16, 2021 at 12:48
psql denies access to file when using COPY FROM
Awarded Mar 13, 2021 at 15:35
Do SQL Server Views update their data types automatically based on what tables feed them?
Awarded Mar 9, 2021 at 18:15
Export all MySQL users
Awarded Mar 7, 2021 at 20:17
Best way to store a value which could be multiple types
Awarded Mar 5, 2021 at 20:25
Difference between pg_column_size(table.*) and pg_column_size(table.col1) + pg_column_size (table.col2)
Awarded Mar 5, 2021 at 7:20
How to check the syntax of pg_hba.conf and other postgresql conf files on ubuntu/debian/linux?
Awarded Mar 4, 2021 at 17:36
Slow order by SQL Server
Awarded Mar 3, 2021 at 13:09
Trick to remember which instance I am working with
Awarded Mar 3, 2021 at 0:48
How are indexes represented in an ERD?
Awarded Feb 27, 2021 at 14:05
Postgresql: How to add a role that inherits from another?
Awarded Feb 26, 2021 at 20:18
Postgresql: How to index jsonb array of objects column
Awarded Feb 26, 2021 at 17:41
Size Requirement of SQL Database
Awarded Feb 25, 2021 at 14:07
Postgres - Encoding, Collation and CType
Awarded Feb 22, 2021 at 8:26
How do I include nulls during comparisons in SQL Server?
Awarded Feb 20, 2021 at 16:40
What is the difference between an after update and a before update in PostgreSQL
Awarded Feb 19, 2021 at 19:26
Is there a way to back up agent jobs?
Awarded Feb 18, 2021 at 18:20
PostgreSQL two different ways to generate a UUID: gen_random_uuid vs uuid_generate_v4?
Awarded Feb 17, 2021 at 20:41
Missing rows under read committed isolation
Awarded Feb 17, 2021 at 16:48
How to relate two rows in the same table
Awarded Feb 16, 2021 at 22:36
Disk usage of integer column vs boolean column in Postgres
Awarded Feb 15, 2021 at 21:06
Why mongo is choosing the wrong index / execution plan?
Awarded Feb 15, 2021 at 6:34
How do I cleanup Postgres WAL?
Awarded Feb 13, 2021 at 19:35
Local Backup from Amazon RDS PostgreSQL database
Awarded Feb 12, 2021 at 17:25
Can I use hypertables in timescaledb merely to get better insert rates?
Awarded Feb 12, 2021 at 11:21
Carry over long sequence of missing values with Postgres
Awarded Feb 10, 2021 at 15:10
PostgreSQL doesn't use all the RAM it could
Awarded Feb 10, 2021 at 3:27
Trace flag and which need to be turned off and Why
Awarded Feb 8, 2021 at 22:02
Efficient merging (removing duplicates) of arrays
Awarded Feb 7, 2021 at 1:20
Can I generate a list of all combinations between two columns
Awarded Feb 5, 2021 at 15:36
How can I get the page size of a Postgres database?
Awarded Feb 5, 2021 at 13:03
In PostgreSQL, how do I make it so that either column A or column B must be non-null?
Awarded Feb 4, 2021 at 1:02
Deadlock with multi-row INSERTs despite ON CONFLICT DO NOTHING
Awarded Feb 3, 2021 at 14:02
Why choose a top query and temporary table instead of a cursor for a loop?
Awarded Feb 3, 2021 at 13:26
Improve UPDATE performance on big table
Awarded Feb 1, 2021 at 12:42
Case-insensitive collation still comparing case-sensitive
Awarded Jan 30, 2021 at 17:50
As there is no unsigned int in SQL Server doesn't an Identity Seed of -2,147,483,648 make more sense for large tables?
Awarded Jan 30, 2021 at 7:46
How to use select (query)alias on WHERE clause?
Awarded Jan 29, 2021 at 6:31
Estimated vs Actual rows differences (actual much smaller than estimated) - sort
Awarded Jan 27, 2021 at 12:27
How to disable the logging of parameter values in PostgreSQL
Awarded Jan 25, 2021 at 14:28
Create failed for Index 'ClusteredColumnStoreIndex'. Timeout expired
Awarded Jan 22, 2021 at 22:04
How can I use an array variable inside the IN operator for Oracle SQL?
Awarded Jan 20, 2021 at 15:04
In Postgres, how to get a list of current defined savepoint?
Awarded Jan 18, 2021 at 17:51
Messages about parallel redo
Awarded Jan 17, 2021 at 2:40
Are the results of the STRING_SPLIT() function returned in a deterministic order?
Awarded Jan 15, 2021 at 7:16
Having a PostgreSQL database exposed to the internet
Awarded Jan 9, 2021 at 9:17
Dropping multiple KEYS of a table
Awarded Jan 7, 2021 at 13:46
how to track progress of a large postgres dump
Awarded Jan 7, 2021 at 10:46
PostgreSQL filtering on array length inside JSON
Awarded Jan 4, 2021 at 23:57
How to get the timezone from a PostgreSQL timestamp
Awarded Jan 3, 2021 at 8:35
How to dispose of large tables with the least impact to log shipping?
Awarded Jan 2, 2021 at 18:15
Inserting with implicit type conversion causes warning for cardinality estimates
Awarded Dec 29, 2020 at 14:30
MySQL: How to create Column if not exists?
Awarded Dec 29, 2020 at 10:07
1
…
7 8
9
10 11
…
53

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.