Questions tagged [dirty-data]
60 questions
0
votes
2 answers
Find item by ID in treeview node list
Does anyone have an idea how to write a recursive method to find item
by id within a treeview node list like this:
This data is direct binded to treeview like this
So I need to find item by id, and update with new values

Nemanja Andric
- 625
- 11
- 30
0
votes
2 answers
Why do we need to write dirty pages back to disk to evict it?
"...if a page has been modified and is thus dirty, it must be written back to disk to evict it, which is expensive." (In chapter 22 of OSTEP)
I don't know why. In order to evict it from memory, the dirty page will be moved to swap space, and then it…

dazhu
- 13
- 4
0
votes
0 answers
Use glang to develop web application. How to clear dirty data in the database due to unit testing
I use gin framework and ORM framework gorm to develop web application.The DB is Mysql.
Every unit test will produce dirty data. So I use AfterCreate hook to record table name and the id when create an object.Then delete dirty data by traversing the…

Kobshobe
- 89
- 1
- 6
0
votes
1 answer
How to use imageData in animations
I have an object that stores imageData with a createImageData() function. I do not want to create any more imageDatas, but I want the data to be cleared each frame. How do I do this?

John Porter
- 33
- 7
0
votes
2 answers
Input field is dirty and shows red border validation only in IE11 (Angular8)
Hi guys :) This is my first question here, so I hope that you will understand it properly.
On my login screen I have 'username' and 'password' fields.
When loading the site on IE 11 the second input ('password') is dirty all the time and shows red…

Din Tanovic
- 1
- 1
0
votes
1 answer
Teradata: How to LEFT OUTER JOIN unlike datatypes?
SELECT DR.column
FROM DB.Table RCT
LEFT OUTER JOIN DB.Table2 RC ON RCT.NBR_CLMN = RC.NBR_CLMN
LEFT OUTER JOIN DB.Table3 DR ON DR.NEW_NBR_CLMN = RC.VCHAR_COLUMN
Running the SQL code above in Teradata SQL Assistant gives me a 2620 "The format or data…

PyPuppy
- 25
- 4
0
votes
1 answer
Hibernate refresh only dirty entities
I have a table filled with nearly 50 datas. Some part of code sometimes changes these datas by jdbc call. At database side these datas are being changed by jdbc call while I need to show these changed datas on screen by hibernate load. I used…

Ozan Apaydın
- 33
- 5
0
votes
1 answer
SQL query for entity names with small differences
I have to query a very large .csv dataset from a large city that contains thousands of dirty data entries like the following example.
How would I make an SQL query that would catch all instances of records matching the following permutations of a…

AZBlue
- 105
- 7
0
votes
0 answers
Does Transaction Isolation Level Have to be Reset After Read
I am trying to dirty check a SQL Server table, but I am not sure whether or not the settings are saved to the table and will effect other reads, or automatically reset after the read. I would like the uncommitted flag to only be used each time the…

Matthew
- 1,461
- 3
- 23
- 49
0
votes
1 answer
Delete fixed string contained in SQL Server Table Column
I have a table with filed 'myData' of type nvarchar containing sometimes a data ending with the string '|||' that I want to remove.
Obviously the data is not fixed, so I can't just use
UPDATE myTable
SET myData = REPLACE(myData, 'oldString',…

Ale
- 285
- 2
- 7
- 18
0
votes
1 answer
Angular2 PrimeNG datatable Editable cell dirty flag
I'm using the primeng datatable which have columns are editable. I want to mark the cell as dirty once it's been edited and save the edited rows to the database. Can anyone advise is there a way to do this ?

chloe
- 33
- 5
0
votes
2 answers
Consolidating fact records by timestamp
I am in a Microsoft SQL Server database. I would like to consolidate start and end periods for employees. For example, given the following simple table:
create table dbo.foo (
employee_key bigint,
effective_start_date date,
effective_end_date…

Pablo Boswell
- 805
- 3
- 13
- 30
0
votes
0 answers
Sql Server read uncommitted field level variance?
If my connection allows dirty reads, is it possible that I would get inconsistent results from multiple fields of the same row? Example:
Connection 1:
Update table1 set col1 = 1, col2 = 1 where primarykey = 1
Update table2 set col1 = 2, col2 = 2…

Elroy Flynn
- 3,032
- 1
- 24
- 33
0
votes
1 answer
Avoid the grid cell to get dirty unless the values is changed
How to avoid the grid cell from become a dirty cell unless the value is changed,
when I just touch the time cell , it becomes a dirty cell, how do I avoid that being getting dirty,
here's the Fiddle
Here is my grid ,
Ext.application({
name:…
user7569898
0
votes
0 answers
AngularJs, mark object as dirty
I have some objects that are retrieved from a web api and are "editable". When the user edit one object he is able to change some fields. I would like to maintains a isDirty field on those objects to know when they are modified (isDirty==true).
I…

gervais.b
- 2,294
- 2
- 22
- 46