Database Administrators

Teacher

 Teacher
Answer a question with score of 1 or more.
Awarded 12818 times.
Determine consecutive occurrences of values
Awarded 12 hours ago
Get top 5 students for each class in many-to-many relationship
Awarded 13 hours ago
string or binary data would be truncated in table '******', column '******'. Truncated value: '******'
Awarded 18 hours ago
Could not start WAL streaming, replication slot is active
Awarded 20 hours ago
Inserting in PostgreSQL Foreign Table Violates Primary Key Constraint10
Awarded yesterday
MSSQL 2016 - Restore SSISDB from MSSQL 2012
Awarded yesterday
Pentaho Data Integration: 'Execute SQL statement' to create trigger
Awarded yesterday
SQL Server Unique Constraint on two columns with an exception
Awarded yesterday
How postgresql full text search disable file parser?
Awarded Aug 10 at 6:30
Aurora MySQL 5.7 randomly fails
Awarded Aug 10 at 1:55
Aurora MySQL 5.7 randomly fails
Awarded Aug 10 at 1:55
Complex SQL Agent Job
Awarded Aug 8 at 3:18
“ORA-24454: client host name is not set” when connecting from Ubuntu instance on AWS EC2
Awarded Aug 7 at 15:22
How to import export.sql in sql developer?
Awarded Aug 7 at 13:20
Can't start Oracle after Virtual Machine restore
Awarded Aug 7 at 6:36
Company supplied data list, with customer additions
Awarded Aug 7 at 3:36
Oracle Historical Session Information
Awarded Aug 7 at 3:31
Postgres list constraints that use a stored procedure
Awarded Aug 5 at 23:42
How to copy Azure SQL database to on-premises SQL Server daily for reporting?
Awarded Aug 5 at 22:32
SqlPackage does not pick up variables from profile
Awarded Aug 4 at 15:48
How to optimize an ordered date range query with several OR filters (for streaming)?
Awarded Aug 4 at 13:26
How to install Oracle's sqlplus on a Mac?
Awarded Aug 4 at 6:03
pg_restore: [archiver] did not find magic string in file header
Awarded Aug 4 at 3:17
'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Awarded Aug 3 at 22:05
The connection is broken and recovery is not possible - sql server error
Awarded Aug 3 at 15:26
Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
Awarded Aug 3 at 12:18
Connecting SQL Anywhere with Sybase database file on local computer
Awarded Aug 3 at 11:32
Are snapshots generated for each sub query inside a Postgres READ_COMMITTED transaction?
Awarded Jul 31 at 21:16
Pushing or appending to JSON array in PostgreSQL 9.4
Awarded Jul 31 at 15:07
Suppress SQL Server Management Studio auto complete
Awarded Jul 31 at 10:18
How to rollback database change in production after few hours or days
Awarded Jul 30 at 11:50
Mysql 8: count(*) on INT primary is 13500 times slower than supposed to be. any innodb dev here?
Awarded Jul 29 at 22:31
Trouble connecting to Oracle database with sqlplus and OS authentication
Awarded Jul 29 at 6:19
SQL Server - quite big data flow - Disk became the bottleneck … what now?
Awarded Jul 29 at 4:41
Not able to restore a backup to SQL Server 2019
Awarded Jul 28 at 18:42
Can't connect to Azure SQL with error 18456
Awarded Jul 27 at 13:26
Postgres foreign key to a foreign key
Awarded Jul 27 at 7:00
Formatting Text Field As HH:MM:SS
Awarded Jul 27 at 7:00
SQL Server Web transaction replication to Azure SQL
Awarded Jul 26 at 16:19
How to use COUNT with multiple columns?
Awarded Jul 26 at 2:33
Prevent explicit insert into serial columns
Awarded Jul 26 at 0:25
How should I best name my timestamp fields?
Awarded Jul 25 at 21:50
How to pivot a column showing its content as new columns
Awarded Jul 25 at 12:04
(post deleted or otherwise unavailable)
Awarded Jul 25 at 9:01
I am trying to achieve a Disaster recovery for Mongo DB
Awarded Jul 24 at 13:22
Powershell Invoke-Sqlcmd Replacing £ with?
Awarded Jul 24 at 13:22
how to nest query with avg and sum group by outer in MySQL 5.7
Awarded Jul 24 at 11:51
How to remove database from explorer after deleting .MDF and .ldf files
Awarded Jul 24 at 10:09
Innodb: after 48 hours of optimizing 10mb/sec write speed
Awarded Jul 24 at 9:31
How to reduce size of a large SQLite database with series data
Awarded Jul 24 at 0:37
why does Postgres raise a not-null constraint error on a serial column?
Awarded Jul 23 at 21:36
mssql server set up fail with errror on debian linux
Awarded Jul 23 at 20:17
How to remove dbcreator server role?
Awarded Jul 23 at 16:03
Error: Unable to write inside TEMP environment variable path
Awarded Jul 23 at 14:25
Why am I getting “Snapshot isolation transaction aborted due to update conflict”?
Awarded Jul 23 at 14:25
How do I find the next saturday in MySQL
Awarded Jul 22 at 14:55
Error: MySQL shutdown unexpectedly
Awarded Jul 22 at 12:56
pgadmin dashboard is gone
Awarded Jul 22 at 10:15
Cardinality estimation on tables with large cardinality variance between keys
Awarded Jul 22 at 7:41
save/export PGAdmin server list configuration settings
Awarded Jul 21 at 13:25
1
2 3 4 5
…
214