Database Administrators

Scholar

 Scholar
Ask a question and accept an answer.
Awarded 22660 times.
SQL error 1677 cannot be converted from type 'datetime' to type 'varchar(255)'
Awarded 4 hours ago
Position of entry in sqlite ordered table
Awarded 12 hours ago
Is it possible to run a trigger on Table Creation in MySQL
Awarded yesterday
Is it possible to send meta-commands to PostgreSQL through Unix TCP socket?
Awarded yesterday
How To fix this Trigger in mysql? [closed]
Awarded yesterday
Non-deterministic performance of query on select, from 1s to 60s on table with 1 billion rows
Awarded 2 days ago
Using CName to point to the Availability Group listener
Awarded 2 days ago
Calculating Average Value of JSONB array in Postgres
Awarded 2 days ago
Get a count of consecutive dates
Awarded Jul 30 at 5:26
Importing a 16 GB MySQL file silently fails
Awarded Jul 29 at 22:05
How do I restore a database using MongoDB 5.0 CLI?
Awarded Jul 29 at 12:06
SQL Server Installation for a Distributed Availability Group
Awarded Jul 28 at 18:07
Is the database design alright? And I'm quite lost with the admin entity here
Awarded Jul 28 at 2:31
MSSQL Merge 3 hierarchy tables
Awarded Jul 27 at 22:03
Multiple JOINs returning only the last referenced table
Awarded Jul 27 at 21:06
Postgres LISTEN transaction prevents auto-vacuum from clearing dead tuples
Awarded Jul 27 at 17:06
Authentication relying on mysql_native_password seems to also check for Linux user?
Awarded Jul 27 at 14:50
Count number of occurences per location per hour in PostgreSQL
Awarded Jul 27 at 12:47
MySQL 8 insert values into selected columns only
Awarded Jul 27 at 2:56
Procedure insert into another table using cursor
Awarded Jul 26 at 21:05
ALTER TABLE statements not replicating in all tested scenarios - MariaDB
Awarded Jul 26 at 15:18
MySQL dump to MariaDB issue with collation
Awarded Jul 26 at 14:51
Give a user access to restore a database that they are owner on without the server role dbcreator
Awarded Jul 26 at 12:17
SQL Server 2019: Two Aliases point to same instance
Awarded Jul 25 at 20:26
How to get Full Plan in Oracle?
Awarded Jul 25 at 9:57
Creating Tables with the same table names from other databases doesn't have any bad effects?
Awarded Jul 24 at 6:05
Postgresql group by aliased jsonb field
Awarded Jul 23 at 16:25
Creatin Products Database with Multiple Color Variations
Awarded Jul 23 at 10:04
Just delete 50.000.000 of rows on a PostgreSQL table and DB still very slow
Awarded Jul 23 at 0:17
Creating a trigger to update one table's row based on another update from a different table's row
Awarded Jul 22 at 23:21
Strange replication failure on date field under MySQL 5.7
Awarded Jul 22 at 20:08
Postgres: Faster query when adding useless JOIN
Awarded Jul 22 at 14:42
How to rename a column name which has been created by a math function in mysql? Using ALTER TABLE is giving ERROR: 1064 (42000)
Awarded Jul 22 at 13:46
Seemingly simple query with unexpected execution time
Awarded Jul 22 at 12:36
ODI remove auto lock when object / datastore is opened
Awarded Jul 22 at 0:55
How to always return a row when empty result and using the IN clause with arrays
Awarded Jul 21 at 20:26
row level security using roles in SQL Server
Awarded Jul 21 at 19:27
Why is MySQL InnoDB table copied despite using ALGORITHM=INPLACE for ALTER TABLE
Awarded Jul 21 at 13:10
Mysql 8 which linux / Unix Distro would have better performance (2021 topic) [closed]
Awarded Jul 21 at 4:34
Why DataGrip automatically creates Foreign Key relation when 'table_id' column is added
Awarded Jul 20 at 10:43
MySQL 5.7.34 not disabling STRICT_TRANS_TABLES whatever I do
Awarded Jul 19 at 17:34
SSRS second entry never shows up in scale out deployment screen
Awarded Jul 19 at 12:35
Index Drop for Partial Overlap?
Awarded Jul 19 at 5:55
Error reading data from MySQL table 1227 (42000): Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
Awarded Jul 18 at 14:50
Postgres query using index does never finish
Awarded Jul 18 at 13:47
Reason for failed query plan executions in SQL Server
Awarded Jul 18 at 6:50
Tables that Link To Many Other Tables (but only one at any time per record) [closed]
Awarded Jul 16 at 17:35
PostgreSQL 11 - Can I turn a schema into the wild west?
Awarded Jul 16 at 15:07
how to get a single row based on my condition
Awarded Jul 16 at 13:56
Distribute Guests over Rooms Evenly
Awarded Jul 16 at 13:35
Performance issues using temporary tables
Awarded Jul 16 at 10:51
Left Outer Join possible?
Awarded Jul 16 at 9:33
How to use application lock in SQL server from two databases
Awarded Jul 16 at 7:03
Is there a mysql feature to allow parallel replication per query?
Awarded Jul 16 at 6:07
Update Rows From Table If Table Exists Without Using sp_executesql
Awarded Jul 16 at 1:08
Restore a postgres cluster from files
Awarded Jul 15 at 20:55
PostgreSQL - How do I get all the values from a JSONB search on a nested object?
Awarded Jul 15 at 19:43
Is it possible to execute a Postgresql trigger under owner security context?
Awarded Jul 14 at 22:17
Several Postgres partitioning questions (hierarchical partitioning, HASH, PK order)
Awarded Jul 13 at 17:33
How to get currently used SSL certificate thumbprint from MSSQL
Awarded Jul 13 at 8:56
1
2 3 4 5
…
378

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.