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…
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?
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…
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…
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