All Questions

0
votes
0answers
3 views

Oracle Apex 19.1 XDB log-in problem

I have an Oracle 18c database running and I have installed Oracle Apex 19.1. I have validated that the installation has completed successfully. When I try to open "localhost:port/pls/apex/apex_admin"...
0
votes
0answers
6 views

RMAN restore error to restore archivelogs

I have this backup piece with the archivelogs: BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ------------------- 54 1.01M DISK ...
0
votes
0answers
4 views

Run a count query for every row ID in results

I'm trying to count the number of cars at each parking lot in my app, along with some other info. But, I'm not too sure how to approach this. Tables I have 3 tables. lot - this table contains ...
0
votes
0answers
6 views

Microsoft SSMS 2018 cannot open (only the splash screen)

yes, i've read this SQL Server Management Studio 18 won't open (only splash screen pops up) , it work the first time. after i restart my computer, and try to open smss again, the problem happen ...
0
votes
1answer
7 views

Will too many tables slow Mysql down?

I'm making a database which should be able to handle over 1,000,000,000 rows. in order to optimize it's performance i've decided to split tables. so instead of having 1,000,000,000 entries in one ...
2
votes
0answers
8 views

Is it safe to use Strings instead of SqlStrings for CLR function input parameters?

I have a CLR scalar UDF implemented through C# code. I've noticed that using the String data type for input parameters significantly improves performance compared to the SqlString data type. In ...
0
votes
1answer
9 views

If I move my SQLdata file from my F drive, delete the F drive, and rename the new Drive F will I have any file path problems?

I have a windows server that only had 50 GB on the C drive and 4TB on the F drive. I need to exstend the C drive but the only way to do that is by deleting the F drive to reallocate space. If I move ...
0
votes
1answer
9 views

Data Warehouse Modeling: Sales Order Charges

I have two databases systems that I'm trying to dimensional model a sales order business. Both operational data stores have a Sales Order header and detail table. However, one of them has an ...
0
votes
0answers
13 views

How to fix ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER error

I'm getting below error while executing PS script Error Code: ERROR_SCRIPTDOM_NEEDED_FOR_SQL_PROVIDER More Information: The SQL provider cannot run because of a missing dependency. Please make sure ...
0
votes
0answers
7 views

How to get the corrupted table from a log file in hex?

I'm running a Magento 2 site, everyday we have a MySQL shutdown because of some corrupted data, we don't know the table causing the issue, this is what the error logs shows: Version: '5.7.26-...
0
votes
1answer
16 views

SQL USING CAST in a query inside a stored Procedure

I was trying to use a query inside an Stored procedure which has a cast funtion. But when executing the SP I'm getting an error Conversion failed when converting date and/or time from character ...
-1
votes
0answers
10 views

Restart MySQL server

I want to know the best way to restart MySQL 8.0 server running on production? Because there are data coming every seconds. I tried to restart and it took almost 1 hour, yet still not able to restart ...
1
vote
0answers
13 views

Cannot systemctl start/stop mssql. mssql-server stuck in script upgrade mode. Cannot login either

I'm having trouble getting my mssql-server back online. Apparently it got stuck between an upgrade and a bad database restore, and now it is stuck, and I nothing I've tried has helped to unstuck it. ...
-4
votes
0answers
19 views

Triggers and procedures [on hold]

Based on the following tables, please answer the questions below:
0
votes
0answers
28 views

Select exact subset from table

I want to select an exact subset from a table. DDL to create table: CREATE TABLE groups (group_id NUMBER, activity_id number); INSERT INTO groups (group_id, activity_id) values (1,1); INSERT INTO ...
0
votes
0answers
8 views

php list box showing same row multiple times

I am populating a list box in php from a database the problem is the same value is showing up in the listbox for as many record there are in the database. such as expected values in the list; * bob ...
0
votes
0answers
18 views

how to divide and insert post value integer data in mysql two column using php?

<form> Service fee : <input type="text" value="300" name="gst"> <select> <option>CGST 9% AND SGST 9% on service fee</option> <option>IGST 18% on service fee</...
0
votes
1answer
26 views

