Post New Resource

SQL SERVER - Delete Duplicate Records - Rows

Posted By :Srinivas Challa Posted Date :18/06/2009 Points :10 Category: SQL Query URL: http://www.challadotnetfaq.blogspot.com/

Following code is useful to delete duplicate records. The table must have identity column, which will be used to identify the duplicate records. Table in example is has ID as Identity Column and Columns which have duplicate data are DuplicateColumn1, DuplicateColumn2 and DuplicateColumn3.

DELETE FROM MyTable WHERE ID NOT IN ( SELECT MAX(ID) FROM MyTable GROUP BY DuplicateColumn1, DuplicateColumn2, DuplicateColumn2)

Featured Articles

Best Practices No 5: - Detecting .NET application memory leaks
Memory leaks in .NET application have always being programmer's nightmare. Memory leaks are biggest problems when it comes to production servers. Productions servers normally need to run with least down time. Memory leaks grow slowly and after sometime they bring down the server by consuming huge chunks of memory. Maximum time people reboot the system, make it work temporarily and send a sorry note to the customer for the downtime. ... Read More

.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
One of the important factors for performance degradation in .NET code is memory consumption. Many developers just concentrate on execution time to determine performance bottle necks in a .NET application. Only measuring execution time does not clearly give idea of where the performance issue resides. Ok, said and done one of the biggest task is to understand which function, assembly or class has consumed how much memory. In this tutorial we will see how we can find which functions consume how much memory. This article discusses the best practices involved using CLR profiler for studying memory allocation.... Read More

How to improve your LINQ query performance by 5 X times ?
LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am sure you will never like to touch DBML code generator again. ... Read More

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply

Read also another Resources from the same Author	Related Resource From The Same Category String Format in SQL List All the Tables for All Databases Using System Tables-SqlServer How to get a last inserted record or Row from a table without using any Id column? Difference between Length() and DataLength() using SqlServer? How to Delete a Repeting(or)duplicate records from a Table using SqlServer?

Find More code samples in C#, ASP.Net, Vb.Net and more Here

SQL SERVER - Delete Duplicate Records - Rows

Featured Articles

Read also another Resources from the same Author

Related Resource From The Same Category