How to find duplicated fields and delete them from database? (t-SQL)

If you do not want to strugle with cursors to delete duplicate records I have a simple solution for you. For this you must have a primary key or a unique key that has auto increment.

Here is the magic :

DELETE T1
FROM CustomerTable T1, CustomerTable T2
WHERE T1.DuplicateField = T2.DuplicatedField
AND T1.UniqueField> T2.UniqueField

This will basically delete all records from the table CustomerTable which have the same value for the field DuplicateField, leaving that record which has the lowest value in UniqueField.

How does DNS service work?

Every website has a series of identifier numbers called IP address much like a telephone number. This series of numbers is unique for a particular website. So when you want to visit this website your computer looks for the specific IP address of that website in cyber space. However it would be humanly impossible for us to remember all these numbers. So to make the users life easy the concept of DNS was introduced, a domain is nothing but a name or a string of words that corresponds to a certain IP address for instance cadianda.net or convetbuster.com.

When you type www.google.com your computer asks your DNS server what the IP address is for www.google.com. And your DNS server sends the ip address like this 64.233.169.103. In most cases you may just put the IP address of the website you want to see in your browser's address bar.

Why would you want to use the IP address instead of URL?

This might seam useless but if you are having problems with your internet connections even though your router says it is connected, you might want to try the IP address of the website you are trying to reach. This will show if you really have an internet connection or not.

Unlimited Web Hosting Product

Dear Customer,

After the launch of our Free Managed DNS Service and our competitively priced Email Hosting Product, our Web Hosting Product is now all set for a revamp.

In a bid to enhance our offering even further, we are now introducing our brand new Unlimited Web Hosting Product at a flat rate of $3.99 on every Domain hosted! Our newest offering comes your way on the 1st of July '09 with a dynamic set of unlimited features that will do away with any scalability issues your Customers may have. Further details are as follows:

New Web Hosting Product Specifications

• Unlimited Bandwidth
• Unlimited Disk Space
• Unlimited Databases
• Unlimited DLLs
• Unlimited Email Accounts

Advantages of this Product

• Capture a greater market share by increasing your volumes.
• A Web Hosting + Email Hosting package with unlimited parameters is now available for a flat rate.
• Scalability will now never be an issue for your company.

---

Keep a tab on our future mailers for more information on this 'Ultimate Hosting Package'!

Best Regards,

Audrey Xavier
Chief Marketing & Communications Officer

Cadianda.net
Blog.Cadianda.net

Third Level .UK for just $6.59

We are pleased to announce that our .UK Promo went live today at 12:30 UTC. You can now get Third Level .UK Domains for just $6.59 per year. This special pricing is now applicable to all 10 years of Registration! Make the most of this offer to effectively target the vast European market!

Visit www.cadianda.net to register your UK domains.

Note:

• This Promo is applicable to all ten years of Registration.
• Renewals & Transfer-Ins will not attract this Promo Pricing.
• There are no restrictions on the number of Domains that can be registered during this period.
• Though the Promo Pricing for Third Level .UK Domains mentioned above is on an annual basis, these can only be registered in multiples of 2 years as mandated by the Registry.