Database Administrators

Revival

 Revival
Answer more than 30 days after a question was asked as first answer scoring 2 or more. This badge can be awarded multiple times.
Awarded 2524 times.
SQL Server for Linux 2019 - Windows Authentication not working
Awarded 10 hours ago
Why can't unused columns and tables be ignored in a recursive CTE
Awarded Nov 23 at 17:11
Is it safe to run parallel innodb single-transaction dumps of individual tables?
Awarded Nov 22 at 13:26
Online Index Rebuild of large table takes exclusive lock
Awarded Nov 20 at 12:05
Name in sys.availability_groups_cluster returns double character length
Awarded Nov 18 at 14:48
How do you use pvkconverter.exe - not working for me?
Awarded Nov 15 at 21:28
PostgreSQL: how to query statistics of a step in pg_agent?
Awarded Nov 15 at 13:17
SQLSTATE[08006] [7] FATAL: the database system is in recovery mode
Awarded Nov 14 at 23:49
All queries waiting for query cache lock
Awarded Nov 14 at 11:25
Disable InnoDB deadlock detection
Awarded Nov 13 at 7:50
mongodb “WriteConcernFailed” on a replica set
Awarded Nov 8 at 14:25
CrystalDiskMark Test Discovers Lopsided Throughput; What Setting Should be Changed?
Awarded Nov 6 at 21:18
How do I debug/set up MariaDB SSL connection?
Awarded Nov 6 at 8:07
How to split a large table in Teradata
Awarded Nov 1 at 5:31
How to format a date field into diferente languages in the same command? (multiple locales)
Awarded Oct 30 at 16:46
AWS RDS Aurora mysql Query Cache
Awarded Oct 27 at 19:38
Efficiently store large list structure in RocksDB so that the data can be retrieved in pages
Awarded Oct 24 at 12:06
In SQL Server, what is "Partitioned Table Parallelism" that is only available in Enterprise Edition?
Awarded Oct 23 at 21:47
IndexOptimize procedure doesn't obey @MaxNumberOfPages when only updating statistics
Awarded Oct 22 at 12:35
Deferrable Foreign Key Constraints
Awarded Oct 20 at 12:50
MySQL crashing randomly
Awarded Oct 16 at 16:05
Instant File Initialization on Shared drive
Awarded Oct 12 at 22:50
How to control how JSON_ARRAYAGG orders results
Awarded Oct 7 at 13:41
is it good to add index on column used in group by clause?
Awarded Oct 6 at 3:15
Influxdb and grafana: howto create series that is the sum of two other series
Awarded Oct 4 at 22:05
Unable to connect to Bitnami Cassandra container from cqlsh
Awarded Sep 28 at 7:15
SQL Server 2019 Service account Local Activation permission
Awarded Sep 26 at 15:34
How to run pg_dump so that it doesn't slow down other connections?
Awarded Sep 25 at 5:56
Use case for hstore
Awarded Sep 21 at 2:20
How to suppress specific warnings in mysql error log when ignoring a table to replicate
Awarded Sep 19 at 16:40
Which permissions are required to view Windows Event Logs in SSMS?
Awarded Sep 19 at 14:15
How to find out why this query is in waiting state?
Awarded Sep 14 at 21:42
Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
Awarded Sep 7 at 18:51
How to delete stored procedures from a database project and have that reflect on the server?
Awarded Sep 1 at 8:27
Use default value instead of inserted null
Awarded Aug 29 at 16:35
Why does mysqldump stop the slave SQL thread for the entire backup?
Awarded Aug 25 at 16:08
What does this error mean "A slave with the same server_uuid/server_id as this slave has connected to the master;"?
Awarded Aug 21 at 15:27
MySQL stuck on "wsrep: initiating replication for write set (-1)"
Awarded Aug 20 at 13:48
MySQL 8.0.x: Discard temporary table left behind during a pre-migration (5.7.x) crash when the parent schema is already dropped
Awarded Aug 20 at 12:50
Is it possible to have MySQL slave outside firewall
Awarded Aug 11 at 20:26
Why do I get "The initial snapshot for publication is not yet available."?
Awarded Aug 8 at 18:41
How to get rid of PGAdmin 'Notifications' panel
Awarded Aug 8 at 9:48
how to add comment when adding column in PostgreSQL
Awarded Aug 8 at 4:51
Why would a single ghost record remain in a few random indexes?
Awarded Aug 6 at 14:05
Time zone conversion in DMS from DB2 to Aurora Postgres
Awarded Aug 2 at 20:36
Insert and Update Queries Log in MySQL
Awarded Aug 1 at 20:17
How do I adjust the table link endpoint in PgAdmin's ERD tool after autogenerating it from an existing database?
Awarded Jul 31 at 23:46
Unable to uninstall Sql Server 2012 Express (With SP1)
Awarded Jul 28 at 13:33
postgresql - Policy to prevent a field from being updated
Awarded Jul 19 at 18:26
MySQL Database import into 5.7 hangs with CLI or with Workbench 6.3 CE
Awarded Jul 17 at 17:33
How do I add a constraint on the UUID type of Postgres to only allow UUID v4?
Awarded Jul 17 at 8:07
Is it possible to resize a blob image?
Awarded Jul 16 at 16:31
How is the information_schema table in trino updated?
Awarded Jul 10 at 14:49
Create JSON object from recursive tree structure
Awarded Jul 10 at 14:04
Which PgBackRest policy for differential backups in PostgreSQL
Awarded Jul 9 at 18:11
Add an arbiter to mongodb ReplicaSet failed
Awarded Jul 7 at 21:26
Where to download bcp command line package for SQL Server 2019?
Awarded Jun 29 at 23:03
What's the best way to use a gist index on tsrange to check if a time occurs after the range?
Awarded Jun 21 at 19:02
A performing monotonic UUID variant, does it make sense?
Awarded Jun 20 at 22:57
Deadlock on two update statements on the same page
Awarded Jun 19 at 2:56
1
2 3 4 5
…
43

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.