Database Administrators

Popular Question

 Popular Question
Question with 1,000 views. This badge can be awarded multiple times.
Awarded 32172 times.
Mysql search varchar column strategy
Awarded 6 hours ago
MySQL / MariaDB : Many indexes vs. One multi-column index
Awarded 16 hours ago
What are the design alternatives when having multiple “type” tables
Awarded yesterday
How to do a restore of a large postgresql database?
Awarded yesterday
Performance problem using mysql fulltext search
Awarded yesterday
Updating statistics, what about existing execution plans
Awarded yesterday
How to list all constraints of a table in PostgreSQL by schema?
Awarded yesterday
How does MySQL decide what partitions to load into memory?
Awarded yesterday
ALTER PROCEDURE does not alter results [closed]
Awarded yesterday
Postgres replication not cleaning up WAL files
Awarded yesterday
Create maintenance plan using SQL script without using the wizard [duplicate]
Awarded yesterday
AWS RDS Post Optimisation after a huge delete
Awarded yesterday
Migrate a schema structure from one server to another MySQL
Awarded yesterday
Mysql deterministic function, scope?
Awarded yesterday
Can't connect to Database Engine
Awarded yesterday
Wrong sort order using utf8_unicode_ci and swedish characters like ö
Awarded yesterday
MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf
Awarded 2 days ago
How to “flatten” multiple rows with same ID (Oracle 11g) by concatenating **multiple** fields per row?
Awarded 2 days ago
Why am I getting a deadlock for a single UPDATE query?
Awarded 2 days ago
Multiple Instances Of Oracle Or One Instance With Multiple Schemas
Awarded 2 days ago
How to handle -904 Invalid identifier error in oracle store procedure
Awarded 2 days ago
Simple way to use SP_EXECUTESQL for loop through all databases
Awarded 2 days ago
get postgreSQL client computer name
Awarded 2 days ago
Dynamic script to Drop Indices of a specific column
Awarded 2 days ago
Postgres - Multiple commands on table at the same time
Awarded 2 days ago
mongodb sharded cluster configured but not working
Awarded 2 days ago
SQL Server - Data Warehouse large log file, how to safely shrink?
Awarded 2 days ago
How to make inet_server_addr() return localhost in spite of ::1/128
Awarded 2 days ago
Slave DB promoted as Master DB when Master DB is down. New data added on the new master while old master is down
Awarded 2 days ago
How to set AUTHORIZATION on CREATE SCHEMA
Awarded 2 days ago
What causes pt-online-schema-change to slow down the further it gets through a table?
Awarded Jan 13 at 20:07
How to get Kerberos working against a named SQL Server instance in Power BI Report Server?
Awarded Jan 13 at 20:01
All my database on the fail over server showing in “Synchronizing” state
Awarded Jan 13 at 19:40
Problem with sp_Updatestats
Awarded Jan 13 at 17:30
Implicit Conversion of VARCHAR Column to NVARCHAR does not cause expected table scan
Awarded Jan 13 at 17:22
Is there a specific SQL Server 2008 R2 Permission to run DBCC CHECKIDENT?
Awarded Jan 13 at 16:17
PowerShell script to output SQL query results [closed]
Awarded Jan 13 at 16:06
SUM same column twice performance
Awarded Jan 13 at 16:06
Alter table Alter column Performance
Awarded Jan 13 at 15:19
How can I connect to SQL Server from All IPs?
Awarded Jan 13 at 14:56
Is it possible for a client to kill a long-running Postgres query?
Awarded Jan 13 at 14:47
Disk usage of integer column vs boolean column in Postgres
Awarded Jan 13 at 13:07
MySQL 8: Truncate table stuck in `checking permissions` state for minutes
Awarded Jan 13 at 11:27
ALL permission is deprecated and maintained only for compatibility? [closed]
Awarded Jan 13 at 9:20
Why can an Oracle SET UNUSED COLUMN cause internal UPDATE SET X=X and huge log generation?
Awarded Jan 13 at 9:20
Shrink database or DB files not reducing size even after dropping biggest table
Awarded Jan 13 at 8:35
Change Schema Binding for All Views
Awarded Jan 13 at 7:47
PgAdmin 4.14 connection error in cloudSQL : could not send data to server, socket is not connected, could not send ssl negotiation packet
Awarded Jan 13 at 3:33
Update trigger fired before insert trigger upon insert of new row
Awarded Jan 13 at 3:33
Which DB for 1 table with 100 Million rows per year? [closed]
Awarded Jan 13 at 0:32
Does adding non-clustered indexes to Transactional Replication increase latency
Awarded Jan 12 at 22:50
How to enable Oracle Database In-Memory feature in Oracle 11g R2 to reduce report generation time?
Awarded Jan 12 at 22:30
Issue: Data synchronization state of availability database is not healthy
Awarded Jan 12 at 21:27
Efficiently write SELECT queries for tables with lots of columns (not SELECT *)
Awarded Jan 12 at 20:18
SQL PRINT vs SQL EXEC
Awarded Jan 12 at 20:08
Postgresql: Difference between pg_dump and backup/restore?
Awarded Jan 12 at 19:47
What does the GO statement do in SQL Server?
Awarded Jan 12 at 18:56
CSV (UTF-8) to Postgres database (UTF-8), doesn't show äöå characters
Awarded Jan 12 at 18:16
Converting float4 to numeric in PostgreSQL is rounding the values
Awarded Jan 12 at 18:00
How to display values excluding maximum value based on column that is duplicated
Awarded Jan 12 at 14:15
1
2 3 4 5
…
537