Related Articles
Oracle Using the KEEP and RECYCLE Pool
Sometimes, data blocks are read in the database, and are infrequently reused. Often in a database we also have data blocks that are of frequent use (hot blocks). It is for these types of database bloc...
SQL SERVER – sp_readrequest – Long Running Process
Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest is continuously listed as long running SP. Well, the go...
Toad Data Point Transformation and Cleanse – Part 3
This is part 3 of the Transformation and Cleans videos. I would like to go over the duplicates rule and calculated column rule. Duplicates can be a very common but complex task as duplicates ca...
