Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Chris Cubley profile

Chris Cubley is an MCSD with over four years of experience designing and implementing SQL Server-based solutions in the education, healthcare, and telecommunications industries. He can be reached at

   Items 1 to 4 of 4   

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!   Read more...
By Chris Cubley 2003/07/25 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 19,854 reads

Using Exotic Joins in SQL - Part 2

In the previous article, you saw how the BETWEEN operator could be used in joins to solve problems dealing with range-based data. In this article, Chris Cubley will show you how to take joins even further by using multiple criteria in joins as well as using the greater than, less than, and not equals operators in joins.   Read more...
By Chris Cubley 2003/02/05 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,219 reads

Using Exotic Joins in SQL Part 1

When most developers think of joins, they think of a.SomethingID = b.SomethingID. This type of join, the equijoin, is vitally important to SQL programming; however, it only scratches the surface of the power of the SQL join. This is the first in a series of articles that will look at several different types of exotic joins in SQL. This article will focus on using the BETWEEN operator in joins when dealing with range-based data.   Read more...
By Chris Cubley 2005/04/29 (first published: 2003/01/22) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 37,534 reads

Using Interface-Based Programming Techniques in SQL Server

Programmers can most commonly relate to interface-based programming in their programming language. This is harder to accomplish in SQL Server though. In this article by Chris Cubley, he shows you how to build interfaced-based SQL.   Read more...
By Chris Cubley 2002/07/19 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,835 reads
   Items 1 to 4 of 4