Delete Duplicate records in Sql

Reference Source link : http://blog.sqlauthority.com/2009/06/23/sql-server-2005-2008-delete-duplicate-rows/


/* Delete Duplicate records */
WITH CTE (COl1,Col2, DuplicateCount)
AS
(
SELECT COl1,Col2,
ROW_NUMBER() OVER(PARTITION BY COl1,Col2 ORDER BY Col1) AS DuplicateCount
FROM DuplicateRcordTable
)
DELETE
FROM CTE
WHERE DuplicateCount > 1
GO

Visual Studio Silent Install

 

I found a couple of interesting articles as I was setting up my new machine

Visual Studio Install: http://mycodelog.com/2010/09/28/silentvs/

sql 2008 silent install: http://mycodelog.com/2010/09/28/sqlsilent/

And also ninite.com is a nice little utility that can be used to install a lot of commonly used applications.

 

 

 

 

 

 

 

 

 

 

Redirect Console.Writeline to Textbox

Redirect console.writeline outputs to textbox or other streams

• http://saezndaree.wordpress.com/2009/03/29/how-to-redirect-the-consoles-output-to-a-textbox-in-c/ 
• http://stackoverflow.com/questions/6024172/is-it-possible-to-intercept-console-output

C# Task Library Parallel.Foreach

Sample Usage
var arrayStrings = new string[1000];
Parallel.ForEach<string>(arrayStrings, someString =>
{
    DoSomething(someString);
});


To set the Parallelism
var options = new ParallelOptions { MaxDegreeOfParallelism = 2 };
Parallel.ForEach(dtResult.AsEnumerable(), options, dr =>
		{
		//Do stuff
		});

 


Good Reads:

• http://blog.mssoftwareconsulting.com/msswc/blog/file.axd?file=WhenToUseParallelForEachOrPLINQ.pdf
• http://blogs.msdn.com/b/pfxteam/

Windows Service & Relative Paths

This neat little tip will help you to use Relative path references in windows service.
private static void Main()
{
Environment.CurrentDirectory = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);

MyService service = new MyService();

ServiceBase.Run(service);
}

Split solution .sln files in .net

This is a very nice little tool to split your large sln files so that small set of projects can be tested instead of using a very large solution.

http://slntools.codeplex.com/

Spell Checker in 21 Lines?

Peter Norvig created a spell corrector using 21 lines of python code. http://norvig.com/spell-correct.html

.Net Implementation
http://www.codegrunt.co.uk/2010/11/02/C-Sharp-Norvig-Spelling-Corrector.html#norvigSpell

Link to Github: https://github.com/lorenzo-stoakes/spell-correct

 

reflection in Csharp

http://joelabrahamsson.com/entry/getting-property-and-method-names-using-static-reflection-in-c-sharp

Test Api

Test Api: Seems an very interesting read for .net devs & QA

http://www.slideshare.net/ivom1234/test-api-4532771?from=share_email

File Comparison in C#

http://support.microsoft.com/kb/320348

http://dotnet-snippets.com/dns/c-compare-files-SID209.aspx

Method 1:

// compare. A return value of 0 indicates that the contents of the files
// are the same. A return value of any other value indicates that the 
// files are not the same.
private bool FileCompare(string file1, string file2)
{
     int file1byte;
     int file2byte;
     FileStream fs1;
     FileStream fs2;

     // Determine if the same file was referenced two times.
     if (file1 == file2)
     {
          // Return true to indicate that the files are the same.
          return true;
     }

     // Open the two files.
     fs1 = new FileStream(file1, FileMode.Open);
     fs2 = new FileStream(file2, FileMode.Open);

     // Check the file sizes. If they are not the same, the files 
        // are not the same.
     if (fs1.Length != fs2.Length)
     {
          // Close the file
          fs1.Close();
          fs2.Close();

          // Return false to indicate files are different
          return false;
     }

     // Read and compare a byte from each file until either a
     // non-matching set of bytes is found or until the end of
     // file1 is reached.
     do
     {
          // Read one byte from each file.
          file1byte = fs1.ReadByte();
          file2byte = fs2.ReadByte();
     }
     while ((file1byte == file2byte) && (file1byte != -1));

     // Close the files.
     fs1.Close();
     fs2.Close();

     // Return the success of the comparison. "file1byte" is 
     // equal to "file2byte" at this point only if the files are 
        // the same.
     return ((file1byte - file2byte) == 0);
}

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

Method  2 :  (http://dotnet-snippets.com/dns/c-compare-files-SID209.aspx)

private bool CompareFiles(string File1, string File2)
{
        FileInfo FI1 = new FileInfo(File1);
        FileInfo FI2 = new FileInfo(File2);

        if (FI1.Length != FI2.Length)
               return false;

        byte[] bytesFile1 = File.ReadAllBytes(File1);
        byte[] bytesFile2 = File.ReadAllBytes(File2);

        if (bytesFile1.Length != bytesFile2.Length)
               return false;

        for (int i = 0; i <= bytesFile2.Length - 1; i++)
        {
               if (bytesFile1[i] != bytesFile2[i])
                       return false;
        }
        return true;
}

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }