Skip to main content
Database Administrators

Teacher

 Teacher
Answer a question with score of 1 or more.
Awarded 15635 times.
Prevent users from sending an email attachment in sql server
Awarded Feb 22 at 12:49
Simple query on sys.dm_db_partition_stats is running for 30 minutes
Awarded Feb 22 at 10:05
PostgreSQL16 on Windows - Clean up pg_wal archive location
Awarded Feb 21 at 19:34
How to determine if it is necessary to increase the sga and the pga in Oracle database
Awarded Feb 21 at 19:34
Open files in MySQL increasing over time, eventually causing it to stop accepting connections
Awarded Feb 21 at 19:10
Optimizing regex based query in sqlite
Awarded Feb 21 at 19:10
Generating MD5 Hash for NVARCHAR and VARCHAR columns across different databases
Awarded Feb 21 at 18:58
How do you export a database schema from SQL Server Management Studio to Excel?
Awarded Feb 21 at 15:41
SSMS table properties show an exception for Index space on every table
Awarded Feb 20 at 20:18
how to get the email address from inserted data as the recipient in sp_send_dbmail
Awarded Feb 20 at 17:12
Proper *smart* shutdown of PostgreSQL server for PGDG apt packages under Ubuntu/Debian?
Awarded Feb 20 at 14:48
Clarifications on Maintenance jobs & CDC on upgrade to ENTERPRISE EDITION
Awarded Feb 20 at 14:43
How to query two tables and get the rows from one mask the ones from the other?
Awarded Feb 19 at 22:31
The mariadbd process is at over 140% CPU utilisation despite a high innodb_buffer_pool_size value
Awarded Feb 17 at 18:06
SSAS Configuration Question
Awarded Feb 17 at 14:46
Select last record of every hour, but time is not precise
Awarded Feb 16 at 18:55
Why does Keys folder not show all Keys from the Columns folder?
Awarded Feb 16 at 3:06
Moving records between tables in CockroachDB is taking too long
Awarded Feb 15 at 12:12
DESCRIBE TABLE in databricks piped into dataframe
Awarded Feb 15 at 4:03
(post deleted or otherwise unavailable)
Awarded Feb 13 at 13:10
How to drop all connections to a specific database without stopping the server?
Awarded Feb 12 at 5:08
Stop sqlite resetting autoincrement on primary key
Awarded Feb 10 at 20:26
How to get pg_locks related to a specific database in Postgres?
Awarded Feb 9 at 12:53
Convert numbers to words | Spell out DECIMAL USD 1259.75 as 'One thousand two hundred fifty-nine dollars and seventy-five cents'
Awarded Feb 9 at 7:17
Create sequence based on the value of another column
Awarded Feb 6 at 11:42
MySQL Server 8.0 - Increase innodb_buffer_pool_size
Awarded Feb 6 at 1:00
Exclude certain schema along with unnamed constraints in SSDT
Awarded Feb 5 at 23:15
Query to find when a specific current value changed
Awarded Feb 3 at 12:34
No longer able to re-order custom groups in Microsoft Access navigation pane
Awarded Feb 2 at 12:09
How to compact the current MS Access database from VBA function
Awarded Feb 1 at 6:35
Communicating from a SQL Server 2022 to a SQL Server 2008 over linked server
Awarded Jan 31 at 20:05
Unpredictable performance of queries against snapshot
Awarded Jan 31 at 13:18
SQL Server Replication :: Dedicated Distributor Hardware Requirements
Awarded Jan 30 at 12:17
How to grant database creation privilege to a user in MySQL
Awarded Jan 29 at 21:26
How can I use an environment variable in a Postgres function?
Awarded Jan 29 at 7:40
Any ideas on how to parallelize mysql_upgrade?
Awarded Jan 28 at 14:40
xlog flush request is not satisfied in log files
Awarded Jan 27 at 19:06
SQLite - Update of a field in two steps without variable (SpatiaLite)
Awarded Jan 27 at 8:48
MariaDB - MySQL - ALL-DB Import - Table 'user' already exists
Awarded Jan 26 at 16:43
Management Studio all buttons disabled
Awarded Jan 26 at 13:32
pg_upgradecluster fails with 'tablespace directory "" does not exist' error
Awarded Jan 25 at 20:33
How can I optimize a recursive CTE inside a IVTF?
Awarded Jan 24 at 22:46
Count business days between 2 dates in postgreSQL
Awarded Jan 24 at 20:56
How can I convert integer value from query_hash_s in Azure Log Analytics to a VARBINARY(64) for sys.dm_exec_sql_text?
Awarded Jan 24 at 18:47
List all the MS SQL Server Objects ->LinkedServers->Providers using SQL
Awarded Jan 24 at 16:09
Is there a native(none-web) GUI client of pgadmin4?
Awarded Jan 24 at 7:34
ReFS Vs NTFS for SQL Server 2019, server 2019
Awarded Jan 22 at 17:41
postrges on conflict update with all columns as unique constraint
Awarded Jan 21 at 18:03
Are the MariaDB and MySql drivers interchangeable when connecting to a MySQL backend Aurora cluster?
Awarded Jan 20 at 5:51
Restoring partitioned table data causes error in PostgreSQL
Awarded Jan 20 at 4:36
How to control how JSON_ARRAYAGG orders results
Awarded Jan 19 at 8:56
Can I stick with VARCHAR(255) instead of VARCHAR(191) when converting database from UTF8 to UTF8MB4?
Awarded Jan 18 at 23:46
JNA Link failure and JMX unable to receive remote Connections and Out of memory error after running cassandra command on Windows
Awarded Jan 18 at 20:03
My Galera Cluster does not connect across AWS regions
Awarded Jan 18 at 14:51
How do I resolve this python runtime error in Azure SQL Managed Instances?
Awarded Jan 17 at 19:12
Hibernate Query Running Slow
Awarded Jan 17 at 14:08
Managing the order of aggregation in Postgres
Awarded Jan 17 at 10:56
pg_restore: error: could not read from input file: end of file
Awarded Jan 17 at 4:06
Getting last modification date of a PostgreSQL database table
Awarded Jan 17 at 2:19
MySQL tables randomly dropped but .ibd files still exists
Awarded Jan 16 at 21:10
1 2 3
4
5
…
261