Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.
Awarded 3207 times.
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
Does "Synchronous-Commit Availability Mode" ensure consistency between Replicas?
Awarded Dec 29, 2020 at 3:07
Is it possible to get seek based parallel plan for distinct/group by?
Awarded Dec 28, 2020 at 7:41
How to define custom path to MySQL socket file?
Awarded Dec 28, 2020 at 2:03
Disk space unreleased after cleaning up rows from PG table
Awarded Dec 24, 2020 at 16:41
Fragmentation Level for Heaps
Awarded Dec 23, 2020 at 16:55
Order by alphabet and then by numbers
Awarded Dec 20, 2020 at 1:36
INSERT from a SELECT combined with a single value
Awarded Dec 18, 2020 at 15:35
Indexed view not used in actual execution plan?
Awarded Dec 16, 2020 at 23:48
get only rows with max group value
Awarded Dec 16, 2020 at 15:47
Database schema for entities with two possible owner/parent types?
Awarded Dec 15, 2020 at 8:57
Won't start: InnoDB: Corrupted page ... Tablespace was not found
Awarded Dec 12, 2020 at 7:36
Does cancelling an (AUTO)VACUUM process in PostgreSQL make all the work done useless?
Awarded Dec 10, 2020 at 14:32
How to disable starting MySQL service on Windows7 startup?
Awarded Dec 10, 2020 at 14:32
SQL Server - Is there a way to prevent shared range locks to 'infinity' when using an indexed view?
Awarded Dec 10, 2020 at 12:07
Why none of the sql_mode(s) are recognized by MySQL?
Awarded Dec 9, 2020 at 2:41
WAL archive: FAILED (please make sure WAL shipping is setup)
Awarded Dec 8, 2020 at 12:16
Collate issues with wrong characters
Awarded Dec 6, 2020 at 18:27
How to Install postgresql-client-11 on Ubuntu 18.04
Awarded Dec 2, 2020 at 11:02
How to cast to int array in Postgresql?
Awarded Nov 30, 2020 at 13:18
Return counts for multiple ranges in a single SELECT statement
Awarded Nov 28, 2020 at 18:10
SQL Server - Benefits of splitting databases across different logical drives
Awarded Nov 28, 2020 at 14:33
Static DAC ports for named instances
Awarded Nov 26, 2020 at 9:16
PostgreSQL: How does COPY FROM behave inside a transaction?
Awarded Nov 26, 2020 at 9:16
Postgresql: invalid record length at 29/E4624520 but replication looks fine
Awarded Nov 25, 2020 at 1:57
Oracle 11g DBMS_CRYPTO invalid identifier
Awarded Nov 23, 2020 at 16:02
using a column that references an object_id in your own table
Awarded Nov 23, 2020 at 16:02
Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery
Awarded Nov 23, 2020 at 16:02
Can I connect to the database as the user "dbo"?
Awarded Nov 19, 2020 at 21:08
SSIS - This error is thrown by Connections collection when the specific connection element is not found
Awarded Nov 19, 2020 at 17:07
SQLITE: A problem of tags and products
Awarded Nov 19, 2020 at 4:48
Enforce a column as unique based on another column value
Awarded Nov 18, 2020 at 22:55
Windows OS level scheduled disk defragment tasks and SQL data volumes
Awarded Nov 17, 2020 at 6:12
1
…
8 9
10
11 12
…
54

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.