So you've loaded the latest SQL patches and Windows service packs, updated Patron Edge and PEO to the latest version and trimmed down transaction times , but your database just can't keep up with you. Before going out and buying a brand new, top-of-the-line server for your database, try some...

I know, I know, my posting frequency has dropped off a bit in the last couple of weeks. I've been a little swamped and unable to write as much as I'd like. I haven't forgotten about you though! Things are settling back down and I want to get back to my two or three a week schedule, but I...

One of the features of PEO 3.2.5+ and PE 3.240+ is the ability to run on SQL 2005 natively. If you are relatively new to PE/PEO and are creating a new database in SQL 2005, it will automatically be in 2005 mode (also called compatibility level 90). But if you have upgraded an existing SQL server instance...