All Questions

Filter by
Sorted by
Tagged with
0 votes
0 answers
3 views

Writing a query to return records from one table using records selected from two other tables by their association to a fourth table

I have four tables that are immediately relevant to the question, though there are two others peripherally involved, which I’ll describe for completeness, marked * Data: ID Name Description tag catid ...
FitzmorrisPR's user avatar
0 votes
1 answer
14 views

Many-to-many: select an entity by matching relationship

I have a many to many relationship implemented: CREATE TABLE public.message ( id BIGSERIAL PRIMARY KEY, name varchar(40) UNIQUE NOT NULL ); CREATE TABLE public.package( id BIGSERIAL ...
Александр's user avatar
0 votes
0 answers
13 views

Setting MariaDB encryption

Hello I need to Configure a MariaDB server to provide data encryption during storage. I am performing the task on linux oracle 9. when I try to restart the server, I get the following message [vagrant@...
user avatar
0 votes
0 answers
7 views

Can I merge settings.json files in Azure Data Studio

I want to make a few changes to by settings.json file and use these changes on another installation. Is there a way of merging a simplified version of settings.json (with only some changes) on another ...
Manngo's user avatar
  • 2,849
0 votes
0 answers
9 views

What are the cellPadding values in Azure Data Studio

I’m trying to get used to Azure Data Studio after using SSMS for some time, and, so far, I think its interface is very unfinished. I want to change the cell padding, which I didn’t like to begin with, ...
Manngo's user avatar
  • 2,849
1 vote
0 answers
18 views

mydumper packages availability for graviton aarch64

I am trying to implement mydumper for mysql community server (8.0), in absence of xtrabackup for graviton aarch64 architecture. Unfortunately packages are not available for graviton aarch64 ...
Avinash Pawar's user avatar
0 votes
0 answers
12 views

Percona xtrabackup and percona toolkit for aarch64 Graviton Amazon Linux 2 machines

In my organisation, it was decided to move all the MySQL infrastructure (Amazon EC2 machines) to Graviton (aarch64) servers from AMD (x86_64). All are MySQL Community Servers. I need percona-...
Avinash Pawar's user avatar
1 vote
1 answer
41 views

Does enabling backup compression in a Back Up Database Task enable checksums, no matter what setting you pick for them?

Observations The documentation says To enable backup checksums in a BACKUP (Transact-SQL) statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option....
J. Mini's user avatar
  • 545
0 votes
0 answers
25 views

SQL server granular control over auto update statistics

I wanted to know if we get more granular control over auto update statistics at the index level in SQL server. One of my DBs with auto update stats enabled recently started to have some behavioral ...
udhayan dharmalingam's user avatar
2 votes
1 answer
86 views

What kinds of operations could cause a "Temp table changed" recompilation?

Frequent recompilation happens in one SP with 'Temp table changed' cause. What kinds of operations on temp table would trigger this? There are no alter and create index operations on temp table, just ...
Jason Liu's user avatar
0 votes
1 answer
8 views

PieCloudDB upgrade failed

I am upgrading PieCloudDB Database from V2.8 to V2.14 according to the following steps on the administration guide: Use the command helm upgrade [RELEASE] [CHART] [FLAGS] to push the new version of ...
PDB's user avatar
  • 16
-1 votes
0 answers
10 views

Assistance Needed: SQL Server 2019 Log Shipping for SharePoint SQL FCI Database

I hope this message finds you well. I need some information regarding SQL Server 2019. Our client requires a Disaster Recovery (DR) solution for their SharePoint SQL Failover Cluster Instance (FCI) ...
usamawahab khan's user avatar
-2 votes
0 answers
20 views

Dynamically change column names based on an 8 digit binary field

I have these two tables The value in the incentive programs table is the decimal values based on binary values 00000001 (1), 00000010 (2), 00000100 (4), 00001000 (8), 00010000 (16), 00100000 (32), ...
jhogan3's user avatar
  • 27
0 votes
1 answer
5 views

Is there a way to backup a keyspace and restore it to a different cluster?

I have a live cassandra cluster(One node). I've built out a 3 node cluster I would like to migrate a keyspace to the new cluster. Is there a way to backup a Key space, then restore that Key space ...
Ricardo Mattier El's user avatar
0 votes
0 answers
36 views

Designing enrollment transfers

Here is a simplified asciigram of my database: is_paid, paid_at | -----------Enrollments-------- / \ | ...
Yusuf Bouzekri's user avatar
0 votes
1 answer
31 views

Is DBCC CHECKFILEGROUP worthless if you already run DBCC CHECKDB on all databases?

DBCC CHECKDB makes many other integrity checks redundant, but I can't see anything in the documentation saying if it makes DBCC CHECKFILEGROUP redundant. Is DBCC CHECKFILEGROUP worthless if you ...
J. Mini's user avatar
  • 545
0 votes
0 answers
24 views

Why is the character set for the uca1400_ai_ci collation NULL?

I've been working with database collations of late. I generally don't like ambiguous queries such as SHOW COLLATION so I eventually found the source via the following query: SELECT * FROM ...
John's user avatar
  • 737
0 votes
1 answer
27 views

How can I find or log inbound traffic connecting to a PostgreSQL database instance?

I have a postgres instance where I need to find out who/what is connecting. The installed version of postgres is 9.0.1. The instance sits on a linux box, SUSE I believe. Where could I look if it is ...
Eric Swiggum's user avatar
-2 votes
0 answers
27 views

SQL Server: Two MERGE statements are blocking each other on a large partitioned table

Have a large table partitioned on an INT column. When I run two different MERGE statements on two different partitions of this table, they seem to be blocking each other. Example: -- Large table ...
ToC's user avatar
  • 561
0 votes
1 answer
35 views

How do I consolidate the related mappings?

I have a table which has mappings coming from different sources (one row for each source) for three different identifier types (idtype1 to idtype3) with idtype1 having the highest priority and idtype3 ...
Rishav Ghosh's user avatar
0 votes
0 answers
5 views

Shell script not working when run as wsrep_notify_cmd by Galera Cluster for MariaDB

I have a simple shell script that I'm trying to use to test Galera Cluster for MariaDB's node state change notification mechanism, running on an AWS Ubuntu 20.04 LTS instance. The script is a ...
Dan Parker's user avatar
1 vote
1 answer
47 views

Need to add user and assign roles automatically, using DDL Trigger, when database is created

I am trying to create an automated process that will add a user and assign them the roles of db_datareader, db_datawriter and db_ddladmin whenever a database starting with PA is created. I have ...
Eric's user avatar
  • 11
0 votes
0 answers
22 views

How to patch a Postgresql located on a Windows server? [duplicate]

I'm new to Postgresql administration and looking for some guidance on process to apply patch/upgrade to a PostgresSQL server installed on a Windows VM. Is there a patch executable or do I need to ...
variable's user avatar
  • 3,476
0 votes
1 answer
18 views

How to connect/take over a Postgresql instance without any login?

I have inherited a Postgresql server but have no records of the admin credentials or any user account. I do have local admin access to the Windows VM that hosts this Postgresql server. How can I gain ...
variable's user avatar
  • 3,476
0 votes
1 answer
24 views

Is it possible to make a No-DELETE replica/follower database?

I would like to allow an application's database to execute DELETE statements. However, for analytics purposes, I would like to keep all data, even deleted data. I'm trying to figure out if there is a ...
Chad M's user avatar
  • 143
0 votes
0 answers
5 views

Version incompatibility error between the SQL-Server database backup and the SQL Server running in the Docker container on my Ubuntu 20.04 VPS

I have installed Docker and run a container on my Ubuntu VPS for resolving the version incompatibility between SQL Server and the backup file but even docker has not solved. During restoring the ...
user avatar
1 vote
0 answers
41 views

Is it better to run MariaDB on multiple smaller servers or one big one?

I have three clients that all use MariaDB for their applications. In the interest of security I created a VM for each of them that have 2vCPU and 4GB RAM. But I was wondering if merging their servers ...
Cezar's user avatar
  • 11
0 votes
0 answers
33 views

Transactional replication is trying to update a row that does not exist yet. Why?

I've been tinkering with SQL Server 2019 and transactional replication for a little while now and I've hit a wall. Looking at the replication monitor I'm seeing the error "The row was not found ...
fumblinggravy's user avatar
0 votes
1 answer
27 views

Performance Impact of Partial Index on INSERTs Not Involving the Partial Match

Given: postgres=# create table testing(a int primary key, b int not null); CREATE TABLE postgres=# create index on testing (b) where b = 0; CREATE INDEX postgres=# \d testing Table "...
Kevin Meredith's user avatar
-4 votes
0 answers
16 views

Incorrect number of bindings supplied. The current statement uses 1, and there are 54 supplied

def add(self): con=sqlite3.connect(database=r'ims.db') cur=con.cursor() try: if self.var_cat.get()=="Select" or self.var_cat.get()=="Empty" or self.var_sup.get()...
Atittaya Parasuwanno's user avatar
0 votes
0 answers
11 views

Does BimlExpress still support Visual Studio?

We heavily use BIML in our data projects for the development of SSIS packages, so BimlExpress is important to us. So far, it looks like BimlExpress does not provide an installation for Visual Studio ...
Mike's user avatar
  • 13
-4 votes
1 answer
57 views

Reorganize or Rebuild Spatial Indexes

Will there ever be a way to exclude or only include spatial indexes from the IndexOptimize tool?
Darrell's user avatar
  • 121
0 votes
0 answers
22 views

Having trouble with composite data type in Postgres

I am trying to test an api call that loads data into my postgres db table via postman. The table includes composite value types, and that seems to be causing an error:{"error":"...
John Clemmens's user avatar
0 votes
1 answer
32 views

I created an event, but it is never executed. Why?

I need to call a stored procedure every 10 minutes and I am using a recurring event, the problem is that it is not executed or I don't know how I can see if there is an error Procedure: CREATE DEFINER=...
Johnny Urdin's user avatar
0 votes
0 answers
54 views

Problem with many connections from RHEL 8.10 to SQL Server

I have simple script: for i in {1..1000} do isql -v -k "Driver={ODBC Driver 17 for SQL Server};Server=mssqlserver,1282;Database=dbname;UID=user;PWD=xxx;Encrypt=no" >> aaa.log & ...
Juraj 's user avatar
0 votes
2 answers
41 views

Postgres: is there a way to speed up changing column type from int4 to int8?

We have about 100 simple changes to make to our DB schema like this: alter table transactions alter customer_sport_id type bigint; Before it was int4. Most of the changed columns have one or more ...
John Little's user avatar
0 votes
0 answers
49 views

SQL Server Express mdf file is 50+gb

Good day, I have a SQL Server Express database running on a POS register where the mdf file is 50+gb. When I run the select @@version I get the following: Microsoft SQL Server 2017 (RTM) - 14.0.1000....
Sean Harricharan's user avatar
-2 votes
0 answers
72 views

Why would email alerts on severity 16 errors be desirable? [closed]

Errors for severities beyond 16 are standard. Such errors are signs of really serious problems. I've noticed that this script here includes alerts for severity 16. To my knowledge, severity 16 errors ...
J. Mini's user avatar
  • 545
-3 votes
0 answers
30 views

Logical Comprehension Question [closed]

Logical Comprehension Question The main idea or primary purpose Information that is explicitly stated
vikas M's user avatar
2 votes
1 answer
130 views

Abnormal behavior in TempdB SQL Server 2019

We have recently migrated from a version of SQL Server 2014 to a SQL Server 2019 CU 26. In all our tests everything went well before performing the migration but when we made the move to production ...
Jose Navarro's user avatar
0 votes
0 answers
43 views

High CPU utilization on an idle SQL Server instance without user traffic

We have an SQL Server 2022 CU13 Enterprise on a Windows 2022 VM with 8 vCPU. The sqlserver.exe process shows a high CPU utilization between 10-15% even when there is no user generated load (meaning ...
Martin Karouš's user avatar
0 votes
1 answer
23 views

Postgres trigger with after and on row appears to not run after writing to row

I have the following two tables: CREATE TABLE qanda.group_questions ( id uuid DEFAULT gen_random_uuid() NOT NULL, category_id uuid NULL, business_model_id int4 NULL, industry_id int4 ...
Magick's user avatar
  • 111
0 votes
0 answers
18 views

INSTEAD OF INSERT ON never gets triggered from continous aggregate (timescale)

I'm trying to make a trigger based on when a continuous aggregate is updated. I had the trigger working on the source table, but when trying to add it on the aggregate: CREATE TRIGGER ...
Cyberwiz's user avatar
  • 101
1 vote
0 answers
23 views

How to audit server settings configuration changes other than view server state?

I want to capture the audit of server configuration settings changes. For this I setup the SERVER_OPERATION_GROUP audit event. This event is raised when Security Audit operations such as altering ...
variable's user avatar
  • 3,476
0 votes
0 answers
16 views

Postgres Barman archive command failed

For production environment, I am using this archive command in my postgresql server. barman-wal-archive backup pg /var/lib/edb-pge/15/data/pg_wal/%f Now when I manually run this command on my ...
Lai Ba's user avatar
  • 1
0 votes
0 answers
17 views

Migrating Cassandra cluster between different AWS accounts

Note: The two different accounts could be as well two different physical locations. I would expect the answer to not change based on such a detail. I have a DSE 5.1.x production cluster of 6 nodes + ...
MASL's user avatar
  • 63
0 votes
1 answer
37 views

sql server client network utility - how to list the aliases?

there is something called sql server client network utility it lives on C:\Windows\System32 for 64 bits. as you can see I have many aliases there, server, instance and ip address and port used for ...
Marcello Miorelli's user avatar
0 votes
0 answers
19 views

postgresql (15) Python event_trigger

What's the syntax used to write a Postgresql event trigger in Python? This CREATE OR REPLACE FUNCTION log_schema_changes() RETURNS EVENT_TRIGGER LANGUAGE plpython3u AS $$ import plpy plyp.warning(...
gerardw's user avatar
  • 103
0 votes
1 answer
23 views

Adding FK to a newly attached partition slow

We have a partitioned table from which we attach and detach partitions for archiving purposes. When attempting to add a foreign key on the partitioned table, the process is taking a long time (up to ...
Krishnp92's user avatar
0 votes
0 answers
25 views

Whats needed to be changed if I'm moving SSRS DBs from a prod env to a test one?

I’m a bit confused on how I move the reporting database (and the temp one) from prod to test. I know after moving DBs I need to export its encryption key, but I would like to not cause any report to ...
Racer SQL's user avatar
  • 7,416

15 30 50 per page
1
2 3 4 5
2080