• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
0

Enlist the advantages of DBMS.

Database Management Systems (DBMS) offer several advantages compared to traditional file-based systems. Here are some of the key advantages:1. Data Independence:? ?Logical Data Independence: ... See More

0

What are the various types of relationships in Database?

One-to-one: A single table is linked to another table with a matching column. Each primary key corresponds to just one or zero records in the connected table.?One-to-many: A table is connect ... See More

0

What are the different types of Normalization?

1. First Normal Form (1NF) requires that all entities in a table have unique or atomic values.2. Second Normal Form (2NF) builds on 1NF by ensuring that all non-key attributes are fully depe ... See More

0
avatar

Posted by User Bot

4 months ago

How can I select all rows from two SQLite tables, but prefer one if there are matching rows in both?

I have two tables, each with a round and an id column and additional data columns. One table is the planned version, the other one is the actual one. E.g.: planned: round | id | ... See More

0
avatar

Posted by User Bot

4 months ago

Error after moving ssrs + prod DB to Tes environment

So we moved both ssrs databases ( ReportingServices and temp ) and the main DB from PROD to one of our test environment. I moved the DBs, I cleaned subscription table, I backup/ ... See More

0
avatar

Posted by User Bot

4 months ago

Locking write to tables while Postgres procedure is executing

I have created a procedure in Postgres that will create a table with the contents of another three tables (SELECT with JOINS). Then the resulting table will be altered adding tw ... See More

0
avatar

Posted by User Bot

4 months ago

How to set a reminder in store procedure using sql server?

I have a query, but want to create a store procedure that will set a reminder if 'Stock on Hand is 0' 'Blank' The following columns(Crystal, Cylical) needs to set a reminder to ... See More

0
avatar

Posted by User Bot

4 months ago

Index use after unwind in aggregate

We have a collection in our MongoDB where due to a changed use-case a so-far small query is now really slow. The aggregate in question is somewhat like this: db.collection.aggre ... See More

0
avatar

Posted by User Bot

4 months ago

SQL Server 2008R2 - data file grows back after shrinking and available to shrink again

After shrinking of datafile there is around 180Gb of free space on hard drive (prior to operation shrink file dialog also shows that it is possible to free up around 180Gb of sp ... See More

0
avatar

Posted by User Bot

4 months ago

Why are Cassandra 4.0 configuration properties like enable_sasi_indexes no longer in 4.1?

I have been asked several times by users why certain configuration properties in Cassandra 4.0 conf/cassandra.yaml are no longer in 4.1. For example, the flag which enables the ... See More

0
avatar

Posted by User Bot

4 months ago

Power failure stopped replications

New to work with replication - unable to figure out solution as this runs on prod. Kindly help me with a fix. - Thank you! Error messages: The process could not execute 'sp_rep ... See More

0
avatar

Posted by User Bot

3 months ago

Percona cluster behind Fortinet Virtual Server

Trying to create VIP on Fortinet which will be pointed to Percona cluster. It wont work, any experience. 2 posts - 2 participants Read full topic ... See More

0
avatar

Posted by User Bot

3 months ago

V2.4.0 - Backup job pods are not being removed

Description: Using Operator v2.4.0, the backup job pods aren?t being cleaned up. PerconaPGBackup are being deleted according to the retention configuration, but the backup job p ... See More

0
avatar

Posted by User Bot

3 months ago

Percona Mongo 4.0 on Ubuntu 22.04 LTS AMD64

Hi there, I have 3 bare metal servers running Ubuntu 20.04 LTS AMD64, finally I will upgrade very soon to Ubuntu 22.04 LTS - AMD64. The current version of Mongo running as Repli ... See More

0
avatar

Posted by User Bot

3 months ago

Can we add output of SQL query in MariaDB to PMM dashboard

Description: HI Team, Since there is no option to monitor multi channel replication yet in PMM, I am looking for an alternate solution in which I can run a query to get the requ ... See More

0
avatar

Posted by User Bot

3 months ago

PMM DBaaS for Postgress DB

Hello Folks, is there anybody who can help me? it would be possible create postgress DB via DBaaS on PMM ? (in the same way as mysql or mongo). Thanks 4 posts - 3 pa ... See More

0
avatar

Posted by User Bot

3 months ago

PBM Azure Storage Config file has unmarshal errors

I?ve got a 3 member replica set and have an Azure Storage accounts prepared for remote storage. I used the template provided in the walk through and filled in the relevant valu ... See More

0
avatar

Posted by User Bot

3 months ago

Adding a Percona Replica Slave to an existing MariaDB Replication Environment

Hi! I have a fully working MariaDB Replication Environment: Master: MariaDB 10.3.27 (about 450 databases, all with the MyISAM engine, almost 500GB of total storage) Slave: Maria ... See More

0
avatar

Posted by User Bot

3 months ago

Question regarding Scheduling Backups with PMB + PMM

I?m very new to both PBM and PMM. I have just installed PBM and got a backup working and into Azure external storage. I?m looking at PMM for monitoring the db and VM as well as ... See More

0
avatar

Posted by User Bot

3 months ago

Getting error while taking pmm backup to s3 from ui

Hello Channel, Good day to all. I have deployed pmm and percona mongodb in kubernetes cluster. i can abule see mongodb logs in pmm ui. enabled backup option in ui. configured a ... See More