Database Administrators

Editor

 Editor
First edit.
Awarded 23489 times.
How to reduce size of a large SQLite database with series data
Awarded 6 hours ago
PostgreSql - Join two tables to extract a combination of three columns
Awarded 19 hours ago
Oracle to Postgres Statement Migration
Awarded 23 hours ago
Restaurant reservations - Tables combinations
Awarded yesterday
MYSQL Stored procedure to fetch entire row from a table
Awarded yesterday
sql querry to check whether multiple entries exists
Awarded yesterday
When a transaction truncate a global temporary table, is that logged in transaction log or error log?
Awarded yesterday
Unable to truncate transaction log, log_reuse_wait_desc - AVAILABILITY_REPLICA
Awarded yesterday
SQL server backup fail “A system assertion check has failed”
Awarded yesterday
How can you split multiple delimited strings of varying sizes into rows?
Awarded 2 days ago
Select with CROSS APPLY runs slow
Awarded 2 days ago
How to determine the size of data being used by a user across tables in a mysql database
Awarded 2 days ago
SQLite subselect
Awarded 2 days ago
string or binary data would be truncated in table '******', column '******'. Truncated value: '******'
Awarded Aug 12 at 17:47
DB2 BOOLEAN type, EXISTS predicate and nullability strange behavior
Awarded Aug 12 at 16:20
ERROR 1064 (42000) You have an error in your SQL syntax during import
Awarded Aug 12 at 10:32
When using class inheritance, can all PKs of the derived tables exist as PKs of the base table?
Awarded Aug 12 at 0:56
Calculate Time in different Row used Oracle sql
Awarded Aug 12 at 0:27
Stopping cascading logical replication
Awarded Aug 11 at 23:30
How can I go about building a relationship with variable but ordered number of columns in a table?
Awarded Aug 11 at 13:51
How to mark a Sybase ASE DB as offline for startup
Awarded Aug 11 at 11:57
Sql Server Express edition - Could not allocate space for object [Table] in database [DB] because the 'PRIMARY' filegroup is full
Awarded Aug 11 at 9:57
The number of daily active users per device. With no dates given [closed]
Awarded Aug 11 at 6:06
How do I kill Oracle DataPump expdp job stuck in DEFINING state?
Awarded Aug 10 at 14:45
Database design and normalization: person roles and localisation information
Awarded Aug 10 at 12:33
(post deleted or otherwise unavailable)
Awarded Aug 10 at 9:30
service broker queue index growing beyond control
Awarded Aug 10 at 9:01
Can I connect mysql client to a mariadb server?
Awarded Aug 9 at 23:41
Why is PostgreSQL not using composite Index on JSONB Fields?
Awarded Aug 9 at 13:17
(post deleted or otherwise unavailable)
Awarded Aug 9 at 6:56
VERY slow lateral join on relatively small database
Awarded Aug 8 at 22:40
SQL Server Unique Constraint on two columns with an exception
Awarded Aug 8 at 13:40
PostgreSQL 9.2 CDC implementation
Awarded Aug 7 at 16:40
PL/SQL Statment ignored
Awarded Aug 7 at 7:42
Oracle Historical Session Information
Awarded Aug 7 at 2:26
How to bulk insert with scope_identity in sql server
Awarded Aug 6 at 23:25
What are some good SQL Server Performance Metrics from System Views?
Awarded Aug 6 at 22:51
Is there a portable profile/well defined subset of SQL/PSM?
Awarded Aug 6 at 8:26
Correlated subquery with common table expressions in SQLite
Awarded Aug 6 at 5:26
Sums from each day for 4 weeks
Awarded Aug 6 at 0:17
MySQL router on server with tomcat memory leak
Awarded Aug 5 at 16:36
Database schema design implementation feedback
Awarded Aug 5 at 15:35
Design read and write user permissions on an entity
Awarded Aug 5 at 12:27
Why does MySQL think I'm using SRID 1?
Awarded Aug 5 at 0:20
Oracle index analyze stats - managed by whom?
Awarded Aug 4 at 16:04
modelling bill split app schema
Awarded Aug 4 at 15:56
Putting data into a 3nf database: do you normalize before or after data input?
Awarded Aug 4 at 12:49
SSMS IntelliSense not working with sa user
Awarded Aug 4 at 7:58
(post deleted or otherwise unavailable)
Awarded Aug 4 at 7:30
Oracle multiple databases only able to access one database
Awarded Aug 4 at 6:27
Trigger having issues on partioned table execution - Postgres - 11
Awarded Aug 4 at 5:35
How can I dump the schema of a SQL server database on Linux?
Awarded Aug 4 at 2:07
Queries of MySQL from Java are executed serially from multiple threads
Awarded Aug 3 at 21:01
How to solve Vendor Code 17002 when connecting to a remote Oracle database?
Awarded Aug 3 at 20:40
What is Oracle's Window Buffer Operator?
Awarded Aug 3 at 17:56
(Deadlock) Select Query Causes Insert Query to be Blocking in Transaction
Awarded Aug 3 at 15:40
MySQL SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded
Awarded Aug 3 at 12:25
.net core 3.1 SQL server gives invalid operation for async calls
Awarded Aug 3 at 10:41
MYSQL Error: Incorrect usage of UNION and ORDER BY?
Awarded Aug 2 at 19:35
find out why table insert is slow in postgres cluster
Awarded Aug 2 at 18:06
1
2 3 4 5
…
392