Having a backup of the master key, how can I restore a database that was encrypted by master key?

while setting up AlwaysOn - Availability Group on a test system, I generated all the restores from live and restored them to this new server. then I backup all these databases to a network share to ...
0
votes
1answer
18 views

MySQL: Can not add foreign key into create table statement

The queries below (assigned to php variables) seem to have an issue on the 2nd query, where I set the foreign key to the "couponId" column on the first table. My IDE lints "couponId" (inside the ...
0
votes
1answer
29 views

PostgreSQL, Stored Procedures, Recursive call Tree structure

I'm faced with a problem.I have a ternary structured data. The relation is from child to parent, more specific a child has an parent_id. A parent shouldn't have more than 3 children. When 4th child ...
0
votes
1answer
13 views

PSQL incomplete backup : how to debug

I've been doing backups of my database " screen ". after connecting to PSQL and typing \l+ I'm getting (among other things): Name | Owner | Encoding | Collate | Ctype | ...
-1
votes
0answers
30 views

Update thousand records with primary and foreign key

I am a beginner when it comes to SQL (SQL Server) and I hope you can help me. A warehouse database, where we have a tl_warehouse_items table for example, which contains over 50,000 different items ...
0
votes
0answers
18 views

what is the relationship between product and stock?

My assumption is that it can be many to many as one product can be in many stocks and many product cane be in one stock but in the the original question is that there are 10 store locations where they ...
0
votes
1answer
21 views

How to update value increment by 1 SQL

I have a table name downloads where I need to add value colum order + 1 downloads order Name dlid website 0 Jon 51 A 1 Jim 54 A 2 Jack 55 ...
0
votes
0answers
15 views

View images as query results

I've done lots of research on the topic but I'm drawing a blank. Are their any database engines that can return rendered images in the query response? For example: Select images from fruit where ...
0
votes
0answers
12 views

How can I figure out the root cause of “Out of range value for column” error in MySQL

I have a console app written with C# on the top of .Net Core 2.2 framework with EntityFrameworkCore as ORM. My application runs various tasks that run every 15 minutes. Each task calls an external API ...
0
votes
1answer
17 views

What will be the order of statement execution in this use case?

Say I execute select * from users at t1 which gets finised at t3. At t2(in between t1 and t3) update comes for some of the records in users table say update users set address='xyz' where name = 'abc'....
0
votes
1answer
19 views

Normalisation Help

I am undertaking a project that involves a student management system, but I am struggling to normalise/create relationships between certain tables. Here is my current setup: Models Users(id, first ...
-2
votes
0answers
16 views

How to re-zip sqlite file as a .jet file

I have a .sqlite file and the developer zip it as a .jet file. Now I can open it with 7zip, I can edit the db but at the end I couldn't re-zip again as a .jet file. I tried every solution that I saw ...
1
vote
1answer
23 views

Snapshot on Always On Availability Group in suspect mode

Our configuration is 2 SQL Servers 2016, enterprise edition, 13.0.5026.0, running on Windows Server 2012 R2. Created availability group with one database in it. Database has 3 data files in it, all ...
0
votes
1answer
7 views

Mongo Memory management

I had a few questions If there is sufficient RAM, does Mongo load entire collection into memory? Suppose I had two collections A & B and I know that there is not enough RAM to hold both - and if ...
0
votes
1answer
15 views

Which MySQL shows CPU usage?

I am monitoring MySQL server using phpMyAdmin [Status => Monitor] function. And it shows a number of useful graphs. Which variables (or which mechanism) is phpMyAdmin using to pull this data? ps. ...
1
vote
0answers
11 views

Mariadb master master replication supported by HAPROXY for automatic failover

We have implemented master-master setup in maria-db. Master A is being used for read\write and Master B is used for backups and MIS operations. We have built this setup so that we do not need to ...
0
votes
0answers
25 views

sql query three tables with join

i have 5 tables in my database. that are connected with each other using joins. department table vs course one to many course table vs classes one to many classes vs section many to many. i want to ...
0
votes
1answer
22 views

postgres: using unnest in multiple rows

I have an array column containing information like {a,b,c,a} {a,b,a,b} {b,a,a,b} I want to run unnest on this array column, get the occurence of of each character. a 2 b 1 c 1 a 2 b 2 b 2 a 2 I ...
-1
votes
0answers
14 views

Booking schema advice

I am starting to put together a database to book students on activities for a week. a tutor needs to log in and have access to all students in their tutor group. there are 4 activity slots per day (...
0
votes
1answer
11 views

Subquery to return multiple columns or a JSON object

Is there any way for me to return multiple columns from a subquery or at least return a column that is a JSON object of all of the columns I need? This is a working query that works: select r.*, ...
-1
votes
1answer
8 views

Operand should contain 1 column(s)

Hello I have problem with this query INSERT INTO radacct (acctsessionid,acctuniqueid,username, realm,nasipaddress,nasportid, nasporttype,acctstarttime, acctupdatetime, acctstoptime,...
0
votes
0answers
35 views

Stored Procedure code

I am a beginner when it comes to SQL (SQL Server) and I hope you help me. A warehouse database, where we have a tl_warehouse_items table for example, which contains over 50,000 different items and ...
0
votes
0answers
11 views

Dimensional Model for CRM Sales Opportunity and Sales Leads: Fact or Dimension?

I'm working for a business lender, and trying to come up with a basic dimensional model around the subject area of loan approvals. We use a CRM, (Salesforce) and one of the core objects is a (Sales) ...
0
votes
1answer
29 views

How to setup a SQL Cluster between 2 sites in active passive mode without shared storage

we need to install SQL at 2 sites, 1 primary and 1 DR. We don't to pay for license for the DR and need to know how will we setup a SQL cluster/replication/alwayson/bag or any other method that will ...
0
votes
0answers
15 views

POSTGRES - handle several unique indexes differently in ON CONFLICT clause

I have a table with several unique indexes. Is it possible to ON CONFLICT UPDATE only on one of them and DO NOTHING on all others, handling with DO NOTHING future unique indexes without going back and ...
1
vote
0answers
10 views

How to encrypt a column using aes-256-gcm encryption in PostgreSQL?

As a database point person, I am required to encrypt SSN numbers wherever they are in a table. We use PostgreSQL. My application counterparts require that we use the AES-256-GCM encryption algorithm. ...
2
votes
0answers
17 views

Some basic questions about SQL and TLS 1.0 and 1.2

(I don't believe this is a duplicate of any other TLS-related question, like the authoritative question about SQL Compatibility with TLS or its many duplicates, or questions about specific TLS-related ...
0
votes
1answer
12 views

Recursion on deletion trigger that calls a function

I have the following schema: CREATE FUNCTION myfunc() Returns trigger as $myfunc$ DECLARE someVal integer; BEGIN SELECT Count(*) into someVal FROM MyTable ...
0
votes
1answer
17 views

How to write a query to get concatenated names of riders with the same weight?

I want to retrieve a table with all Riders of the same Weight from a table named Rider, which is defined in this way: CREATE TABLE Rider( name VARCHAR(30), weight REAL, PRIMARY KEY(name) )...
2
votes
2answers
16 views

Inconsistent performance of WHERE and ORDER BY depending on size of WHERE match

Been working with MySQL for 15 years, and never seen anything quite like this before. MySQL table with 4 million records. I have found a very strange "sour spot" (opposite of "sweet spot") in ...
0
votes
0answers
32 views

Refactor SQL to left join on TVF requiring input variable

I would like to join two tables and a table-valued function. The TVF take a date as input variable. The expected output is: Date, LimitName, Exposure, ProductValueEligible, ProductValueNonEligible ...
0
votes
1answer
20 views

Mysql 5.7 - select where json

I have some JSON data stored in a filters column. An example from one row: name | filters ---------+---------------------------------------------------------- John Doe | [{"Year":2004, "SportID":...
0
votes
1answer
11 views

Azure SQL Database patch and update doubts

It is known that Microsoft automates the patch and update of Azure SQL Database. But, some times applications must be tested before being applied any type of patch or update, because there's a ...

15 30 50 per page