Newest Questions
104,871 questions
2
votes
1
answer
46
views
MS SQL Server Agent - Managed Service Account
We have MS SQL Server 2019 where we have created a managed service account (sa_agnt) and configured the SQL Server Agent to logon as DOMAIN\sa_agnt.
I have then created a SQL Server Agent Job that ...
- 31
2
votes
1
answer
60
views
random_page_cost not set from configfile
if i set random_page_cost = 1.1 in my postgresql.conf, it is not beeing set, not after restart, not after select pg_reload_conf();.
It is however set, if i put it in the configfile bevor creating a ...
- 123
0
votes
0
answers
45
views
How to convert Oracle's TIMESTAMP(6) to a SQL Server data type
Question: How to store values such as 09/29/2015 4:58:47.000000 PM in a date type column in a SQL Server table?
Details:
Migrating data from Oracle to SQL Server. One column, say col1, in a table in ...
- 519
1
vote
0
answers
19
views
Execute SSIS Package from Catalog using execute as login
I have a requirement to be able to use EXEC [SSISDB].[catalog].[create_execution] to execute a package as a specific login. I need to do it this way rather than using an agent job, as I need to pass ...
- 63
1
vote
0
answers
22
views
SQL SSRS ReportServer db DROP/Create Objects
I've enable DDL audits on few of our servers, The past two months, Im seeing a weired behavior on a server where we host our reportserver database.
I'm seeing lots of drop procedures/view followed by ...
- 110
0
votes
0
answers
20
views
Cassandra 4.x - drops internode messages under stress
We are stress testing Cassandra 4.1.8 and observing behavior that differs from Cassandra 3.11.11 when the cluster is under heavy load. Specifically, we are seeing a significant number of internode ...
- 113
1
vote
1
answer
60
views
+50
500 million is becoming a horrible negative number on replicas
I need some assistance understanding what looks like a corrupted value in replicas.
Here's the scenario: 1 primary database, 8 read replicas. Database is MySQL, deployed with Amazon RDS. There is a ...
- 69
2
votes
1
answer
57
views
Does the lack of Hyper-Threading on Intel's new Core Ultra’s impact SQL Server performance
This question is slightly academic. I'm not considering purchasing a new machine for production use. Instead I'm looking at options for my development machine. I also like to fully understand how ...
- 75
0
votes
0
answers
18
views
Postgres - would multiple triggers for different record types on the same table improve performance?
I have a trigger currently defined like this...
CREATE TRIGGER trig1
AFTER INSERT ON public.posMessage
FOR EACH ROW EXECUTE PROCEDURE public.parsemess();
The procedure parsemess() will parse one of ...
- 1,291
-1
votes
0
answers
12
views
What is virtual circuit in Oracle database?
I know we have another question: In Oracle shared server mode, what is a virtual circuit?
The answer of that question is good, but I'm still not 100% clear about it. I want to know, is this concept ...
- 2,070
0
votes
0
answers
15
views
Postgres - how to performance tune a postgres function?
How can I tune a postgres procedure?
The procedure is written in PL/pgSQL it runs as part of a AFTER INSERT trigger. It works OK, but I'd like to improve the runtime. How can I do this? Any other ...
- 1,291
0
votes
0
answers
18
views
DACPAC deployment hangs at Updating database (start)
We are currently in the middle of creating a proof of concept using DACPACs as our deployment/release method rather than our in-house deployment product. The two databases that I am currently using to ...
- 115
0
votes
0
answers
5
views
Can a subclass participate partially in a generalization relationship?
In an EER diagram, can a subclass exist where some of its members are not members of the superclass?
I know that it is possible for some members of a superclass to be not part of any of its subclasses....
- 101
1
vote
2
answers
135
views
How to restore only the Secondary FILEGROUP Backup in a different DB?
I have a db with size of more than 300 GB. But I have created two FILEGROUPS and the secondary filegroup contains only 2 tables. I want to take the backup for the that particular secondary filegroup ...
-1
votes
0
answers
64
views
How to migrate huge database from Sybase to Oracle or SQL Server [closed]
I have a huge Sybase database containing millions of records and hundreds of tables. What is the best way to migrate to Oracle or SQL Server keeping everything as it is i.e. data types, values, ...
- 449