All Questions

Filter by
Sorted by
Tagged with
1
vote
1answer
3k views

Automating Oracle database installation on Windows

I'm trying to install an Oracle 12c database on Windows using the silent install with a response file as: setup.exe -silent -responseFile file.res Where I generate the response file using the GUI ...
0
votes
1answer
114 views

Barman + repmgr failover process

I am about to build a PostgreSQL 11 cluster with Repmgr and Pgpool II, and I want to use Barman for backups. The result will be a PostgreSQL cluster with one master node and two standby nodes: ...
0
votes
1answer
74 views

Other way to disconnect user/client in mySql 5.6?

Hello everyone is there another way of disconnecting user/client aside from: kill id I have a close button which when i click the button it will close the connection on the selected user... but the ...
0
votes
0answers
4 views

What is the current recommended way of changing the collation of an Azure SQL database?

We would like to switch to using the Latin1_General_100_CI_AI_SC_UTF8 collation in our Azure SQL database. Altering the collation of individual columns aside, if this were on-premise SQL Server 2019, ...
0
votes
3answers
27 views

How can I optimize dashboard performance?

I have a table like FieldA, FieldB, FieldC, FieldD, Date, Count I have a web app which provides a dashboard of the top few Count by each of the fields. Not wanting to prematurely optimize, the ...
0
votes
1answer
3 views

Availability Group Listener and old client software

We've got a multisegment AG Listener named SQLAGL01 which points to these two addresses: 10.143.162.32 (the primary server) 10.140.165.32 (DR server) Because the 3rd party (which means we can't fix it,...
1
vote
2answers
444 views

Large MYSQL DB on single file

I have a large MYSQL innodb database (115GB) running on single file mode in MySQL server. I NEED to move this to file per table mode to allow me to optimize and reduce the overall DB size. Im ...
0
votes
2answers
4k views

Create MySQL CHILD and PARENT records at the same time and set CHILD.PARENT_ID by using MySQL Triggers

I want to create relationships between parent and child when booth doesn't exist and when new child is created. This somehow can be done with Triggers but i don't know how to work with SQL. After ...
4
votes
1answer
2k views

Replication stops with GTID_NEXT error after creation/drop of memory table in mysql5.6

We have recently upgraded to mysql5.6.25 from mysql5.5.x/mysql5.1.x on our mysql-cluster. Below is a brief snapshot of our architecture. Since we have upgraded and enabled gtid-mode we have been ...
0
votes
2answers
9k views

Net Configuration Assistant doesn't open, created Listener in Net Manager but it isn't recognized when creating database Win 7

I have installed Oracle 11g on my Windows 7 64-bit system. The Net Configuration Assistant does not open for me to create a listener. I was able to add a listener through the Net Manger and it says it ...
0
votes
0answers
11 views

mysql query cache — how to determine if I should turned it off [duplicate]

