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

The Stack Exchange network
Joined January 2011
Is it possible to create AWS RDS as replication from external server? dba.stackexchange.com/q/2413… #mysql
113
Pair top-level key with nested value from jsonb document dba.stackexchange.com/q/3231… #postgresql
103
Why does sys.fn_xe_file_target_read_file require an explicit cast on datetime2 column? dba.stackexchange.com/q/3231… #sqlserver
65
Can you answer this? ORA-01157: cannot identify/lock data file 201 dba.stackexchange.com/q/1146… #oracle
64
Recover registered servers in SQL Server Management Studio 2012 dba.stackexchange.com/q/1917… #sqlserver2008r2
63
Oracle: Viewing settings for DBMS_NETWORK_ACL_ADMIN ACL? dba.stackexchange.com/q/1158… #oracle
55
Update fails on linked server after upgrading to SQL Server 2022 dba.stackexchange.com/q/3227… #sqlserver
4
262
Can you answer this? Do hstore and jsonb have the same plumbing internally? dba.stackexchange.com/q/2368… #postgresql
79
SQL equivalent to return value from WHERE EXISTS when unable to JOIN dba.stackexchange.com/q/3230… #sqlserver
1
4
1,460
Extraordinarily inconsistent behavior from Sql Server regarding cached table definitions dba.stackexchange.com/q/3230… #sqlserver
79
ALTER TABLE command with no default value taking forever? dba.stackexchange.com/q/2223… #sqlserver
59
Does SQL guarantee that `SELECT *` in a subquery will be optimized to prevent a full scan? dba.stackexchange.com/q/3229… #sqlserver
1
176
How do I select data with a case statement and group by? dba.stackexchange.com/q/7713… #case
31
Can you answer this? Download the replication snapshot file using FTPS dba.stackexchange.com/q/1377… #sqlserver
50