All Questions

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

Info on temp table left over on InnoDB data dictionary after a crash while a alter table was runnig

After a database crash while the system was running an alter table command I'm getting the following message during mysqld initialization: 2024-02-25 19:58:48 7fa2f9e84880 InnoDB: Operating system ...
Vaiks's user avatar
  • 1
0 votes
0 answers
4 views

When I open XAMPP and click the start MySQL button, it gives me an error

2024-02-07 7:40:50 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 1524 2024-02-07 7:40:50 0 [Note] InnoDB: Mutexes and rw_locks use ...
user avatar
0 votes
0 answers
10 views

Relational Algebra Practice Question

I am a bit confused about the difference between a Cartesian Product and Join in a Database using Relational Algebra. If I have a table Movies that has primary key attribute Lead_Actor, foreign key ...
Jose Serra's user avatar
0 votes
0 answers
13 views

Need help to get a server to login to SQL Server database

I created a virtual machine (VM) on Azure to host Sparx Enterprise Architect cloud-based repositories using Pro Cloud Server (PCS) https://sparxsystems.com/products/procloudserver/30-min-tour/index....
sys_eng's user avatar
0 votes
0 answers
4 views

Options for automated refresh of 300GB from on-premise to cloud?

We have a requirement to move about 300GB/day of telemetry data from an on-premise collector to a Palantir Foundry Cloud system. Updates should be incremental and occur every 10 minutes. Additional ...
Dr.YSG's user avatar
  • 399
0 votes
0 answers
16 views

Do stolen pages (as in sys.dm_os_performance_counters) report anything that sys.dm_os_memory_clerks does not?

I have been under the misconception that SELECT * FROM sys.dm_os_performance_counters WHERE counter_name LIKE 'Stolen Server Memory%'; shows how much memory the OS is stealing from SQL Server. The ...
J. Mini's user avatar
  • 139
1 vote
1 answer
17 views

Merging information from multiple rows into one row

I have three tables event, person and event_person_map event: id integer PRIMARY KEY event_name text event_date date person: id integer PRIMARY KEY full_name text email_address text event_person_map:...
Lugoom485's user avatar
0 votes
0 answers
14 views

Getting OOM when trying to change id from int to bigint in MySQL w/ percona

We have 2.5tb table with id column as int. We need to change it to bigint as ids will run out soon. We tested it with pt-online-schema-change and the server crashed because of memory. I was a bit ...
Nir's user avatar
  • 513
0 votes
0 answers
18 views

Updates and Row Level Security - No Difference Issue

We are using RLS (row level security) in SQL Server 2016, yet we're seeing no difference in effect with using BEFORE versus AFTER in our update block predicate. Using the below code as an example for ...
rclouder98's user avatar
0 votes
0 answers
39 views

Are SERIALIZABLE deadlocks avoided or just detected?

SERIALIZABLE is the highest standard isolation level. It avoids dirty reads, phantoms,... by ensuring that, whatever happens, the ultimate result of a transaction schedule is equal to the result of a ...
A. Darwin's user avatar
  • 119
0 votes
0 answers
6 views

Understanding User Creation in MongoDB: admin Database vs. Other Databases

I'm in the process of setting up user accounts within my MongoDB environment and I'm looking for some clarity on the best practices for where to create these user accounts—specifically, the ...
Just a learner's user avatar
-2 votes
1 answer
30 views

Best Practice for full backup and transaction log truncation [closed]

I am new to SQL Server DB. Could someone please let me know what would be the best practice to do a full backup and truncate the transaction log. If you could please let me know the strategy you are ...
ab san's user avatar
  • 9
0 votes
0 answers
27 views

log_reuse_time_desc is ACTIVE_BACKUP_OR_RESTORE

After dropping database replication and subscriber, the database's option log_resue_wait_desc turned from replication to ACTIVE_BACKUP_OR_RESTORE. I should I do to return it into NOTHING value
Abdelrahman Mamdouh 's user avatar
0 votes
1 answer
16 views

How to store historical correlation matrices?

Every day we calculate the correlation between ~40 different financial instruments and want to be able to store them in our PostgreSQL database. What would be the best way of storing these values? We ...
futium's user avatar
  • 1
0 votes
0 answers
14 views

Is this a good definition of schema migration?

I'm trying to preserve the meaning of the English word 'migration' in the definition, and I think I might be able to do that without making up a fake definition. Here goes: A schema migration is the ...
Joel's user avatar
  • 1
0 votes
2 answers
50 views

Finalize GroupAggregate parent using Partial HashAggregate child nodes in Postgres query plan

I have seen in some query plans that the parent is a Finalize GroupAggregate but its child nodes are Partial HashAggregates. When does this make sense? As an example, I have a query that resembles ...
ahron's user avatar
  • 793
0 votes
0 answers
14 views

Sequel Ace missing list of tables component

I am using Sequel Ace (version 4.0.13 on Mac) to access a database. There used to be a list of all the tabels in the database in a component on the left side that is now missing. I cannot figure out ...
JayG's user avatar
  • 1
