Articles

Technical Article

MZTools - Addin for VB6

Freeware! This add-in gives you some great extra features when working in VB6. It has a tab index setter, options to add a chunk of error handling code, a simple code analyzer that gives you some metrics, and my favorite - an option to identify unused code and variables. If you're still using VB6 it's worth trying.

2003-07-30

1,541 reads

SQLServerCentral Article

Finding and Deleting Duplicate Data

Bad data is almost a given, but true duplicate data can really cause you some headaches. How do you remove all the duplicates and still leave a 'keeper' record? If you think procedural code it's not too hard, but can you do a set based solution? Chris shows you show!

4.9 (10)

You rated this post out of 5. Change rating

2003-07-25

19,959 reads

Blogs

A New Word: the Wends

By

the wends– n. the frustration that you’re not enjoying an experience as much as...

7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond

By

The world runs on data, and SQL is the key to unlocking its secrets....

Manually Updating Redgate Monitor/SQL Monitor Patch Info

By

This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using...

Read the latest Blogs

Forums

Dependency Cycle in Database with Update Approvals

By ahlembreath

I'm struggling with a dependency cycle in my SQL database schema. Here's the situation:...

Query run from SQL agent, not returning same results as from query window

By aaron.reese

I am running SQL2012 (don't ask...) and my collation is Latin1_General_CI_AS and my language...

Duplicated post, please delete

By aaron.reese

I am running SQL2012 (don't ask...) and my collation is Latin1_General_CI_AS and my language...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers