The OpenEdge DBA Files

Where should you put that new table and its associated indexes and LOBs? Let's figure it out together!

It's for developers too!  Read on to see how ProTop can inform your development lifecycle by helping you uncover issues before they reach production. Oh, and it's free!

This week, Patrice Perrot from PROGINOV joins Paul Koufalis to talk about deleted key placeholders.

After a massive data purge, you run idxcompact, right? You want to remove all those deleted key placeholders polluting your index.

Guess what? Idxcompact doesn't remove those placeholders the way you think it does.

What is a Deleted Key Placeholder?

From the Progress Documentation:

In today’s missive, we are going to talk about poor, misunderstood memory. How much is used? How much is free? How exactly do you define “used” and “free” memory? And the million dollar question: why should you care?

Every experienced IT person knows that bad things tend to happen on Fridays, and Friday evening is when we got alerted: major performance problems on the primary database server at one of our Enterprise clients.