How To Find The Physical Size Of SQL Server Tables And Indexes
Inspired by Shannon's post (give me the size of data and indexes for a file in an oracle database please), I found a SQL statement...
How To Redeploy A Package To A Development Client (Fat Client)
I needed to redeploy a full package and all the update packages associated with the pathcode. So, I used the SQL below to do the...
Cool Data Selection When Purging Work Submitted Jobs
Normally, we purge out all records from the Work Submitted Jobs screen that are at least 45 days old. However, one of our clients requested...
SQL To Get The Email Address From The Address Book Who’s Who For Each User Profile
Below is the SQL used to get the emails address from the Address Book Who's Who (F01151) for each user profile (F0092): SELECT A.ULUSER,A.ULAN8, B.EAEMAL...
Use Oracle SQL Developer To Modify The JDE LOCAL Database
During our upgrade process, we apply all of the ESUs to become "code current" before mirroring the upgraded code to the other pathcodes. The process...