0 votes
0 answers
23 views

Unresponsive restore process for log shipped db having memory optimised tables

Log shipping documentation has a caution: https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server?view=sql-server-ver16 Known issue: For databases with memory-...
variable's user avatar
  • 3,541
0 votes
1 answer
33 views

Point in time Postgres restore

I was trying to do Point in Time Restore, I had my placed by previously backed up WAL file in my directory to where my restore command (/var/lib/postgresql/16/main/pg_wal/wal_archive) in postgres.conf ...
Руслан Пилипюк's user avatar
1 vote
1 answer
55 views

how can I see how many records have been affected by a transaction before it is committed? or how costly would be the rollback if I have to kill it?

I am using sqlwatch to monitor some of my servers and it has a job that deletes in batch from a table called dbo.sqlwatch_logger_snapshot_header I had lots of problems of locking and blocking as this ...
Marcello Miorelli's user avatar
0 votes
1 answer
9 views

Restoring incremental backup of Postgres

I have restored basic backup successfully of Postgres. However, after that I have tried to restore incremental backup of Postgres(it was a couple of write to test table), and it had a couple of WAL ...
Ruslan Pylypiuk's user avatar
0 votes
1 answer
14 views

Is there a way to verify if a SSIS instance was configured as a cluster resource or not?

We had 2 servers in a cluster ( no aoag ) with SQL + SSIS. one of the cluster nodes died and we removed it. we are in the plan to create a new cluster node and configure SQL engine normally on it as a ...
Racer SQL's user avatar
  • 7,394
0 votes
1 answer
15 views

MySQL services fails to start successfully after copying MySQL Data Directory from another server

Purpose 1 - The running application should not be stopped and run 24*7 while backup or copy MySQL data directory (/var/lib/mysql). Purpose 2 - To backup MySQL files directly and copy on another server ...
Vijay Singh's user avatar
0 votes
2 answers
21 views

List of characters managed by a collation

I'm migrating to MySQL 8.0.33. We are changing character set to utf8mb4. For collation, I'm wondering among different options. I'm looking for documentation to review the list of characters that are &...
yaki_nuka's user avatar
  • 141
0 votes
1 answer
13 views

How to cancel vacuum process in AWS RDS PostgreSQL

Is there a way to cancel an automatic vacuum in rds postgresql? When running select pg_cancel_backend(...); select pg_terminate_backend(...); with a user that has the rds_superuser role an error ...
Vasileios Giannakidis's user avatar
-2 votes
0 answers
21 views

Which is the right choice for an app dating ScyllaDB or MongoDB?

How does ScyllaDB compare to MongoDB in terms of handling semi-structured data and schema flexibility? Are there any third-party solutions or workarounds needed to achieve similar functionality? How ...
Farshad's user avatar
  • 97
-1 votes
0 answers
18 views

I want to migrate a oracle database from one server to another server using datapump export utility.could you please explain it step by step

I am new to oracle and also migration but wants to learn how to migrate a oracle database from one server to anotherserver using datapump export utility.please help me with step by step explaination.
jyothi d's user avatar
0 votes
1 answer
34 views

Postgres: how to insert and delete many records and to not run out of space

I have a PostgreSQL installation deployed in Kubernetes (with the CloudNative operator) and allocated a 25GB volume for it. My architecture involves several microservices interacting with various ...
Tertium's user avatar
  • 141
0 votes
1 answer
18 views

Routing List Empty, and cant add using SQL either

Question: Why is my routing list empty? I have removed the secondary from the AG and re-added back, everything is healthy and synchronized. lets assume for the example that server1 is currently the ...
Mike Kay's user avatar
0 votes
2 answers
25 views

PostgreSQL plan cache and variable number of arguments

Query: select * from table where col in ( values (?), (?), (?) ) The query text is generated, and number of (?) is variable and up to 10000. It works just fine, just wondering, whether Postgres ...
Mikhail Boyarsky's user avatar
3 votes
2 answers
236 views

What is the effect of using different COLLATE values in a WHERE clause?

I read the documentation 'Using COLLATE in SQL Statements' https://dev.mysql.com/doc/refman/8.0/en/charset-collate.html, but it doesn't say much about the effect of using different COLLATE values to ...
Computist's user avatar
  • 163
0 votes
0 answers
15 views

Multiple resultset from mariadb procedure

I am trying to return multiple resultsets from (phpmyadmin) mariadb procedure but am failing. For example I have two tables Entities and Relations and for a test I created a procedure to select ...
user1806687's user avatar
0 votes
0 answers
15 views

Error mysqlimport loading to symlink table

Getting ERROR 1030 (HY000): Got error 168 - 'Unknown (generic) error from engine' when trying to import a .sql file produced via mysqldump. Running MySQL 8 on a Ubuntu 22.04 system. chris@chris-X1C6:/...
Chris's user avatar
  • 181
-2 votes
0 answers
13 views

Postgres - Add business days to timestamp

