Questions tagged [data]

The tag has no usage guidance.

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

Data Readiness Check [closed]

Does Oracle provide any marker such as a Table level SCN or a Table level Hash or a partition level Hash, which can be compared against the Target Non Oracle Database after data movement from Oracle. ...
-1
votes
0answers
40 views

What database is recommended for large amount of data usage, backup and archive

I am a programmer, I use sql mysql database to store data. I have built an E-commerce platform that uses mysql database as db, and I have two questions to ask 1 - What database can handle very large ...
0
votes
1answer
59 views

How to reduce big size database files (Data File ) SQL Server without SHRINK?

I found a couple of 'question' regarding shrinking big datafiles but I think that is not very accurate to my situation. So here is my question I have a big database with almost 8TB of Data File Size ...
0
votes
2answers
44 views

insert on table being unnaturally slow

I have an "Basic" pricing tier Azure SQL database with a table of 7 columns, an ID column of int that is the clustered index and primary key, one datetime2(0) column, 3 varchar(100) columns ...
0
votes
0answers
24 views

Copy postgres data files from a broken server to a new server

I was running a postgres13 on a ec2 instance. This instance got corrupt and I lost the sudo access hence I could not login into postgres any more nor read data in tables. I created another instance ...
0
votes
0answers
9 views

Can I version non-seed data scripts in SSDT project?

I have an SSDT project to version my DB schema. Now I'd like to add to it script files that insert/delete data for integration tests. These scripts are not post-deploy, they will be called before ...
1
vote
1answer
34 views

MySQL importing csv file by Data import wizard

I tried importing a CSV file in MySQL via the data import wizard. My CSV file has 70,000 records but only 61 are imported. I tried checking the CSV file, recreating the file from source, and changing ...
0
votes
1answer
64 views

What exactly is the datatype input into a DATETIME value in MySQL

I am trying to get data from a PLC directly into a MySQL 8.0 database (using MySQL Workbench). I need to know what data type the input value is for a column set to DATETIME so I can send in the right ...
0
votes
0answers
14 views

Should I use Using source code or using Using MSI for installing Griddb on windows?

I am following https://github.com/griddb/c_client to install griddb under Quick start (Windows) Should I use Using source code or using Using MSI for installing Griddb on windows? Please help.
-2
votes
1answer
50 views

Would like to see what Credit Card Numbers have changed [duplicate]

Using the following SELECT Statement, I see all active drivers with a Credit Card Number : SELECT top 1000 * FROM cashcard WHERE crd_status = 'A' Based on that query, I get a table with a bunch of ...
0
votes
0answers
14 views

How to join on a column that includes the ID but has additional strings (Redshift)

I have 2 tables with the following 2 columns that I would like to use as the key for my join: a column that has the ID of the call and I have another one which is the link to the call, containing the ...
1
vote
1answer
30 views

Pointing the database secondary data file towards a network drive

I have a 2 TB database and the Data Drive has filled up. My network team cannot expand the drive nor provide another drive so that the secondary data file can be pointed towards that. My question is ...
1
vote
1answer
17 views

How to search for multiple synonyms?

I have a database with 2 tables : products, and synonyms. When a user type one or several words to search in the products.description field, I would like to search for all the synonyms/substitutions ...
0
votes
1answer
12 views

How do I select the total count of records over the past week, including days which have no records in MySQL

Essentially, I need a query which can output something like: +------------+-------+ | date | count | +------------+-------+ | 2020-09-30 | 10 | | 2020-09-29 | 3 | | 2020-09-28 | 0 | | ...
1
vote
1answer
631 views

How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine? [closed]

I've created a file: 'C:\fff.txt' which contains data for my database table. Then I'm trying to load data from that file like this: LOAD DATA LOCAL INFILE 'C:\\fff.txt' INTO TABLE fff LINES TERMINATED ...
0
votes
1answer
26 views

Data sync between two local Mysql databases in different system in same netwrok

I am using mysql as database for my application and for the purpose of fail over and I need to sync the data from one local mysql database in system one to other local database in system 2 connected ...
0
votes
1answer
44 views

How to restore MySQL database files without having a MySQL instance?

After a crash of my PC I'm left with several databases (27Gb in total) that are left on my data drive, while my OS drive (Windows 7) is gone. I've reinstalled the machine by now (Windows 10) and set ...
3
votes
1answer
501 views

How is data lake and polyglot persistence different?

I just came across a new technology called polyglot persistence. However, it sounds very much like a data lake. So, how are these two things different?
0
votes
2answers
37 views

how to view data as history of field value change

Example i have data like id employeeId Salary Year 1 1 12000 2001 1 2 10000 2001 1 1 16000 2002 1 3 12000 2004 1 ...
0
votes
1answer
1k views

How do I locate my Postgres data directory while the server is down?

I'm on Mac 10.13.6. I restarted my machine and Postgres, which normally starts upon restart, wasn't running. Sadly, I cannot remember how or where I installed it. I'm able to locate instances of "...
-1
votes
1answer
311 views

SUM first consecutive rows only SQL Server

I have the following data: ROW SEGMENT ORDEN LONG 1 39 11 49.00 2 39 10 102.00 5 39 7 104.00 6 39 6 139.00 7 39 5 97.00 11 39 1 ...
0
votes
1answer
18 views

What is the safe way to update production data if data found inconsistent

I am in a small company and require to fix a bunch of data in production which are inconsistent. I have written the script to handle the fix. I understand that writing sql to fix data is way more ...
-1
votes
2answers
100 views

Where to find Dummy Data For Oracle Database [closed]

I don't know if the question is relevant, but if someone can give me some info, I'll be very grateful. I have found this website - here for generating dummy data. I have found some .dump files full of ...
0
votes
1answer
406 views

How to fill/insert fake data into a MS Sql Server

I'm trying to test out some configuration settings for an MS Sql Server FILEGROUP and to do this I wish to fill my FILEGROUPdisk up so it will start populating the 2nd FILEGROUP. I've just created a ...
-1
votes
1answer
781 views

'PRIMARY' filegroup is full [closed]

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 ...
0
votes
1answer
472 views

MySQL date range if data not available display 0

I've a table here here is the structure : id,id_berita,ip_user,tanggal I try to use this query : select count(id) as jumlah,tanggal from tb_trafik_berita WHERE (tanggal BETWEEN '2020-01-02 00:00:00'...
-1
votes
1answer
56 views

What is the correct way to join this tables? [closed]

what is the correc way to join this tables? Party, person and organization: Tables Party: id, party_type (person/organization) Person: party_id, name, etc Organization: party_id, name, etc Other ...
0
votes
1answer
27 views

Using WHERE / AND in Joins

Can someone elaborate on how the following two queries would provide different results? That is, how the query is processed differently using WHERE or AND. select orders.*, accounts.* from ...
0
votes
0answers
1k views

Unpivot in MYSQL?

Please I need help on how I can transform the data that appears in the attached photo. Maybe Unpivot SQL?