Questions tagged [data]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-2
votes
1answer
45 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
13 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
24 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
16 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
273 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
15 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
36 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 ...
0
votes
0answers
40 views

Oracle - SCD Type 2

I am new to Oracle I have 2 tables called dwh_tbl_dim_supplier_type2_ar (target table) stg_tbl_dim_supplier_ar (source table) dwh_tbl_dim_supplier_type2_ar contains 6 column SUPPLIER_KEY (PK) ...
3
votes
1answer
470 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
0answers
33 views

narrow or wide - how to store huge amount of values

I think, I have two questions maybe in one (because they belong together and the first is priorized while the second is just an idea). The leading question is: Given billions of triplets (Timestamp, ...
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
442 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
168 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
14 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
51 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
242 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
438 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
255 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
55 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
966 views

Unpivot in MYSQL?

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