All Questions

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

error 1932 table doesn't exist in engine xampp

I am using Xampp in my local pc. My mysql wasn't running, It was closing after starting, I was looking for some answers and found an answer in this forum and thought it would solve the problem. (link ...
0
votes
0answers
16 views

RESTORE VERIFYONLY FROM DISK is failing

We are having WSFC(Windows Server Failover Cluster) configuration for one of database server and from last few days, backup of one of the database is failing. Sometime backup itself fails whereas on ...
0
votes
1answer
8 views

Why does a fresh SQL Server instance with the same details as the original think that my DB backup is in the original location?

So I'm working on a server application for a large government body and need to setup a development environment to test on. For this I'm using a Vagrant-controlled VM with Windows Server 2019 installed ...
-1
votes
0answers
13 views

Changing multiple records with pattern in SQL

I'm using ORACLE, and trying to change multiple records with a query like Linux command 'SED'. For example, there's two rows in a table. PROFILE -------------- JAKOB.G* JAKOB.T* In this case, I'...
-1
votes
0answers
6 views

Restoring an individual table with Xtrabackup to the same server

I have a 3 node Mariadb Galera cluster running. Each node is running Mariadb 10.2.15 (mysql Ver 15.1 Distrib 10.2.15-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2) with Xtrabackup version ...
0
votes
1answer
37 views

How to optimize stored procedure so it won't end with “Out of memory excetoption”

I have created a stored procedure that check against 2 and then delete from the 3. When I execute the stored procedure on Management Studio I get the exception as mentioned in this question: ...
0
votes
1answer
39 views

Sql Server - Multiple errors regarding to memory in error log

MSSQL-Server 2017 Express Edition runs on my Linux server. The server has 4GB RAM. The total size of DB is 300MB. My website and the sqlserver are on the same server, it's a small website with max of ...
-1
votes
0answers
17 views

multiple types of info display from mysql db

I have received great help and direction here recently so I'm back! The project is gathering a list of available care facilities and have the user be able to search the dB. So, i have the ...
-1
votes
0answers
16 views

DBCC checkDB stuck in killed/rollback state

I killed DBCC CheckDB Job of 3TB Database which has been rolling back since 17 hours with 89 %.as i have checked that the SPID running with waittype EXECSYNC. Could we have any other way to clear this ...
0
votes
0answers
7 views

UPGRADE PROBLEM: The data files need to be fully upgraded to version 3.4 before attempting an upgrade to 3.6;

Kindly assist me on following upgrade issue. My Arbiter upgrade (thru yum update -y ) has been failed with following error. 2019-10-19T07:19:25.944-0400 I CONTROL [initandlisten] 2019-10-19T07:19:...
4
votes
1answer
152 views

Why the job's next_run_time is wrong?

I got an issue regarding job stats. So I have a job with the following schedule: Occurs every day every 5 minute(s) between 12:00:00 AM and 11:59:59 PM. Schedule will be used starting on 12/13/2017. ...
-3
votes
0answers
17 views

Migrate VIEWs from Oracle to SQL Server [on hold]

Is there any tool to migrate views from Oracle to SQL Server?
0
votes
1answer
23 views

How to model multiple types of contacts?

I'm not sure if this can be called a polymorphic association - what is needed is to for each Message to have a Sender Contact and a Recipient Contact. Both Sender Contact and Recipient Contact could ...
0
votes
1answer
20 views

Using mysqldump with WHERE clause but WHERE clause only applying to specific table?

This question is related to a question I posted on another StackExchange site. Question: How to apply the --where argument only to a specific table when mysqldump-ing a whole database? So I have a ...
0
votes
1answer
15 views

Computed Column Operand type clash on Date Column When Checking For Null

This error is generated when trying to create a table with a computed column from a Date field. Operand type clash: int is incompatible with date If I comment out the computed column it works. [...
-4
votes
0answers
14 views

Database for Shipping Company [on hold]

To do database in SQL server for Shipping company .. So I need employee page to insert the shipment information then press ok and auto generate track number .. I will give to customer and he can press ...
-3
votes
0answers
39 views

How can I merge multiple rows from a table into one row with certain relations?

When creating a WordPress opensource plugin the following question arises. In Wordpress, different data types are stored in a table, wp_posts. These data types (CPT => CustomPostType) are ...
-2
votes
0answers
20 views

Combine two tables with 2 PK - Table 1 has the column (id12) that holds data for Table 2 column (sub_obje_id) [on hold]

SELECT COUNT(id12) AS PROG_AREA FROM [dbo].[header_record] INNER JOIN dbo.header_record.id12 = dbo.object.sub_obje_id ON (SELECT pool_id AS 'Pool', CASE WHEN sub_obje_id = 4104 THEN 'TV Script' WHEN ...
0
votes
0answers
14 views

Mongo primary failover causes rollback

I have a replicaset that processes largish batches of inserts (a few million) every night. Last night, the primary failed over and went into a rollback state. All clients which access this replicaset ...
-2
votes
0answers
25 views

Nested select statement work procedure [on hold]

I was wondering how nested select statement works. Let me be clear with an example(with an academic example). According to Database system concept of Silberschatz I am using an university database. ...
1
vote
2answers
41 views

Is it possible to write a function in postgresql which directly writes its parameters to a text file?

I have a text file which contains some rows of data,say 10 rows. Each row has 5 columns, each of the type varchar. Is it possible to write a function in postgresql, which takes its parameters as 5 ...
0
votes
1answer
21 views

How to connect two attributes without a PK (MySQL)

I'm a new programmer and I'm doing a database on MySQL with phpmyadmin. I have this doubt - I know that if you want to link two different tables you need an attribute that is a Primary Key, and ...
-4
votes
0answers
26 views

SQL TEST ASSISTANCE [on hold]

Disregard, i will come back with additional info
0
votes
1answer
22 views

GROUP BY with date ranges when values change but then change back

Consider a historical table where a value was changed and then changed back: value | date 3 | 1/1/2019 3 | 1/2/2019 3 | 1/3/2019 4 | 1/4/2019 4 | 1/5/2019 3 | 1/6/2019 3 | ...
-4
votes
1answer
20 views

MySQL returns more than one row with AND operator match

I have two tables 1:n relationship, customer to orders the schema is in the http://sqlfiddle.com/#!9/a6842e/1 I have created. The key in customer is composite id and type. I am trying to get the ...
0
votes
0answers
26 views

Storing 450,000,000,000 data points in a bitemporal datastore [on hold]

I'm really looking for guidance on an appropriate way to tackle persisting and retrieving 450 billion data points. The details: 15,000 equities 15,000 days of history (approximately 40 years) 2,000 ...
1
vote
1answer
12 views

Does postgres single-user mode use postgresql.conf settings?

Does running postgres in single-user mode (--single argument) cause postgres to start and use the settings present in the postgresql.conf file in the data directory defined by the -D option? I am ...
0
votes
1answer
59 views

Without rewriting this query, is there a way to force the query optimizer to better estimate the amount of resources required, e.g. with query hints?

I know there's a couple of alternate ways to write this query, but I'm more curious if there's another approach that I could use to improve the performance by helping guide the optimizer in the right ...
1
vote
1answer
32 views

Restore plan cache and buffer pool after database restore?

When restoring a database, is there a way to restore the plan cache so it doesn't have to be re-created during production use? Similar question: is there a way to pro-actively restore the buffer ...
0
votes
2answers
29 views

How to add time from a Date value to another without a varchar conversion?

Let's say I have 2 variables in a Stored Procedure, both are Dates Foo contains '13/10/2019 00:00:00' Bar contains '01/10/1914 16:33:11' I want to add Bar's time to Foo's date, so that I get a ...
-1
votes
2answers
51 views

Is there a way to increase the speed of the following insert without having to create an unclusterd index being suggested by sql server? [on hold]

Below is a query that we are running that takes a while to run. Table 1 has about 400+ million records with 80 columns (this is a db warehouse table). The index being suggested is on the columnx with ...
0
votes
0answers
24 views

How can I import the fga_log$ table with impdp Oracle 12 R1

I am trying to import with impdp a save made as follows: expdp '"sys/mmm as sysdba"' full=y COMPRESSION=ALL DIRECTORY=LOGICS_EXPORTS COMPRESSION_ALGORITHM=BASIC LOGTIME=ALL CONTENT=ALL DUMPFILE=FULL-...
0
votes
0answers
9 views

Analyze Table running constantly on a few tables

I am seeing a few of my tables constantly having analyze table running on them. How would I determine what would be causing or triggering this and is there a way for me to stop that from running? It ...
0
votes
0answers
21 views

Postgresql v10.1 - How to fix ERROR: duplicate key value violates unique constraint

I'm not sure how this happened to this table but have an issue with ERROR: duplicate key value violates unique constraint trying to use AWS's DMS service to move a postgres v10.1 DB to RDS v10 The ...
2
votes
2answers
46 views

Permissions using a TYPE as a Table Valued Parameter

I'm developing a .Net App that calls an stored procedure that have a table valued parameter declared as a TYPE READONLY. First time I tried to call the SP I received the next error: Msg 229, Level ...
0
votes
1answer
25 views

Insert set value into DB

I'm pulling values from RESTORE FILELISTONLY FROM DISK for multiple backup files into a temp table. I am trying to insert a set value (@dbSet) to a column (@dbSetC) but when running my insert it's ...
0
votes
2answers
20 views

Select data from table join or UDPATE?

I have a question regarding PostgreSQL DB performance. I am given a CSV file with a lot of rows (let's say around 1 million rows) that represents updates to a database table (let's call it MY_TABLE). ...
0
votes
1answer
26 views

Session ID in SQLCMD running multi-batch script

My script contains multiple GO keywords. I know that SQLCMD interprets GO as a batch delimiter, so the code is not run as a single block but instead each part between the delimiters (a batch) is run ...
-1
votes
0answers
13 views

Can you edit DB content, if you can't access phpmyadmin? [on hold]

I've crashed my domain's DNS trying to enter a DKIM entry to my control panel, now I can't access my domain, my control panel or PHPMyAdmin because they all reside on my domain. Is there a way I can ...
0
votes
0answers
35 views

Recommended ways to export large query result to JSON or other text format [on hold]

I am tasked with exporting a settings query result to a text file so it can be imported on other machines. I have a working solution in a WPF project however the problem is that the results are 28K+. ...
2
votes
1answer
36 views

UPDATE column to MIN of a SELECT result set - what went wrong?

I've got the following scenario: I've got a table of assets with standard columns a table of hardware assets with extension columns a history table where all changes to an asset are stored with ...
0
votes
1answer
27 views

Can we copy data from 1 text file to 2 postgresql tables?

I have a text file with some data and I have two similar tables in my postgresql database. Is it possible to copy a part of the data present in the file, say first 10 lines, to the first table and the ...
3
votes
3answers
123 views

SQL log file 2TB is not enough, now what?

This is a hypothetical question, that flows from the answer by sepupic where they explain that 2TB is the physical limit for SQL log file. if you need it more than 2Tb you add the second log file. ...
0
votes
0answers
12 views

what to pass as a key instead of username and password for anonymous users @login?

i am trying to make a mongodb schema in which i am allowing the person to publish projects anonymously, i already have the authenticated user schema and i am thinking of using that only to allow ...
2
votes
1answer
37 views

what could be preventing my transaction log autogrowth to be set to UNLIMITED?

I have been trying to set the autogrowth of one of my databases to unlimited but despite whatever I do it remains the same. First thing I have checked if something is holding any locks to my database:...
-1
votes
1answer
20 views

How to sync data between two databases on two different ms sql server instances - one 2008 and the other 2016

What is the easiest way to sync data between two databases on two different instances. I am not thinking replication. Just sync e.g. production database to test database from time to time.
0
votes
0answers
14 views

Is it possible to join on column placeholders?

I have a query below in which i was wondering whether it is possible to join on my placeholders and if so are my joins in my CTE's correct? WITH DCM AS (SELECT date, placement as creative, SUM(...
1
vote
1answer
17 views

Postgresql Master/Slave Using Patroni

Can i promote a slave node to be a master for insert/update/delete using postgresql-patroni once the original master become down?
1
vote
1answer
23 views

Oracle Database 11g Failing to mount on windows server 2012

I have an Oracle 11g database installed on Windows Server 2012. It's failing to mount after shutdown. The reason why i want to mount it is that i want to enable Archive log mode, and i have been able ...
0
votes
1answer
13 views

Use plpgsql to count records selected for output AND output those records

My query SELECTs 1 row from table1, which has a number of fields plus one very long text field. It JOINs with a second table2, that may have many matching corresponding rows. I would like to be able ...

15 30 50 per page