Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box....
Asked on 11/17/2021
1 answerIs there a standard function in PostgreSQL (as of 12.x) to concatenate or merge many jsonb objects in a database column into a single jsonb object? I know there is...
Asked on 11/17/2021
1 answerI have mysql running with a high concurrency press test.MySQL can running with around 1000TPS for 15 minutes with 200-400 running thread. Then performance speed down, with process waiting...
Asked on 11/17/2021 by Jye Zn
0 answerWe are using oracle 11g I am replicating production db for dev environment.I Have a user named CST2 and CST0 where CST0 contains all tables and view and public...
Asked on 11/16/2021 by Vishwanath gowda k
1 answerSQL Server and Sybase ASE both support the highly dubious feature of grouping stored procedures by appending a number:CREATE PROCEDURE Foo;1 AS ...CREATE PROCEDURE Foo;2 AS ...The only tangible...
Asked on 11/16/2021 by Jeroen Mostert
2 answerI need to run an alter statement but would like to prevent locking/stall the cluster. The Galera docs advised using: SET wsrep_OSU_method='RSU';Then Run the ALTER statement,...
Asked on 11/15/2021
1 answerAfter some time idle, if users try to use the our system, we receive the error: ORA-03114 - not connected to Oracle. I know there's a parameter called SQLNET.EXPIRE_TIME. the...
Asked on 11/15/2021
1 answerI understand that as of the 2016 versions it is now possible to run SSRS and Power BI on the same server. I would like to know if anyone is...
Asked on 11/15/2021
1 answerI am trying to set up a linked server from an on-prem SQL Server to an Azure SQL instance. The Azure SQL instance uses Azure AD for authentication. ...
Asked on 11/15/2021 by tbdevmanager
1 answerI have trigger and a stored procedure in it (so SP runs when trigger runs). I need a function which finds the next saturday to put in SP. So...
Asked on 11/14/2021 by Who Cares
5 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP