Deleting duplicate rows when there is no primary key

set nocount on
create table #tbFruit (Fruit varchar(20))
insert into #tbFruit (Fruit) values (‘apple’)
insert into #tbFruit (Fruit) values (‘apple’)
insert into #tbFruit (Fruit) values (‘apple’)
insert into #tbFruit (Fruit) values (‘apple’)
insert into #tbFruit (Fruit) values (‘orange’)
insert into #tbFruit (Fruit) values (‘orange’)
insert into #tbFruit (Fruit) values (‘orange’)
create table #tbFruitsWithDupes (DupeID int identity, Fruit varchar(20), DupeCount int)
insert into #tbFruitsWithDupes (Fruit, DupeCount)
 select [...]

Creating text images

http://www.zedilabs.com/aspnet/fonternet/font.html

Top 10 new features in SQL Server 2005

Top 10 features
Other Reference http://www.developer.com/db/article.php/3512126

Binary vs. xml serialization performance

Toshiba Tecra M5 (dual 2Ghz processor, 2Gb memory) an object of type List<object[]> containing 296 “rows” and 18 “columns” with elements of different data types (strings, integers, dates, etc.) takes approximately 14 ms per iteration for binary serialization & de-serialization and 31 ms per iteration for xml serialization & de-serialization.
Summary:  My tests show that, on [...]

Generic Functions for Object ↔ XML Serialization/Deserialization

public static string ToXml<T>(T source){    string result = null; 
    using (System.IO.StringWriter sw = new System.IO.StringWriter())    {        using (System.Xml.XmlWriter writer = System.Xml.XmlTextWriter.Create(sw, null))        {            System.Xml.Serialization.XmlSerializer serializer = new System.Xml.Serialization.XmlSerializer(typeof(T));            serializer.Serialize(writer, source);        } 
        result = sw.ToString();    } 
    return result;            } 
public static T FromXml<T>(string xml){    T result = default(T); 
    if (string.IsNullOrEmpty(xml) == false)    {        using (System.IO.StringReader sr = [...]