Database duplicate rows and data are considered one of the biggest threats that face SQL developers. It may also affect the behaviors of applications that rely on that database the contains those duplicate rows, by providing mistaken data. A SQL server...
Recently, I've been doing a lot of invoking .NET Assemblies within SQL Server 2005, I bloged an overview of SQLCLR here , also I posted about how to implement aggregation function in C# here . Actually invoking .NET code has many advantages but at...