September 27, 2008

This video showcases a technique that I pioneered a few years ago in order to clear out large numbers of rows from very large and heavily used tables - without negatively impacting concurrent operations. (I'm sure other people have come up with similar approaches, and there are other, different ways, to tackle this same problem as well (that I don't address in this video).)

Video Length: 09:37
Video Summary: Have large tables full of millions of rows where you need to delete data on a periodic basis without impacting write operations? Then check out this video which will show you how to tackle the problem using nibbling deletes.