Database Administrators

Help Center > Badges > Teacher

 Teacher
Answer a question with score of 1 or more.
Awarded 11806 times.
node unable to join a galera cluster; it fails during state transfer
Awarded 8 hours ago
Using SQL Server with BitLocker
Awarded 14 hours ago
How to use left join with a subquery
Awarded 18 hours ago
#1146 table 'db.tablename' doesnt exist
Awarded yesterday
parse rs.status() output to display one secondary node for mongodump destination
Awarded yesterday
No Maintenance Plans Folder in SQL Studio 2008 R2
Awarded yesterday
Can't create a table with the same name I deleted before
Awarded yesterday
Why does “CREATE TABLE IF NOT EXISTS” lock a table?
Awarded yesterday
Failed to allocate BUFs during DBCC CHECKDB
Awarded 2 days ago
MySQL - How to check for a value in all columns
Awarded 2 days ago
Select previous value in row without using a subquery
Awarded 2 days ago
Deleting all rows from INNER JOINed 3 different tables
Awarded 2 days ago
Logins aren't syncing across Availability Groups
Awarded 2 days ago
Asked to Not Use Transactions and to Use A Workaround to Simulate One
Awarded Sep 15 at 12:15
How to pivot on multiple columns in SQL Server?
Awarded Sep 15 at 6:45
How to handle MySQL database connections/pooling from Lambda -> RDS with Node
Awarded Sep 15 at 6:00
Differences between EDU and thread
Awarded Sep 14 at 16:35
Asked to Not Use Transactions and to Use A Workaround to Simulate One
Awarded Sep 14 at 15:45
Asked to Not Use Transactions and to Use A Workaround to Simulate One
Awarded Sep 14 at 6:20
Configuring Availability group between Two SQL Server Failover Cluster Instances
Awarded Sep 14 at 4:30
Asked to Not Use Transactions and to Use A Workaround to Simulate One
Awarded Sep 13 at 22:45
Creating a temporary copy of a table with partitions
Awarded Sep 13 at 12:45
What is SQL Server doing in the background once a Backup/Restore is complete?
Awarded Sep 13 at 9:50
pgAgent service for PostgreSQL does not run
Awarded Sep 13 at 8:40
How to export oracle database version 12.1.0.2.0 with expdp Release 12.2.0.1.0
Awarded Sep 12 at 17:40
OpenProject pg_restore - input file does not appear to be a valid archive
Awarded Sep 12 at 17:05
How to do hierarchical queries without CTE tables or recusive queries in Snowflake? (parent, child relationships)
Awarded Sep 12 at 8:40
error “--secure-file-priv option” when save selection to csv
Awarded Sep 11 at 23:10
self-joins in recursive CTE: `recursive reference must not appear more than once`?
Awarded Sep 11 at 16:40
SSL connection to AWS RDS Postgresql instance from windows client
Awarded Sep 11 at 15:35
Unexpected gaps in IDENTITY column
Awarded Sep 11 at 13:30
Covering and overlapping constraints
Awarded Sep 11 at 13:05
Select the students that are enrolled in both the courses
Awarded Sep 11 at 11:45
DynamoDB: How to model data that's shared and queried by all users?
Awarded Sep 10 at 22:00
Can I provide a default for a left outer join?
Awarded Sep 10 at 14:25
Unable to output data from tables in pgAdmin4 due to missing oid operator
Awarded Sep 10 at 10:10
SQL Profiler Audit Logout duration 18446744073709548
Awarded Sep 10 at 2:05
What order does Oracle's EXIST condition compare the sub-query results?
Awarded Sep 9 at 16:00
SQL Server - How does contained database user password expiration work?
Awarded Sep 9 at 12:40
SQL Managed Instance - Cross Subscription Restores/Migration
Awarded Sep 9 at 12:35
Create Oracle DB LINK to a database with no DB_DOMAIN
Awarded Sep 8 at 3:05
How to determine cost/benefit of adding an index?
Awarded Sep 6 at 19:45
How to list all constraints of a table in PostgreSQL?
Awarded Sep 6 at 14:30
mysql inner join too slow
Awarded Sep 6 at 13:25
Startup failing with ORA-14694 after running utl32k.sql in upgrade mode
Awarded Sep 5 at 19:00
Could not allocate a new page for database because of insufficient disk space
Awarded Sep 5 at 14:45
I really can't get rid of these conditional statements in mysqldump?
Awarded Sep 5 at 14:10
Accidentally turned down SQL memory too low to log in, how do I fix?
Awarded Sep 5 at 13:00
Can I use table aliases in a MySQL DELETE statement?
Awarded Sep 5 at 12:40
SQL Server 2017 login language display is wrong
Awarded Sep 4 at 21:25
SQL Managed Instance - Cross Subscription Restores/Migration
Awarded Sep 4 at 19:45
Deadlock on partitioned table
Awarded Sep 4 at 12:45
How can I determine which permissions needs to be assigned to the newly created login?
Awarded Sep 4 at 12:10
How to change the SQL Server Backup file (.bak) file default icon?
Awarded Sep 4 at 0:25
I need the reason why we should not install SQL server on the domain controller
Awarded Sep 3 at 18:45
Oracle 19c GI Install on OL7 : ASM disks stamped via AsmLib not getting discovered via GridSetup.sh
Awarded Sep 3 at 18:45
Mongodb list current connection
Awarded Sep 3 at 17:45
How can we pass default value as null to Associative Array in Procedure?
Awarded Sep 3 at 12:30
Prevent SSMS from seeing the server's file system
Awarded Sep 3 at 12:15
REPLACE(orig,match,replacement) multiple matches in one query
Awarded Sep 3 at 9:40
1 2 3 4 5 … 197