#DateForumTypeThreadPost
1725 Feb 2015 @ 06:37 PSTUDAReplyHoe to check which user had deleted dataHi Rajeev, Can you please provide the Script for this.   Thanks 
1618 Feb 2015 @ 03:23 PSTGeneralTopicDeletion of Old ID'sHi All, Please let me know that how can i find old user id's in Teradata which have not been accessed more than a year.   Any script for that will be helpful.   Thanks.
1513 Feb 2015 @ 03:54 PSTGeneralReplyTeradata Packdisk Job ScheduleHi, Below is the output which I got after the Packdisk Job ran:-   Tue Feb 10, 2015  14:00:16 : Packdisk has been started                ...
1421 Jan 2015 @ 12:39 PSTGeneralTopicTeradata Packdisk Job ScheduleHi All, Need to know that if the Packdisk is running twice a week in a small size database, is it a problem? If yes then after how much duration we need to run the Packdisk? Please mention the a...
1313 Mar 2014 @ 04:29 PDTGeneralReplyWant to reduce the Size of Access Rights TableHi All, There is a script below which shows the counts of Username as EDWADMIN:-   1) Select count(1) from dbc.allrights where username='EDWADMIN' and grantorname <> 'EDWA...
1212 Mar 2014 @ 04:26 PDTGeneralTopicWant to reduce the Size of Access Rights TableHi All, There is an Access Rights Table whose size has increased a lot. But the Issue is that All the Users have been defined Roles in Prod and DEV and they have their Access Rights on different O...
1105 Feb 2014 @ 09:17 PSTGeneralTopicAutomation of Stats CollectionHi, Can any one please explain me that how to Automate the Stats Collection Process through Stats Info View.     Thanks..
1004 Feb 2014 @ 08:59 PSTGeneralReplyMVC ToolHi Brian, Please forward your Pearl Program to my mail id :- uel.omar@hotmail.com.   Thanks and Regards, Mohammad Omar Saeed.
905 Dec 2013 @ 03:31 PSTViewpointTopicUsers Online at a particular time durationHi, Is it possible to see that how many users were online on a particular day during a limited time period?
802 Dec 2013 @ 12:46 PSTGeneralReplyScheduling a job in DBQLHi Raja, Thank you for this document, but I have done reading this document. Do you have any script or something in relation to my above asked question?      
701 Dec 2013 @ 10:41 PSTGeneralTopicScheduling a job in DBQLHi, Can anyone please let me know that how to schedule a job in DBQL to move the data from DBQL to History tables.   Thanks and Regards,  
627 Nov 2013 @ 10:44 PSTGeneralReplyMVC ToolHi, In PRISE Compress Wizard it does give exact output in Excel Sheet on the Columns which can which are to be compressed or like it does not provide any recommendation on the columns to be compre...
525 Nov 2013 @ 10:46 PSTGeneralReplyMVC ToolHi Pietro, I am not able to access that  MVC tool. Can you please send it to my personal mail id:- uel.omar@gmail.com. Please help me if you can.   Thanks and Regards
421 Nov 2013 @ 05:02 PSTGeneralTopicMVC ToolHi Guys, Can you please provide the MVC tool? Is it possible to download it from any website?   Thanks.
320 Nov 2013 @ 01:25 PSTGeneralReplyProcess of Change of PI in skewd tableHi, I have few more questions. 1) How to identify the columns to compress and the columns which are not to be compressed? 2) What is the procedure to compress a column? 3) Please prov...
219 Nov 2013 @ 08:59 PSTGeneralReplyProcess of Change of PI in skewd tableThanks Raja and Khurram...
118 Nov 2013 @ 10:15 PSTGeneralTopicProcess of Change of PI in skewd tableHi Guys, Can you please let me know the process of changing the Primary Index when a table is skewd?