Database Administrators

Teacher

 Teacher
Answer a question with score of 1 or more.
Awarded 15319 times.
What is a difference in failover time for SQL Server FCI when database is in Full vs Simple recovery mode
Awarded 11 hours ago
How do I find missing sub-partitions of an index to make main index complete?
Awarded yesterday
SQL Server 2019 Cannot Change Password for sa
Awarded 2 days ago
how sorting nullable number and ones is last
Awarded 2 days ago
Postgres CREATE DATABASE Not Working
Awarded Nov 28 at 18:33
Star Schema from Relational Database
Awarded Nov 28 at 2:42
Oracle DB 19c installation stuck at the very beginning (Info: Checking whether the IP address of the localhost could be determined)
Awarded Nov 27 at 15:08
What are the idiomatic approaches to copying a table (and all of its data) from one server to another?
Awarded Nov 25 at 7:55
What are the idiomatic approaches to copying a table (and all of its data) from one server to another?
Awarded Nov 24 at 23:45
down time while adding read-replica in mysql rds
Awarded Nov 24 at 10:32
How do I shorten validation time?
Awarded Nov 23 at 10:36
PostgreSQL Trigger to keep track of table changes
Awarded Nov 23 at 10:36
OBT (One Big Table) vs Star Schema for Data Warehousing
Awarded Nov 23 at 6:11
OBT (One Big Table) vs Star Schema for Data Warehousing
Awarded Nov 23 at 6:11
How can I fix "Login failed for user sa" error in SQL Server?
Awarded Nov 22 at 4:19
how wsrep_local_index is defined or could be changed?
Awarded Nov 19 at 22:20
What's the order of operations in PostgreSQL?
Awarded Nov 18 at 6:22
MySQL:How to correct a corrupted MySQL binary log on Master server?
Awarded Nov 16 at 19:33
Update column with random values from a list in SQL Server
Awarded Nov 16 at 18:52
Insert gives error code 1366 even though charset is utf8mb4
Awarded Nov 16 at 17:47
Error when using OPENROWSET from a View as a nonsysadmin
Awarded Nov 16 at 11:33
is it possible to rollback only a partition/subpartition?
Awarded Nov 16 at 11:06
Ring Buffer Rollover?
Awarded Nov 14 at 23:57
Error While restoring backup in SSMS
Awarded Nov 14 at 16:05
Domain group hierarchical group membership and SQL Logins mapped to AD groups
Awarded Nov 13 at 20:57
PostgreSQL bug with JSON type?
Awarded Nov 13 at 11:08
Disable redo logs on MariaDB
Awarded Nov 11 at 12:04
Does creating an index on BIT(n) attribute in MySQL make sense?
Awarded Nov 11 at 9:47
Databases: are there universal datatypes?
Awarded Nov 10 at 16:05
Does a SQL Server Log Backup Include Log Records Backed Up in a Previous Full or Differential Backup?
Awarded Nov 10 at 8:50
SQL query to aggregate data from three tables
Awarded Nov 10 at 7:40
Convert varchar into datetime and use date diff on the where clause
Awarded Nov 10 at 4:25
Is there a stronger guarantee of minimal logging when running INSERT INTO [...] WITH (TABLOCK) on a heap than on a B-tree?
Awarded Nov 9 at 20:10
Unable to use cyrillic characters in mysql docker console
Awarded Nov 9 at 18:47
spark-cassandra-connector read throughput unpredictable
Awarded Nov 9 at 14:57
mongodb atlas use secondaries to reduce cpu usage
Awarded Nov 9 at 13:28
Passing arguments to psql
Awarded Nov 8 at 23:58
Change Tracking cleanup
Awarded Nov 8 at 16:48
How can SQL Server's Query Store Reports show data for minute-length intervals, when "Statistics Collection Interval" is set to 1 hour?
Awarded Nov 8 at 14:43
Broken Slave MySQL : How To Fix MySQL Replication (BINLOG) error in the Slave?
Awarded Nov 7 at 10:10
Lost Root privelages in MariaDB 10.6
Awarded Nov 7 at 8:30
On pgAdmin 4, how to basically copy the content of one or two cells?
Awarded Nov 6 at 12:57
mysqlpump --set-gtid-purged=OFF still adds @SESSION.SQL_LOG_BIN=0;
Awarded Nov 5 at 0:21
Mysql 5.7.20 crashes after jemalloc installation
Awarded Nov 4 at 16:50
Could not find a "psql" to execute
Awarded Nov 3 at 14:40
Select data divided in groups evenly distributed by value
Awarded Nov 1 at 1:41
Logon failed for login due to trigger execution
Awarded Oct 31 at 18:57
How to get local MariaDB to be as fast as local PostgreSQL?
Awarded Oct 31 at 14:18
Discrepancy in MySQL Floating Point Precision: Data Rounded When Retrieved With SELECT Query
Awarded Oct 30 at 23:21
PostgreSQL - psql \watch command - how to interrupt on Windows binary distro (EDB)
Awarded Oct 30 at 14:06
no pg_hba.conf entry for host
Awarded Oct 30 at 13:42
Test if any columns are NULL
Awarded Oct 28 at 3:32
Disable auto-start of postgres server on boot (Mac)
Awarded Oct 27 at 14:03
Postgres is stuck when creating a database?
Awarded Oct 27 at 13:55
Aggregate function to return any (first) encountered value
Awarded Oct 27 at 9:35
How can I strip non-numeric characters out of a string?
Awarded Oct 26 at 8:27
monitoring of alert log file
Awarded Oct 24 at 18:32
Combining array_agg and unnest
Awarded Oct 24 at 10:06
What is the difference between views and materialized views
Awarded Oct 24 at 3:50
How import mysqldump .sql file into MySQL 5.7 when exported from MySQL 8
Awarded Oct 22 at 19:08
1
2 3 4 5
…
256

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.