DBAs Stack Exchange

A Q&A site for database professionals who wish to improve their database skills and learn from others in the community

[DBAs Stack Exchange @StackDBAs]

Mirroring Databases in MySQL https://t.co/CT0EYFVr2Q #mysql

[DBAs Stack Exchange @StackDBAs]

Is it possible to create AWS RDS as replication from external server? https://t.co/Le2YL3JP0c #mysql

[DBAs Stack Exchange @StackDBAs]

Pair top-level key with nested value from jsonb document https://t.co/z6SDyGBxQz #postgresql

[DBAs Stack Exchange @StackDBAs]

ROW_FORMAT - COMPRESSED vs COMPACT vs DYNAMIC https://t.co/lzgEjJy5og #mysql

[DBAs Stack Exchange @StackDBAs]

Why does sys.fn_xe_file_target_read_file require an explicit cast on datetime2 column? https://t.co/fJV76T5l2f #sqlserver

[DBAs Stack Exchange @StackDBAs]

Can you answer this? ORA-01157: cannot identify/lock data file 201 https://t.co/rugBI4bq5C #oracle

[DBAs Stack Exchange @StackDBAs]

using ON UPDATE for non-timestamp columns https://t.co/PGYhIQFiOH #mariadb

[DBAs Stack Exchange @StackDBAs]

Recover registered servers in SQL Server Management Studio 2012 https://t.co/hGSdYVkHyL #sqlserver2008r2

[DBAs Stack Exchange @StackDBAs]

Oracle: Viewing settings for DBMS_NETWORK_ACL_ADMIN ACL? https://t.co/MtiuZX7zEd #oracle

[DBAs Stack Exchange @StackDBAs]

What are these single letter SQL keywords? https://t.co/azoAlFfCs4 #postgresql

[DBAs Stack Exchange @StackDBAs]

SQL server Cardinality Estimation for LIKE query https://t.co/qJO4uUstT7 #sqlserver

[DBAs Stack Exchange @StackDBAs]

Update fails on linked server after upgrading to SQL Server 2022 https://t.co/IO9NzEAAI7 #sqlserver

[DBAs Stack Exchange @StackDBAs]

Can you answer this? Do hstore and jsonb have the same plumbing internally? https://t.co/g6fHucTTev #postgresql

[DBAs Stack Exchange @StackDBAs]

SQL equivalent to return value from WHERE EXISTS when unable to JOIN https://t.co/rwN2sdj5eZ #sqlserver

[DBAs Stack Exchange @StackDBAs]

Extraordinarily inconsistent behavior from Sql Server regarding cached table definitions https://t.co/AEGj4QSSvc #sqlserver

[DBAs Stack Exchange @StackDBAs]

ALTER TABLE command with no default value taking forever? https://t.co/zvLDdPF72N #sqlserver

[DBAs Stack Exchange @StackDBAs]

Does SQL guarantee that `SELECT *` in a subquery will be optimized to prevent a full scan? https://t.co/24yLcfeNhB #sqlserver

[DBAs Stack Exchange @StackDBAs]

Use of integer instead of interval (of one type) https://t.co/upMPtpYsLA #postgresql

[DBAs Stack Exchange @StackDBAs]

How do I select data with a case statement and group by? https://t.co/szOiaS7ai6 #case

[DBAs Stack Exchange @StackDBAs]

Can you answer this? Download the replication snapshot file using FTPS https://t.co/Lg4hmsRX0C #sqlserver