Database Administrators Stack Exchange

@dba_stackexchange@robot.villas

Recent community questions on database administration, SQL, PostgreSQL, SQL Server, backups, performance, and reliability.

Source: https://dba.stackexchange.com/feeds

Homepage: https://dba.stackexchange.com/questions

Posts

30

Posts

With the latest version of SQL Server installed... why is SSMS still using an old one? #SQLServer #Database #Tech
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414381
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414381
Don't have an account? Find a server at joinmastodon.org
Oct 11, 2026
How do long-running queries on the secondary of a secondary availability group prevent ghost cleanup on the global primary? #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414390
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414390
Don't have an account? Find a server at joinmastodon.org
Oct 10, 2026
Back up database task in Maintenance Plan cannot write to external drive, even with proxy account/credentials #Database #SQL #Backup
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414397
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414397
Don't have an account? Find a server at joinmastodon.org
Oct 9, 2026
Oracle, selecting on query results #Database #SQL #Oracle
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414406
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414406
Don't have an account? Find a server at joinmastodon.org
Oct 9, 2026
Is a dedicated MySQL replica for AI/agent traffic worth the cost and routing complexity? #Database #MySQL #AI
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414414
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414414
Don't have an account? Find a server at joinmastodon.org
Oct 9, 2026
Best practices for interactive DB access across enterprise #Database #SQL #Security
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414425
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414425
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
Database duplication when query cost is too high #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414434
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414434
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
Failed to update SQL from 2019 to 2025 #SQL #Database #Tech
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414443
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414443
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
GridDB Python: Adding a new column to an existing container fails with INCOMPATIBLE_SCHEMA #Database #Python #Schema
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414453
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414453
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
SSRS upgrade 2000 to 2022 #Database #SQL #Upgrade
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414464
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414464
Don't have an account? Find a server at joinmastodon.org
Oct 8, 2026
After the SQL Server merge replication runs, why does the system throw an error stating that a transaction is being rolled back? #SQLServer #Database #Troubleshooting
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414475
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414475
Don't have an account? Find a server at joinmastodon.org
Oct 7, 2026
Elevated value of PREEMPTIVE_OS_CRYPTOPS wait #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414484
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414484
Don't have an account? Find a server at joinmastodon.org
Oct 7, 2026
MySQL payments table with only ~500K rows has rising latency under concurrent requests: will archiving old data help, or should I look elsewhere? #Database #MySQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414492
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414492
Don't have an account? Find a server at joinmastodon.org
Oct 7, 2026
Why can't I declare a foreign key relationship with `pg_type`? #Database #SQL #PostgreSQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414500
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414500
Don't have an account? Find a server at joinmastodon.org
Oct 6, 2026
How to handle schema changes in SQL Server replication? #SQLServer #Database #Replication
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414508
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414508
Don't have an account? Find a server at joinmastodon.org
Oct 6, 2026
Support for the Cassandra tool #Database #Cassandra #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414520
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414520
Don't have an account? Find a server at joinmastodon.org
Oct 6, 2026
Do long-running queries on the secondary of a secondary availability group prevent ghost cleanup on the global primary? #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414527
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414527
Don't have an account? Find a server at joinmastodon.org
Oct 5, 2026
Does trace flag 9559 impact the redo target of a distributed availability group's secondary availability group? #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414536
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414536
Don't have an account? Find a server at joinmastodon.org
Oct 4, 2026
SQL Server 2025 STD ENG installation on Windows 10 PL with ENG(US) language (including GUI) as default #SQLServer #Database #Windows
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414546
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414546
Don't have an account? Find a server at joinmastodon.org
Oct 2, 2026
Query Store transaction preventing restoring database #Database #SQL #Troubleshooting
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414557
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414557
Don't have an account? Find a server at joinmastodon.org
Aug 5, 2026
Changed Hostname of PC, MSSQL DBs no longer accessible when logged into Management Studio #SQLServer #Database #Troubleshooting
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414568
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414568
Don't have an account? Find a server at joinmastodon.org
Jun 14, 2022
DBCC CHECKDB getting terminated abnormally #Database #SQL #Troubleshooting
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414576
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414576
Don't have an account? Find a server at joinmastodon.org
May 26, 2022
Is it possible to have a temporary, on-the-fly PostgreSQL table which only ever lives in RAM? #PostgreSQL #Database #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414586
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414586
Don't have an account? Find a server at joinmastodon.org
Feb 10, 2021
Setting up cloud database for syncing to local SQLite database #Database #Cloud #SQLite
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414595
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414595
Don't have an account? Find a server at joinmastodon.org
Oct 26, 2020
MySQL Stored Procedure Compiles Without Error (I want the error to occur) #Database #SQL #MySQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414604
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414604
Don't have an account? Find a server at joinmastodon.org
Jun 10, 2020
Can I change the wal_level from logical to replica? If so are any impact on the replication process? #Database #SQL #PostgreSQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414613
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414613
Don't have an account? Find a server at joinmastodon.org
Jan 10, 2020
Unable to turn on compression using innodb #Database #SQL #Performance
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414621
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414621
Don't have an account? Find a server at joinmastodon.org
Jan 31, 2019
EventID 1196 | SQL Cluster & FailoverClustering #SQL #Database #Clustering
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414629
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414629
Don't have an account? Find a server at joinmastodon.org
Dec 26, 2018
Innodb not started? #Database #SQL #Troubleshooting
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414637
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414637
Don't have an account? Find a server at joinmastodon.org
Jan 19, 2017
Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible #SQL #Database #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414646
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22414646
Don't have an account? Find a server at joinmastodon.org
Apr 22, 2016