Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.
Awarded 3177 times.
array_length if array is empty behaviour
Awarded Jan 17, 2022 at 4:03
Why is MySQL Server software so huge?
Awarded Jan 16, 2022 at 3:40
Best practice for storing record metadata
Awarded Jan 13, 2022 at 21:48
Mysql 8 ST_GeomFromText giving error Latitude out of range in function st_geomfromtext. It must be within [-90.000000, 90.000000]
Awarded Jan 13, 2022 at 1:07
Select only those records that have different/multiple values for a particular column
Awarded Jan 12, 2022 at 18:33
The disappearing act of the "Invalid length parameter passed to the LEFT or SUBSTRING function" error
Awarded Jan 12, 2022 at 10:06
Why do I get The transaction log for database 'X' is full due to 'ACTIVE_TRANSACTION' w/ Simple Recovery and auto grow log?
Awarded Jan 11, 2022 at 19:42
How do I use the input from a \prompt in a conditional (\if)?
Awarded Jan 10, 2022 at 23:55
Suppressing SQL Server Management Studio's 'Messages' from output of SQLCMD via SQL Server Agent
Awarded Jan 10, 2022 at 20:22
MySQL: How to drop all tables starting with a prefix?
Awarded Jan 10, 2022 at 10:55
Does PostgreSQL index null values?
Awarded Jan 7, 2022 at 3:32
How Important is the buffer pool really?
Awarded Jan 5, 2022 at 15:05
Using a type in place of a column definition list?
Awarded Jan 4, 2022 at 15:40
PostgreSQL: a Login Role to only access Views
Awarded Jan 4, 2022 at 8:03
PgBouncer "no more connections allowed (max_client_conn)"
Awarded Jan 3, 2022 at 23:33
pgadmin dashboard is gone
Awarded Dec 30, 2021 at 17:10
Why would you index text_pattern_ops on a text column?
Awarded Dec 25, 2021 at 11:11
Why can I select all fields when grouping by primary key but not when grouping by another column
Awarded Dec 21, 2021 at 16:50
Select rows and add their previous rows
Awarded Dec 21, 2021 at 13:42
SQL Query Formatter
Awarded Dec 20, 2021 at 18:25
Postgres : Truncate if exists in psql function with parameter
Awarded Dec 19, 2021 at 18:46
Is there a performance or storage space advantage to lowering time/timestamp precision in PostgreSQL?
Awarded Dec 16, 2021 at 21:42
MySQL FullText search on string shorter than 3 chars returns no rows
Awarded Dec 16, 2021 at 7:51
Why is it not possible to alter a view with a "CREATE OR REPLACE"?
Awarded Dec 15, 2021 at 13:10
What does SQL Server use to do a count(*) on a table?
Awarded Dec 15, 2021 at 0:17
Replicate only a few tables in PostgreSQL 10
Awarded Dec 14, 2021 at 13:49
Is it "OK" to have a table that only contain foreign keys?
Awarded Dec 14, 2021 at 9:32
Error "column does not exist" in a SELECT with JOIN and GROUP BY query
Awarded Dec 13, 2021 at 23:47
Permissions on Trigger Problem
Awarded Dec 10, 2021 at 17:40
Is there a way to define macros/alias in psql?
Awarded Dec 10, 2021 at 17:40
When to switch from MyISAM to InnoDB?
Awarded Dec 10, 2021 at 17:40
Where EVENTS history are logged/recorded in MySql?
Awarded Dec 9, 2021 at 8:50
How do I find out *why* a user has certain effective permissions?
Awarded Dec 8, 2021 at 11:31
First Normal Form, why is it good and how does it reduce redundancy
Awarded Dec 8, 2021 at 11:31
pg_restore certain tables only
Awarded Dec 3, 2021 at 21:20
Adding new null column to table caused lock
Awarded Dec 3, 2021 at 3:56
Breaking a big insert query into smaller ones
Awarded Dec 2, 2021 at 17:25
"Role does not exist" error when granting usage on public schema, but role does exit
Awarded Dec 1, 2021 at 23:35
Postgres: Get nextval in sequence without actually incrementing sequence?
Awarded Nov 29, 2021 at 13:08
How can I use an environment variable in a Postgres function?
Awarded Nov 26, 2021 at 15:47
Is there way to get transaction commit timestamp in Postgres?
Awarded Nov 26, 2021 at 15:47
Find which functions are used
Awarded Nov 25, 2021 at 22:07
Loop through key/value pairs of a jsonb object in postgresql function
Awarded Nov 25, 2021 at 7:42
Strange conditional Syntax in TSQL Query: "<=+" What does it do?
Awarded Nov 23, 2021 at 18:36
Can SQL Server use multiple indexes for the same query?
Awarded Nov 23, 2021 at 14:42
Query time of fetching a particular, single row id by PK is extremely slow
Awarded Nov 21, 2021 at 19:27
MariaDB - "ERROR 1205 ... Lock wait timeout exceeded; ..." when doing multiple parallel UPDATEs affecting different rows
Awarded Nov 20, 2021 at 11:11
What's the differences between the two version of oracle client download file, "client" and "client home"?
Awarded Nov 19, 2021 at 10:45
how will nvarchar(max) store data in database will it be fast if some data is less then 4000 characters?
Awarded Nov 18, 2021 at 11:26
How to get notices to the output stream?
Awarded Nov 17, 2021 at 10:25
How to run SQL services on NT SERVICE\MSSQLSERVER account if it is running earlier on LocalSystem
Awarded Nov 16, 2021 at 17:41
Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing?
Awarded Nov 16, 2021 at 13:21
MySQL master binlog corruption
Awarded Nov 13, 2021 at 0:31
MySQL Workbench: "ssl is required but the server doesn't support it"
Awarded Nov 12, 2021 at 20:41
PostgreSQL: changing password for a user is not working
Awarded Nov 11, 2021 at 19:56
Oracle no privileges on tablespace USERS
Awarded Nov 11, 2021 at 19:56
SQL Server service - Not Starting With Automatic Startup, "The system cannot find the file specified", but starts fine manually
Awarded Nov 10, 2021 at 20:57
Incorrect comparison of datetime and datetime2
Awarded Nov 10, 2021 at 20:57
Compacting a sequence in PostgreSQL
Awarded Nov 9, 2021 at 17:36
What is the difference between xact_start and query_start in postgresql?
Awarded Nov 9, 2021 at 3:46
1
…
3 4
5
6 7
…
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.