I have a lot of queries that are repeated and would benefit from cache. A lot of articles online to say to turn it off. Below is `show global status. Do you think I would benefit from turning it off? ...
0
votes
0answers
6 views

Deploying dacpac through sqlpackage.exe with NETWORK SERVICE user

I have a database release pipeline in Azure DevOps Server which deploys our dacpac files through Powershell commands that run the sqlpackage.exe commands to publish the database. I am using the ...
-1
votes
1answer
333 views

Running a psql command inside a Postgres function

I'm open to other suggestions on how to do this. The goal is that when I commit my code to the repo and push to Prod it will run all my "create or replace" against my production DB. I've written a ...
0
votes
0answers
4 views

What is a starting point for finding the fastest databases for inserting and querying millions of rows per second?

I am a database noob. I work on an application that reads a real-time source of data that generates records on the order of a million per second (or more) and stores them in a homegrown database. A UI ...
-1
votes
4answers
814 views

Should I spread many connections over a period of time, or hammer the database at same time?

I currently have a fairly small (micro, but can upgrade if necessary) Postgres db instance on Amazon RDS. I think I have a max connections of about 85 (checked through max_connections value in console)...
0
votes
0answers
7 views

Bash Script Can't Connect to Azure Postgres using ENV Vars - “The Username should be in <username@hostname> format”

I have a bash script that exports ENV vars to use in connecting to an Azure Postgres DB (mydb.postgres.database.azure.com). For the user portion of that specifically it looks like this: export PGUSER=&...
1
vote
2answers
797 views

Use Stored Procedure or View to return Data from Multiple Tables

Is it just down to preference for whether to use a View or a stored procedure (or TVF) to simply return data joined from multiple base tables? Is there any best practice regarding this? Should a ...
1
vote
1answer
9 views

Foreign key constraint is incorrectly formed

So, i have these two tables CREATE TABLE IF NOT EXISTS `inart_ps_categories` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `inart_ps_category_id` int(11) UNSIGNED NOT NULL, `parent_id` int(11)...
0
votes
1answer
14 views

How to use WITH inside IF statement in PostgreSQL

I am writing a function that accepts a text flag based on which I need to run some code. So I am using an IF clause. However the code that has to execute inside IF and ELSE is a recursive CTE which ...
-1
votes
1answer
20 views

Replacing Null value with existing value

How would it be possible to replace the null value from Order - column with the above existing value that has the the same Document-number? Document Value Value2 Order 1234567 4 7 ...
1
vote
2answers
77 views

how to use the same timestamp along several tables?

Lets say a have 2 tables and both have a datetime column. On table A, on datetime column, lets say, ts1, is non null, default is CURRENT_TIMESTAMP and on update CURRENT_TIMESTAMP; The other table, B,...
0
votes
1answer
55 views

Buffer Latch Type 3 and Failed To Generate Checkpoint Errors

I am getting this in the log file: Time-out occurred while waiting for buffer latch type 3 for page (1:4660738) database ID 5 The database is in Full mode & logs are backing up every 15 minutes ...
-1
votes
0answers
10 views

Azure SQL Managed Instance replication

I'm working on legacy application migration to the cloud, currently on planning and estimation stage, the question I wasn't able to google is: Can a Subscriber database be in the same Azure SQL ...
0
votes
0answers
10 views

Best way to Partition Cosmos DB to have different languages

I have documents that are currently housed in a COSMO-db instance (Json DocumentDb). We have the partition key (pkId) the on container and so the ID is the same as the PartitionKey. so my partition ...
0
votes
1answer
656 views

How to replicate particular table in MySQL master-slave configuration?

How do I replicate a particular table in a MySQL master-slave configuration? I have tried replicate-do-table and replicate-wild-do-table. I tried in my.ini file; is there any alternative to replicate ...
1
vote
1answer
11 views

How to save database connection information when using `psql`?

I am learning to use psql to work with a postgres database on linux. I can connect using a long connection string, for example by running: psql postgresql://myusername:mypassword@localhost:5433/dbname ...
0
votes
0answers
8 views

Does commit after a normal select can call any fsync or flush operations?

Coms counts taken at particular time for all 3 (insert,update,commit). Com_inserts are in 1.1K Com_updates are in 1.6k Com_commit are in 10K When enabling general log, I could see after each ...
0
votes
1answer
21 views

Combine Multiple Rows Results From Left Join in a unique cell

¡Hi guys!, I don't have any idea how to create a new column that contains all information of results from a Left Join if exists the value Example Table 1 -------------------------------------- | ...
-1
votes
1answer
45 views

Optimising SQL Query

Currently I have a query to calculate the averages of auctions that are present within a game, in order to do this I have the following query: SELECT item_name, tier , CAST(SUM(highest_bid) AS ...
0
votes
0answers
7 views

Help in database design for creating investment platform

I am creating an investment platform where investors would be able to invest in various real estate properties and also able to sell their shares on platform. There would be the following types of ...
2
votes
1answer
420 views

how to publish user defined table type as an article in Transactional replication

I am new to replication and trying to use transactional replication. I am trying to publish all data and schema. My stored procedure takes user defined table type as input. CREATE type TableBParam as ...
0
votes
0answers
9 views

SQL Server HA Design (FCI) - Windows Storage Replication - Test-SRTopology - Physical Memory Error - AWS EC2

I'm trying to set up AlwaysOn Failover Cluster Instance (Not Availability Groups) on 2 VMs(each on different AWS Availability Zone) in AWS-EC2 instances. To make this happen, I've to set up Windows ...
0
votes
2answers
63 views

Slow planning time on PostgreSQL 12.4

I have a database with Openstreetmap location data, and in particular there is a polygon table with around 500 million rows. I created indexes on all of my queries consisting of using gist(way) where ...
1
vote
1answer
37 views

Modeling an either/or relationship

I've seen this post (How should I model an “either/or” relationship?) but it's not exactly what I'm looking for. both answers are suggesting creating a subtype instead of a relationship. Say I have an ...
0
votes
1answer
27 views

SQL Server options that influence log buffer flushing or commits-per-second performance?

I am investigating two SQL Server 2014 instances, both running identical software, both running identical hardware (VMs), both loaded with the same test database, but one with hugely greater ...
0
votes
0answers
12 views

Best Practice on reusing Service Broker Conversations and Conversation Groups

At the moment, we're using Service Broker on a lot of our critical components in our database, and I wanted to ask about the best practices on Conversation and Conversation Group reuse. Presently, we'...
0
votes
0answers
11 views

Implications of using the underscore before the table name

For a ERP database schema, with a large quantity of tables to variable applications, to describe general tables like, users, groups, logs, i can, write table name with a underscore before? Example: ...
0
votes
1answer
176 views

Configuring SQL Server management data warehouse (MDW) for data collection

I am configuring a data warehouse on an SQL Server to collect data. However, the process is not finishing and it stays as per below for hours until it is manually stopped: Have you ever encountered ...
0
votes
1answer
28 views

How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine?

I've created a file: 'C:\fff.txt' which contains data for my database table. Then I'm trying to load data from that file like this: LOAD DATA LOCAL INFILE 'C:\\fff.txt' INTO TABLE fff LINES TERMINATED ...
-2
votes
0answers
14 views

Need to duplicate rows that have same criteria in SQL case statement

I have below data set, from which I want to extract multiple rows. account 123 start_date 5/10/20 end_date 10/20/20 Using the below code my result is only 1 row with "today", but since ...
0
votes
2answers
57 views

Benefits of not having a clustered index on tables (Heaps)

What are the benefits of not having a clustered index on a table in SQL server. Will a SELECT * INTO TABLE_A FROM TABLE_B Be faster if TABLE_A is a heap? Which operation will benefit if the table is ...
0
votes
0answers
23 views

How to change the default initial and next for new partitions in oracle

This is kind of a follow up on this question : How to change initial extent of an existing partition I have a table that was created with an initial extent of 8M for new partitions and this takes too ...
1
vote
1answer
14 views

How to inspect a view's structure in information schema in PostgreSQL?

Is there a way to discover the structure of a view in a similar way to how tables are described by entries in information_schema.columns? I can also use the pg_* tables. In other words, similar to how ...
-1
votes
1answer
29 views

Getting duplicate value when using join

I have 4 tables accordingly that i want join query. Each contact Center id have one annual budget value in second table. Each contact center id have multiple row value in remaining two table i.e ...
0
votes
1answer
289 views

shrink ibdata1 in Galera Cluster

I'm having a Galera cluster (3 nodes, but currently using only one), MariaDB 10.0 Galera. However, my ibdata1 is growing HUGE (although using inno_file_per_table=1). Now i want to "shrink" it by ...
0
votes
2answers
122 views

What firewall ports should be opened for central management server

Within my environment we currently have a MSSQL installation which serves as the Master in a Multiserver Agent environment (MSX). Due to this server being within a tightly controlled network the ...
9
votes
10answers
58k views

Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery

I have received a database file and the instructions for loading it is to install SQL Server 2005 and then attach it using SQL Server Management Studio. After installing everything, I tried to attach ...
0
votes
0answers
18 views

Good way to limit access of rows different for different users? (Postgres)

I am writing a closed application in which a user enters his db-connection details and then all queries are hard coded. Let's assume I got a table "tbl" with 1000 entries (rows). One day the ...
0
votes
0answers
39 views

Compare previous column and current column in ORACLE SQL and do SUM

This is my query to get TIME_DIFFERENT-> TO_CHAR (DATE '1900-01-01' + ABS ( LAG(MODIFIED_DATE,1)OVER(ORDER BY MODIFIED_DATE DESC) - MODIFIED_DATE), 'HH24:MI:SS') AS TIME_DIFFERENT Now, I want to ...
0
votes
1answer
507 views

How to update collections and restore while doing mongorestore?

is there any way that i can update the collection and restore the same from dump created by mongodump cmd . when we do mongorestore , it directly restores from the dump , but my requireemnet is to ...

15 30 50 per page
1
2 3 4 5
1719