Skip to main content
Database Administrators

Teacher

 Teacher
Answer a question with score of 1 or more.
Awarded 15635 times.
How can I save the job result to a file?
Awarded Jan 16 at 16:07
Obtain different random() values with generate_series() in PostgreSQL
Awarded Jan 16 at 11:42
How to recompile all stored procedures and table valued functions in SQL Server database?
Awarded Jan 15 at 19:48
Is it bad practice to have a "most_recent" boolean column in addition to a "create_at" timestamp column to track the latest version of a record?
Awarded Jan 14 at 9:17
Is it bad practice to have a "most_recent" boolean column in addition to a "create_at" timestamp column to track the latest version of a record?
Awarded Jan 14 at 2:57
What does GRANT CONTROL on a schema do in MSSQL?
Awarded Jan 12 at 22:20
How to start Neo4j on Azure
Awarded Jan 12 at 7:42
Limit of psql_history
Awarded Jan 11 at 7:26
how to let dbeaver to highlight sql error for easier development process
Awarded Jan 10 at 13:57
Move log file without taking database offline
Awarded Jan 10 at 2:42
Unable to fully drop a database snapshot
Awarded Jan 10 at 2:42
Is it possible to run multiple versions of MySQL Workbench?
Awarded Jan 9 at 16:27
Is it possible to run multiple versions of MySQL Workbench?
Awarded Jan 9 at 16:27
How can we analyze everything an application does in SQL Server?
Awarded Jan 8 at 20:04
UnShrunk SQL Server database restore which is larger than available disk space
Awarded Jan 8 at 14:40
How to see list of databases in Oracle?
Awarded Jan 8 at 10:09
(post deleted or otherwise unavailable)
Awarded Jan 6 at 11:47
ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT
Awarded Jan 5 at 12:28
MariaDB restore error - ERROR 1556 (HY000) at line 2562: You can't use locks with log tables
Awarded Jan 5 at 0:06
How to Fetch A Record If Shipping And billing Address are Different
Awarded Jan 4 at 16:27
Mysql same DB, same query, different users - different error messages
Awarded Jan 4 at 5:55
Execute a stored procedure before each query for mysql
Awarded Jan 3 at 10:11
Does MariaDB or MySQL implement the VALUES (expression) table value constructor?
Awarded Jan 3 at 4:46
Understanding SQL Server INSTALLSQLDATADIR and Database File Placement
Awarded Jan 1 at 16:19
Backup TO URL S3
Awarded Jan 1 at 15:09
MySQL Tennis Ladder View Creation Question
Awarded Dec 31, 2023 at 14:02
Database Log Reuse Wait shows AVAILABILITY_REPLICA but database is no longer part of an availability group
Awarded Dec 30, 2023 at 2:34
Does Aurora Serverless support Babelfish?
Awarded Dec 29, 2023 at 16:07
CASCADE DELETE per statement
Awarded Dec 29, 2023 at 12:21
How to connect from MS SSMS to PostgreSQL database?
Awarded Dec 28, 2023 at 17:11
3 tables with many to many relationships
Awarded Dec 28, 2023 at 14:25
How to set up a connection in Pentaho Kettle for Oracle using a SERVICE NAME instead of SID?
Awarded Dec 28, 2023 at 6:21
why does mysqldump restore to a smaller size?
Awarded Dec 27, 2023 at 18:36
The recovery model cannot be changed to SIMPLE when any files are subject to a RESTORE PAGE operation
Awarded Dec 27, 2023 at 10:04
Difference between logical and physical reads/writes
Awarded Dec 26, 2023 at 16:35
pg_restore using PostGIS/PostgreSQL Dump Changes Data in Geography Column
Awarded Dec 26, 2023 at 5:51
SQL Server 2019 Always On - Ensure that cluster name object (CNO) is granted permissions to the Secure DNS Zone
Awarded Dec 25, 2023 at 13:17
Return int value from boolean field in SQL select
Awarded Dec 24, 2023 at 4:57
Mysql Workbench crashing when connecting
Awarded Dec 23, 2023 at 3:26
Does dropping a Postgres table cascade to materialized views that depend on it?
Awarded Dec 23, 2023 at 2:32
MySQL Processlist Seems to Show Incorrect User When Running a Custom Function
Awarded Dec 22, 2023 at 10:25
SSIS Script transform package won't compile when deployed to dev [Visual Studio 2017]
Awarded Dec 22, 2023 at 0:10
How to use floating-point storage for time data type
Awarded Dec 21, 2023 at 11:46
Can a PostgreSQL database partition be re-attached after it has been detached?
Awarded Dec 21, 2023 at 0:04
Can mysqldump dump triggers and procedures?
Awarded Dec 18, 2023 at 21:57
NT SERVICE\MSSQLSERVER cannot be found to add as user for file permissions
Awarded Dec 15, 2023 at 17:56
PostgreSQL - 30000 row updates, setting non-indexed boolean column to 'true' takes hours
Awarded Dec 15, 2023 at 11:40
Oracle DB 19c installation stuck at the very beginning (Info: Checking whether the IP address of the localhost could be determined)
Awarded Dec 15, 2023 at 9:47
Is it possible to track a function's dependencies in Postgres?
Awarded Dec 15, 2023 at 0:42
Variadic functions and composite types
Awarded Dec 14, 2023 at 10:27
AWS Blue/Green stuck at "Replica creation is canceled due to external replication"
Awarded Dec 13, 2023 at 21:47
Intarray is available but can't seem to be able to use the icount function
Awarded Dec 13, 2023 at 21:47
Oracle Warning in Alert Log Regarding PGA_AGGREGATE_LIMIT
Awarded Dec 13, 2023 at 9:34
SQL Server DWH architecture question
Awarded Dec 12, 2023 at 10:48
SQL Server 2022 setup silently closes with no clue
Awarded Dec 12, 2023 at 9:42
Single-tenant SQLite vs Postgres + SQLite
Awarded Dec 11, 2023 at 20:04
Cannot connect to MongoDB router in sharded cluster
Awarded Dec 11, 2023 at 17:08
How to list available users in PostgreSQL having only the data directory?
Awarded Dec 11, 2023 at 7:17
Access to folder is denied (log shipping)
Awarded Dec 9, 2023 at 22:42
PostgreSQL 16, pg_dumpall Restore
Awarded Dec 9, 2023 at 5:46
1
…
3 4
5
6 7
…
261