July 20, 2010 at 6:51 am
wat is dirty data. how many ways is there if i want remove the dirty data in sql server 2005
July 20, 2010 at 9:30 am
"Dirty data" doesn't have a precise definition. One definition of it is data inside the system in an uncommitted state. It's in the middle of a transaction and therefore, dirty. But that's not one that you have to do anything to "clean up." When the transaction commits or rolls back, the "dirty" data goes away.
You may be talking about incorrect data. Meaning the data entry was 'Tulsa, New York' instead of 'Tulsa, Oklahoma' or 'NY' instead of 'NYC.' In this case, you have to do two things, first, design the database such that only the correct information can be put into the database. Second, fix the data. This can be a manual and tedious process. But for some data, say addresses, there are services that can validate an address.
Other than that, it really depends on what you mean by "dirty"
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 20, 2010 at 9:32 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic955567-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2010 at 9:40 am
Well, no more replies anyway... :w00t:
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply