Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.
Awarded 3213 times.
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
Oracle: Non key-preserved table should be
Awarded Oct 29, 2021 at 20:02
ON CONFLICT ON CONSTRAINT fails saying constraint doesn't exist
Awarded Oct 28, 2021 at 23:55
set session - custom variable to store user id
Awarded Oct 27, 2021 at 1:57
Why am I getting a deadlock for a single UPDATE query?
Awarded Oct 26, 2021 at 12:08
Does creating View cause an overhead to DB?
Awarded Oct 19, 2021 at 17:42
Querying True Physical Database File Sizes
Awarded Oct 15, 2021 at 20:17
Analyze memory usage of PostgreSQL – why is it growing constantly?
Awarded Oct 15, 2021 at 20:17
Why is GetDate AND GETDATE() AT TIME ZONE 'GMT Standard Time' returning the wrong time?
Awarded Oct 10, 2021 at 13:32
With a multi column non clustered index, and the SELECT on middle column, why does SQL server query this index rather than scanning the table?
Awarded Oct 8, 2021 at 5:21
postgresql replication - pg_stat_replication is showing empty columns
Awarded Sep 22, 2021 at 4:46
GROUP BY needs ORDER BY NULL to avoid filesort
Awarded Sep 16, 2021 at 22:56
TempDB will not shrink. No Open Transactions
Awarded Sep 16, 2021 at 11:30
How do you tune innodb_read_io_threads?
Awarded Sep 16, 2021 at 8:21
Cannot alter MYSQL Table (stuck in a invalid default value loop)
Awarded Sep 14, 2021 at 11:32
Seemingly identical WHERE clauses returning different results
Awarded Sep 11, 2021 at 18:57
tune WHERE datediff
Awarded Sep 11, 2021 at 16:03
If sp_ExecuteSql creates a new session, how come I can access a local temp table created (prior to it's execution) outside of the dynamic SQL?
Awarded Sep 9, 2021 at 13:57
Compare a date and a timestamp with time zone with now() in the same query?
Awarded Sep 9, 2021 at 9:10
MySQL: Why is auto_increment limited to just primary keys?
Awarded Sep 9, 2021 at 9:10
Get the last 5 distinct values for each ID
Awarded Sep 7, 2021 at 12:20
Remote queries at SNAPSHOT isolation level
Awarded Sep 3, 2021 at 14:22
pg_dump without postgresql
Awarded Sep 2, 2021 at 5:21
SQL Server 2016 suddenly produces Error:402,State:1,Class:16 updating a sproc with DATETIME/DATE/TIME arithmetic, that was fine before
Awarded Aug 30, 2021 at 14:26
Postgres get function owner
Awarded Aug 28, 2021 at 5:36
1
…
4 5
6
7 8
…
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.