All Questions

Filter by
Sorted by
Tagged with
-4 votes
0 answers
39 views

MSSQLSERVER service stops randomly [closed]

We have a Windows server running SQL Server 2019 Developer Edition. Randomly it is happening that the MSSQLSERVER service is stopping; it has been set to run automatically; we have to manually start ...
user206045's user avatar
0 votes
2 answers
49 views

SQL Developer edtion as a new node within an Enterprise Availability Group

We currently have a 2 node Availability Group in our test environment running SQL Server 2017 Enterprise Edition. I need to downgrade these both to Developer edition, since we are not using this in a ...
user3346030's user avatar
0 votes
2 answers
28 views

PostgreSQL16 on Windows - Clean up pg_wal archive location

Local pg_wal is cleaning up like it should. And pg_wal\archive_status has all the file with .done (Example: 0000000100000004000000DE.done). Archive_mode is set to on and archive_command is copying to ...
Student's user avatar
  • 29
0 votes
0 answers
10 views

How to change pgpool role automatically when pg_role changes after patroni cluster switchover leader?

I try to use pgpool-II as loadbalancer to distribute select queries to replica and other dml queries to leader in my patroni cluster. After switchover on Patroni cluster, pgpool can not recognize ...
Melih's user avatar
  • 284
0 votes
0 answers
12 views

Using mysql 8.3 database intro mysql 8.0 causes inability to login in a Laravel app

I am working on a Laravel app with a weird setup. Initially, it was configured to run on MySQL 8.0.* without docker then we moved to docker with mysql 8.3.*. Now I have to move the database outside ...
Petar Vasilev's user avatar
0 votes
1 answer
41 views

Cannot disable Query store due to QUERY STORE ASYNC LOAD

I'm using Microsoft SQL Server 2016 (SP2-GDR) (KB4505220) - 13.0.5101.9 (X64). One of our databases seem to have a run away Query Store with over 90 gb stored. I want to disable QS, but cannot do so ...
siggemannen's user avatar
0 votes
0 answers
14 views

How to get last executed statement on a particular table in Oracle?

Trying to identify what ghost process is inserting records into a particular table. Is there a way to get the exact query?
Dhaval Mohandas's user avatar
1 vote
1 answer
26 views

Optimize MariaDB for Drupal 10 to handle more users

I have problems with my Drupal 10/MariaDB 10.5/PHP 8.1 website when they are 20 users simultaniously. The website goes down and the response time is really big (up to 30seconds sometimes) because php-...
mt.i.1's user avatar
  • 11
0 votes
0 answers
20 views

Attempting to Switch from MariaDB FKM to Hashicorp Vault Key Management

I've been trying for a good few months now to switch our MariaDB 10.5-Enterprise servers over from File Key Management to Hashicorp Vault key management. We have 13 'regions' each with 3 MDB servers ...
Teemkill's user avatar
3 votes
1 answer
170 views

Finding all the index corruptions in the entire Postgres DB