I'm trying to create an SLA date by adding 2 business days to a timestamp, how do a achieve this in postgres? I saw one post talking about date types but the solution did not work with timestamps ...
Mankind1023's user avatar
0 votes
0 answers
26 views

How automate backup and restore in Azure SQL Managed Instance?

I'm the DBA of one Azure SQL Managed Instance and one of our clients asked us if is possible automate a backup and restore in order to have a copy of one of the database before one of our ETL procces ...
SakZepelin's user avatar
0 votes
2 answers
12 views

PostgreSQL enforcing order dependent constraints within a query

Is there a best practice for enforcing the order in which constraints are applied? We have seen a few queries where the optimizer has reordered the results and passed rows through a constraint and/or ...
Justin Lowen's user avatar
0 votes
0 answers
14 views

SSIS package failing when trying to deploy : Assembly Error

I had a 2016 sql server and we needed to migrate to 2019 but in doing so we wanted to keep the same IP & hostname as it was the easier route for other apps that connect to this server to still be ...
WhoIsNotActive's user avatar
0 votes
1 answer
30 views

Why a consistent backup still requery recovery in Oracle?

My database was in mount state and we perfomed a backup of the database. backup database format '/backup/db_full%U.bkp'; So, when restoring it, I can't simple use: Restore database; alter database ...
Astora's user avatar
  • 703
3 votes
2 answers
176 views

Snowflake won't allow an analytic function to be renamed

In the code below, I can do the LAG and PARTITION BY with no problem as a query. But I need it as a table. If I do CTAS, I need an alias on the column. But when I try to put an alias on it, it fails....
James Madison's user avatar
0 votes
1 answer
32 views

Oracle 19c and 21c expdp exports dumpfile of 308kb without any content

Trying to export schema using the following command on several Oracle instances: two 19c and one 21c $ expdp mySchema/myPwd@ORCL Adding CONTENT=ALL or SCHEMA=mySchema or SCHEMA=MYSCHEMA or DUMPFILE=...
Vy8's user avatar
  • 1
-1 votes
0 answers
21 views

SQLServer and memory usage [duplicate]

I have a Windows Server 2019 with SQLServer 2019 Standard Edition. The server has 48Gb Ram + 7 Gb in swap. I saw that SQLServer uses over than 50Gb. There is something to set to force it to act on how ...
Lucio Menci's user avatar
2 votes
2 answers
87 views

Finding encrypted SQL database instances in our SQL Server Estate

Is there a quick way to find SQL Server instances across our whole SQL Estate that hold encrypted (SQL TDE) whole databases or database table columns?
PTL_SQL's user avatar
  • 325
1 vote
2 answers
29 views

Is there a way to calculate a column based on an expression of other columns?

I'm looking to select a column that's based on the value of other columns. The use case is that I'm interested in intermediate values of a complicated expression. Something like: SELECT 1.0 as avg, 2....
ijustlovemath's user avatar
0 votes
0 answers
10 views

XAMPP MySQL database problem

I am working on Microsoft Windows 11. Occasionally (seems random), when I open XAMPP it appears to open an old version of my MySQL database. When this happens, all new information I entered on a ...
Nugget's user avatar
  • 1
0 votes
0 answers
81 views

issue with dynamic query and complex logic problem

I am working with dynamic query SQL WITH WINFORM(C#) DROP TABLE IF EXISTS #TB,##tmp SELECT EVENT_ID, CASE WHEN ALL_FAMILY = 1 THEN 'ALL_FAMILY' WHEN FAMILY = 1 THEN 'FAMILY' ...
rahul's user avatar
  • 1
1 vote
0 answers
60 views

SQL Server not using index in aggregates [closed]

We have a large table called 'TransactionTable' with around 20 million records and there's a index cover all columns used in below query. We also have a temporary table called '#TempTable' with around ...
Blangero's user avatar
0 votes
0 answers
18 views

Index field with all same value. Is this bad?

I have the following index create unique index open_issues_unique on issue (status, type, reference_id) where status = 'OPEN'; This means the value of the column status will always be OPEN. Does this ...
Herr Derb's user avatar
  • 113
0 votes
0 answers
33 views

invalid username/password; logon denied with kerberos authentication

I am attempting to configure Oracle with Kerberos. I have completed all of the necessary configurations and have obtained a ticket. However, when I run SQLPlus /@ORCL, I receive the following error: C:...
SK1's user avatar
  • 1
0 votes
0 answers
50 views

SSMS User Mapping Slow to Load, or Not Responding

I have been experiencing an issue in SSMS versions 14, 18, and 19, where loading the User Mapping of any given Login takes an age to load, sometimes up to an hour, or just never loads at all and hits ...
L.Moy's user avatar
  • 5
1 vote
1 answer
43 views

Can the plan cache be used to diagnose a lack of RAM?

I have learned a few good ways to diagnose a lack of RAM on a SQL Server and I am wondering if I should add the plan cache to this toolbox. A sign of lacking RAM is that the plan cache doesn't live ...
J. Mini's user avatar
  • 139

15 30 50 per page
1
2 3 4 5
2055