August 3, 2012 archive

User-defined Routine with DBMS_STATS, Part II

I had a previous post about user defined routines with DBMS_STATS. After some more digging, I determined how this works. I have some data in my database that is stored in a User Defined Type. If you have a user-defined type, you can associate your user-defined stats collection routine with the Oracle Data Cartridge Interface …

Continue reading

Facebook Users and SQL Server 2012

When Facebook (FB) had its IPO in May, it was said that Facebook had almost 1 billion users worldwide. When this figure was floated, I was skeptical. First off, the world population is estimated to be almost 7 billion people. That means that approximately 1 in 7 people use Facebook. So lets stop and think …

Continue reading