There is DB with unknown amount of corrupted unique indexes. Currently I discover them one by one when I try REINDEX DATABASE CONCURRENTLY <db_name>, handle the specific duplication violation (...
KaliTheGreat's user avatar
0 votes
0 answers
35 views

Why reading data in Postgres requires lock?

Using AWS Postgres, I am seeing some issues with LWLock:lock_manager. While investigating the issues, I've found this article. I can't understand why READING data requires any kind of lock? And why ...
Maciej Pszczolinski's user avatar
0 votes
0 answers
23 views

MySQL - JSON type - Data too long for column

I have created a table with one JSON column. I tried to add huge amount of JSON data to this column. When I do this, an error is thrown saying Data too long for column 'column-name'. I tried to search ...
Chetan Oswal's user avatar
-2 votes
1 answer
32 views

What's your "best" backup strategy for multi-hundred-gb tables?

TL;DR What is "your" best backup strategy to bring multi-hundred-gigabytes database back online in (hopefully) less than a day. Ha. Adding to the TL;DR, it seems like raid1/10 is the "...
alturic's user avatar
0 votes
0 answers
23 views

Cassandra nodes show other nodes as unreachable

Nodetool describecluster shows unreachable nodes even though the nodes are UN. Netstats output shows the connection established with port 7001 for the nodes which are shown unreachable. Cassandra ...
Solver's user avatar
  • 1
0 votes
1 answer
11 views

Update to gStore database is lost after restarting the command line query interface?

I'm using the command line mode of querying (gquery) of gStore. First I created an example database using bin/gbuild -db test_db -f test_db.nt, where test_db.nt contains only one line of text: <a&...
Misty P's user avatar
0 votes
1 answer
17 views

Select random records until a cumulative total is exceeded

I have a table of videos with an id, skill_level and duration column and I am attempting to write a query that will return a playlist of distinct videos that has a total duration exceeding X. select ...
Ashley's user avatar
  • 103
0 votes
0 answers
38 views

Probably missing something simple, source of ERROR 1146 (42S02): Table doesn't exist error

Looking to import a mysqldump .sql file into a new db. Have tried both via command line and directly within a mysql session. The following call gives the assocaited error: chris@chris-X1C6:/media/...
Chris's user avatar
  • 181
1 vote
1 answer
44 views

Is my schema "correct"?

Is my proposed schema below prone to make overly complex and slow running queries? Is there a better way to layout this database? The situation: I have no formal DBA training. tl;dr section below this ...
HDL_CinC_Dragon's user avatar
1 vote
1 answer
53 views

What foreign key should I store from users table or clients table?

Let's say I have a table called users that contains basic user information like email and password and I also have a table named clients. A client is a type of user, so that it will have a field that ...
Thiago Guimarães's user avatar
-1 votes
1 answer
21 views

POSTGRES : Data import

DB Version : 13.x Source table schema\ CREATE TABLE mig_bus_data mig_id SERIAL, mig_data JSONB Target table schema\ CREATE TABLE BUSINESS id UNIQUE SERIAL, data1 <TYPEx&...
CSP's user avatar
  • 11
0 votes
0 answers
24 views

Using redis keyspace notifications to know which member was added to or removed from a set

My use case is that whenever a member is added to or removed from a set, a keyspace notification should be triggered that has information about what member was added or removed and put that pub/sub ...
Saad Ahmed's user avatar
0 votes
0 answers
33 views

Can my database LDF and MDF files go into this directory?

Is there a way to determine, given a drive and a directory, if a CREATE DATABASE command would succeed? There are basically two questions here. 1. How do you determine if a simple command like this ...
Null Pointers etc.'s user avatar
0 votes
1 answer
44 views

how to get explain plan from pl/sql function call?

consider this working pl/sql block: declare o_result boolean; io_error varchar2(30000); tab1 someTable1; tab2 someTable2; begin tab1(1).col1 := 'str'...
rado's user avatar
  • 119
0 votes
0 answers
64 views

Using R and Python with SQL Server 2022 not possible

I want to use R and Python with SQL Server 2022, but I get an error if I try to exec the Python syntax. I did everything that Microsoft recommends: https://learn.microsoft.com/en-us/sql/machine-...
PeterWolfe's user avatar
0 votes
1 answer
44 views

How to set Account for SQL Server service in configuration file?

I want to install SQL Server 2017 by configuration file and I cannot find as can I set into Account for SQL Server service {SQLSVCACCOUNT = ?} value that will select log on as Local System account. Is ...
user avatar
-1 votes
1 answer
49 views

When patching SQL FCI, how to ensure there will not be a failover to the node being patched?

This is about patching a 2 node SQL FCI. Say node1 is the current active node. When I am patching the node2, how do I ensure that there won't be a automatic failover to node2 even if node1 crashes ...
variable's user avatar
  • 3,541
1 vote
1 answer
117 views

Performance degradation after migrating from SQL Server 2016 to SQL Server 2022

I have migrated our load test environment from SQL Server 2016 to SQL Server 2022 (Developer edition). Here are some findings: Changed compatibility level of databases to 160 (for SQL Server 2022) - ...
user3510083's user avatar
-1 votes
1 answer
64 views

MySQL design and best design practices

I am designing my first database for a mobile application, which is also planned to be developed into a web application. The photo shows the part responsible for user authentication and information ...
GetReady's user avatar
0 votes
1 answer
57 views

SQL Server - moving databases to an earlier version - options

I have inherited a vendor product. It’s currently very old, having been installed in 2013 and never updated in the 11 years since. The database server it’s using for its 3 database is SQL Server 2008 ...
fiveeuros's user avatar
0 votes
1 answer
40 views

Can I password protect a specific ms sql database view?

I have an MS SQL database with a View that contains sensitive data in one column. Typically, users will consume this View in Power BI. As additional security, is it possible to password protect the ...
jbyrne's user avatar
  • 1
2 votes
2 answers
171 views

What SQL Server server-level roles allow you to add users to database-level roles?

In SQL Server 2022 (on-premise), I have a login (call it 'UserManager') which I have added to the ##MS_DatabaseConnector##, ##MS_DatabaseManager## and ##MS_LoginManager## fixed server-level roles. The ...
DGreen's user avatar
  • 121
0 votes
2 answers
40 views

Mysql count Same Two or More Same Record as One and Summarize It

Good Afternoon all, I have two same data record or more in MySql table. How i can counting the same data as one and zero if have only one data based on flag status pair. Below is an example of data: ...
epm.007's user avatar
  • 29
-1 votes
0 answers
23 views

Oracle: How to figure out why my query is slow?

I have a query causing me some headaches. I'm a Dev and not SQL expert which mostly means no experience reading and understanding explain plans. On top of that due to proprietary data I can't share ...
beginner_'s user avatar
  • 211
0 votes
1 answer
21 views

Clarifications on Maintenance jobs & CDC on upgrade to ENTERPRISE EDITION

Raising these on behalf of our DBA team. We are looking at moving to ENTERPRISE SQL SERVER 2022 soon and would need help clarifying a few things: We are looking at a 3-NODE setup: (1) NODE-1: Primary (...
S T's user avatar
  • 1
0 votes
0 answers
11 views

How to migrate from Oracle 11g Single Instance residing on a Azure Linux VM to Oracle 19c RAC?

What are the different ways to migrate from Oracle 11g Single Instance residing on a Azure Linux VM to Oracle 19c RAC on Azure VMs?
Sunil Bopanna's user avatar
0 votes
1 answer
36 views

ORA-19504: failed to create file "bh2jk0h7_1_1"

I want to create a script to get incremental backup of the remote Oracle database every week. I save this command in rman_command.sh and give permission to it: BACKUP INCREMENTAL LEVEL 0 DATABASE ...
M_Gh's user avatar
  • 101
-1 votes
0 answers
13 views

Detailed steps for taking backup from Enterprisedb and restore to Community version Postgresql

Could you please provide detailed steps for taking a backup from EnterpriseDB(V 11.13.23) and restoring to the Community version (V 12.18) Postgresql
Cassandra Thrift's user avatar
1 vote
2 answers
103 views

Prevent users from sending an email attachment in sql server

In SQL Server, I want to restrict all users (except a few specific users) to send an email with attachment. For example, someone import data into excel file and send it via mail using the ...
Farid Zahidov's user avatar
0 votes
1 answer
10 views

Unable to take incremental backup because of binlog size is more than 1gb

Even if I forced fixed in configuration file and by using global variables to 1gb... Some binlogs are getting more than 1gb to 15gb... And while importing those big binlogs data mismatch is coming......
user avatar
0 votes
1 answer
33 views

How does Cassandra achieve strong consistency with failed writes if there is no rollback and no two phase commit?

Looking for concrete evidence (documentation or source code) on the behavior of cassandra 3.0+ on the following situation Write of key1, value1 is requested with consistency level of QUORUM but only N ...
olaf's user avatar
  • 123
0 votes
0 answers
30 views

SQL Query group by to find EffectiveFrom and EffectiveTo Dates for repeating key value pair

I have a table with a snapshot of repeated data for a key and value pair with record_timestamps. The dataset can also contain late-arriving historical record_timestamps as well. I want to generate an ...
user137279's user avatar
0 votes
1 answer
32 views

Postgres: replication conflicts with append only table and no interaction from read replica

I'm having trouble with canceled queries because of replication conflicts. Specifically, I get the message User query might have needed to see row versions that must be removed event if no deletes are ...
LoveToCode's user avatar
0 votes
0 answers
45 views

How to convert a function into a Stored Procedure in Microsoft SQL?

I have this function that takes a decimal parameter and returns a varchar CREATE FUNCTION dbo.NumberToWords(@Number DECIMAL(18, 2)) RETURNS NVARCHAR(MAX) AS BEGIN DECLARE @Words NVARCHAR(MAX) SELECT ...
Luis Avalos's user avatar
-2 votes
1 answer
13 views

Downgrade SQL of a managed instance

In an attempt to stay up to date , we opted for a managed instance in azure to support our SQL database. Our application only goes up to version SQL 2019 but the managed instance is SQL 2022. Is there ...
isshaida's user avatar
0 votes
2 answers
80 views

What is taking backups of my servers?

I am working in virtualized environment. All my SQL instances are hosted on Windows Server machines. My infrastructure team is using Veeam tools for backups and replication to the secondary data ...
Radek Gąska's user avatar
1 vote
1 answer
18 views

In MS Studio how to SELECT from an existing SQL file

I have a complicated query that select parts from an MRP table using several different criteria. The output of the query is a list of parts which includes the key field [PartNum]. I have saved this ...
TonyG614's user avatar
0 votes
2 answers
21 views

How to query two tables and get the rows from one mask the ones from the other?

WHAT I HAVE I have two tables with the same structure. We can say that one is the main table, while the other is a side table, meaning that each row tracks an edit to a corresponding row from the main ...
Daniele's user avatar
  • 111
3 votes
1 answer
769 views

Why Isn't Postgres Using My Functional Index?

I have a public copy of the Stack Overflow database here on AWS Aurora Postgres 15.5: Server: query.smartpostgres.com Username: readonly Password: 511e0479-4d35-49ab-98b1-c3a9d69796f4 The users ...
Brent Ozar's user avatar
  • 42.9k
0 votes
0 answers
17 views

RMAN ERROR: BACKUP command not found

I have an Oracle database 19c with IP, x.x.x.a that have a lot of important tables. I want to get backup of that and save it on another system with IP,x.x.x.b. I did this actions on the x.x.x.b system:...
M_Gh's user avatar
  • 101
0 votes
1 answer
24 views

How to recover the standby database after opening

If I have standby which is db role is PHYSICAL STANDBY and it is MOUNTED. So, when I open it read/write the standby will be destroyed. (I have DataGuard) So, basically do I need to mount it again and ...
paganini's user avatar
  • 118

15 30 50 per page