All Questions

I have a PostgreSQL server that contains a number of databases. The number varies over time between 20 to 30. Some of these databases contain real production information for what we want to have the ...

We have some tables published from one SQL server and another server subscribed to it. However we just realised on two tables data was added at the subscriber end that doesn't exist at the publisher. ...

I am using Postgres, and I am working on a database for a roster system like this: drop table if exists sessions; create table if not exists sessions( id int GENERATED ALWAYS AS IDENTITY, name ...

I have 100+ databases in my instace of SQL SERVER and mostly is a legacy DB but i dont have a control of what is new and what is old. My idea is create a Trigger in all server for every transact and ...

Using SSDT v14 A simple package that extracts data from a SQL Server view and sends via Attunity to Oracle takes about 5 hours to run, of which 4 hours seems to be the Oracle destination task showing ...

I have a query that I need it to be execute fast as possible. Even though I have indexes, it is executing very slowly and I can't figure out why. This is the query, I am trying to optimize. SELECT d.*,...

I know I could stop normal users from using UPDATE and DELETE by revoking permissions. No-one (including DB admins) should be able to UPDATE or DELETE from these tables. (This is for a write-model in ...

I need to create a report which splits the values from table A into a row-by-date format. So for example If I create a sub-set of dates for the past week and sales in the past week, I need to output ...

I have 2 identical tables for 2 countries: ES and NL. In table_es I have 477k rows, in table_nl 1.600M rows, but after checking size of both tables I have 26 GB in ES and 24 GB in NL. How is it ...

i have an issue where i have no idea anymore and can't seem to find a similar one already discussed, so... Am/have to be on pgsql 10.15 / RHEL x86_64. rel A has about 813 million records. format is ...

Pretty sure I've found a bug in SQL Server 2019 (Express) for Linux (CU 13, version 15.0.4178.1 running on Ubuntu 20.04 LTS). After the following table-valued function dbo.bTest is created: use devdb ...

I am looking for some best practices regarding table design when an entity is expected to evolve over time and get more properties. As an example let's consider a process that has a bunch of metadata ...

I have a production database whose full dump is 500Gig and and I cannot do a full restore on a test server because of space issues. However I need to restore a certain schema in from that dump into ...

I want to create a CLR assembly, and here's my code: use [master] go exec sp_configure 'show advanced options', 1 go reconfigure go exec sp_configure 'xp_cmdshell', 1 go reconfigure go execute ...

I'm trying to disentangle our backup strategy, and also troubleshoot the overnight backup of the Azure VM and of the SQL DBs to local storage on the Azure VM, via an agent job and maintenance plan. ...

I am new to postgresql. We had a full disk issue on PostgreSQL DB where data and WAL was set. WAL was taking almost 65 GB. This is a lower environment and we don't need to restore to a point. Compared ...

I replicate my mysql master to a slave. They works very well but once in a while, duplicate entry would happen and I don't know how to resolve it ending up copy the master over and start replicate ...

We have a test RDS postgresql 11.12 instance, configured for logical replication. The only thing connected to it is a 3rd party service, Hevo Data, which is managing sync to a separate Redshift ...

Dears, I've a setup where bunch of MSSQL stored procedures are calling to a Oracle system using a linked server and openquery syntax. We would like to bring everything to MSSQL. Obviously we need to ...

So this is weird. Here's my code: PRINT 'Define cursor' DECLARE cursor1 CURSOR FOR SELECT b.EmploymentTypeID FROM EmploymentTypes b INNER JOIN #ListEmployments l on b.EmploymentID = l....

How do I parametrize DDL statements in a plpgsql procedure? Namely, I want to use the org_label param as the role and schema name but the code below takes it literally and I end up with the role "...

We're doing database design and implementation work in my SQL course, and I accidentally made the value range too short. We're supposed to be building a DB for payment information, and when I put in ...

We have a projects UI page where users can search projects. I noticed that search queries will be slow the first run (up to 10 seconds) and faster on subsequent runs (around 2 seconds). Could this ...

CREATE TABLE branch ( branch_id INT NOT NULL AUTO_INCREMENT, address_id INT NOT NULL, branch_name VARCHAR(30) NOT NULL, PRIMARY KEY (branch_id), UNIQUE (branch_id, address_id, ...

I work on SQL server 2014 I face issue but I don't know how to solve it I need to add columns header from Table as first row on table I Try as below but I get error Msg 213, Level 16, State 1, Line 1 ...

I have given a database with coordinates and want to use these coordinates as the center points for hexagon polygons. PostGIS provides this convenient function: ST_Hexagon The example from the ...

I am running a MySQL 8 source/replica setup on two dedicated bare mettal AMD servers, each on Ubuntu 20.04. Connection is fast over 1GB ethernet switch on dedicated NICs. The database replicated has ...

I have a big problem The main database of my site is not accessible. Can anyone guide me? What should I do? Displays the following error when opening (expanding) this database in SSMS: ================...

I have 4 tables (Company, User, Role, UserRole), I need to get the Id of several users, and then delete them. TABLE Company Id Name TABLE User Id FirstName Email Company TABLE UserRole UserId RoleId ...

I need to export a table in SQL Server 2008 with headers and data delimited with | ( pipes ), but some information inside of this table have , ( comma ) and CR or LR, it's possible to put it a "&...

I am trying to create a postgres database for a webapp that has users that either login with email/password combo or with social accounts. I would like to do it such that once logged in a person is ...

When I select columns from both joined tables a get a huge memory grant (529808). If I query each table columns separately it has a combined memory grant of just 8008. Why does the combined list of ...

I performed the configuration of a database replication (slave), performed it as MASTER MASTER, however, every time I restart as machines, I need to manually start the slave I use the command: START ...

I am looking for an option to log client IPs that come to Oracle listener without enabling oracle audit or creating trigger. Is there an option for this? Ps I am on a windows host, but I am willing to ...

I have a migration project where I need to do some ETL on a snapshot of a database. IT has created a secure .bak file of the requested db and I need to restore it on a non-prod environment before ...

I wrote a fairly simple script that creates in a periodic interval a backup of our DBs, switching automatically into differential in case a full backup already exists. This runs great on my system. A ...

I have a collection and object where this object has a list of objects as following: { "_id": { "$oid": "615617f5b0cd1765b7ba21c1" }, "response": { &...

Trying to figure out, why the below query isn't returning any results: select id from story where tsv_story_text @@ to_tsquery('CumEx-Files<->2.0'); The term exists in the headline of a story ...

With select matviewname from pg_matviews I get all materialized views in the database. How can I filter the result to get only those the current user has select grant (= read permission) on?

From the production the database is backed up automatically every day full backup and every 1 hour for transactional backup. A test server was prepared and I want to restore the latest full backup to ...

Table 1 Table 2 I am struggling to write a query in which I want how many times a users have purchased a quanity and sum of total quantity of one users Sample Entries Table 1 Table 2 So my result ...

I am trying to get the sum of amount from purchases and insert it into the table total_expenses. I don't really understand how to add the values of aggregate functions into other tables as new tuples. ...

I'm trying join Two tables: KDSCMSCNTRCTD CNTRCTDID | CNTRCTDCOMP | CNTRCTDLNUM | 3221 | NAV | 207 KDSCMSCNTRCTDHIST CNTRCTDHISTID | CNTRCTDHISTSDATE | CNTRCTDHISTCOMP | CNTRCTDHISTLNUM | ...

How would I set up a view that is for showing a restricted set of data for masking PII? Can a view be created which is available at lesser role access than the source tables? This is for Postgres ...

I have a job in Pentaho that performs an INSERT on SQL Server. This table Input has a "commit size" of 1000 lines. Everything was working fine until switching to a Paas bank. After that, the ...

I'm attempting to design and build a data structure for a blogging platform. the business of my website follows users can create articles. articles must include one of predefined generic category, ...

I need to be able to parse a string array with STRING_SPLIT on a SQL 2016 instance. The vendor has required the one user DB we have access to be set with a compatibility level of 100 while the system ...

My Postgres instance is logging things like this: 2021-11-16 22:18:52.491 UTC [1808765]: [3-1] db=xxx,user=xxx LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp1808765.0", size 262144 My ...

I have a stored procedure that is acting quite strangely, it basically works in this way: --Populate #tmpActualsVertical with data(in this example 84,652,788 rows) SELECT ...

I have to load some stuff(data) onto a "persistent storage database." The assignment says: 'Please use some sort of network-accessed database like MySQL or Cassandra, but it may be any such ...