#DateForumTypeThreadPost
2128 Feb 2012 @ 11:31 PSTDatabaseTopicDatabase Space Concerns I am trying to create a new table in one of the databases and the free space for that database is ~300 GB. But I get an error message as "No more room in databasename". The new table i...
2010 Feb 2012 @ 02:23 PSTDatabaseTopicHelp with Viewpoint I need to get a report of which all queries were in delay queue, how much time they spent in delay queue and when did they got out of delay queue..   Can any1 come up with...
1930 Jan 2012 @ 10:15 PSTViewpointReplySQL Scratchpad sessions remain in responding state Me too in similar dilemma..Its not going away and stays back in RESPONDING state!! Pls. help.. Appreciate your valuable Inputs.
1826 Jan 2012 @ 10:12 PSTDatabaseTopicCREATE INDEX ACCESS I have access to create / drop table in a particular database but dont know why I am not able to create Index on a already existing table.. Does it requires any extra sort of permission...
1720 Jan 2012 @ 07:34 PSTDatabaseTopicDDL review Before any new DDL is installed in our Prod env, it goes through a DDL review. Can any1 plse. help us with what all things are considered in this approach?? How to plan if Partitions are...
1606 Jan 2012 @ 12:20 PSTGeneralTopicTeradata Password Policy Can ny1 plse help me with PAssword policy .. Can i set my password as password to the same old password.. Also can i make my password as no expiration... Plse inputs ur suggestions A...
1502 Jan 2012 @ 05:46 PSTGeneralTopicCPU Skew Query Can ny1 plse. help me with how do I calculate the cpu skew for a specific query.. Also, can u plse. specify clear defn of the word skew.. Also, help me with data dictionary tables w...
1428 Dec 2011 @ 04:32 PSTJobsTopicTeradata DBA Hi guys,   I am looking for a Teradata DBA related job. My current location is India, Mumbai and ready to relocate abroad. My Technical TERADATA Skills are: Performance Tuni...
1320 Dec 2011 @ 04:39 PSTUDATopicQuery Tuning Guys, Can u plse. help me with basic Query tuning Steps..I have been provided with 2 queries and need to improve the performance of the Queries.. I have collected stats on all base table...
1220 Oct 2011 @ 03:19 PDTGeneralTopicUSe of COMMIT and ROLLBACK in Teradata Though each nd every DML statement in Teradata is Auto commit, what is the use of Commit and Rollback ??  
1118 Oct 2011 @ 06:47 PDTDatabaseReplyWhat is the difference between a YNET and BYNET? Nyone???
1018 Oct 2011 @ 06:09 PDTDatabaseTopicQuery Problem I have a query where I have used Alias name inplace of tablenames. However when I execute the Query using "From tablename as table_Alias", it gives an error whereas when i run the same...
918 Oct 2011 @ 05:57 PDTGeneralReplyNot able to access table after Macro Fails I dont think it will show up the SQL in PMON as well.. Wonder why u r not able to even drop the table.. Can u plse. put up the SQL's here.
818 Oct 2011 @ 05:51 PDTGeneralTopicHELP with ViewPoint Error Message. People, Can ny1 plse help me out in understanding the cause of below error messages: 1. Canary query for the performance group is not running Description: CanaryError Event T...
710 Oct 2011 @ 07:59 PDTGeneralReplyProblem with Timestamp in SQL assistant ODBC.
604 Oct 2011 @ 05:44 PDTGeneralTopicProblem with Timestamp in SQL assistant I have  a column with datatype time(6). When i try to retrieve data, i get data with timestamp but millisecs part missing. Whereas when i run the same script in Bteq, i get the complete...
523 Sep 2011 @ 02:27 PDTGeneralTopicTPT over other Load Utilities How do TPT differs compared to other Load utilities??  
423 Sep 2011 @ 01:58 PDTTrainingReplyTeradata-Basic Exam Query Me too willing to give the same but for TD 13 as we hav currently upgraded to 13 version..Ny links, name of Books, etc will b helpful.
323 Sep 2011 @ 01:55 PDTDatabaseReplyWhere are system reboots tracked? So How do we monitor the reboots?? The cause of reboots??   Ny way to stay updated with the current environment??
223 Sep 2011 @ 01:43 PDTGeneralReplyHelp with COLLECT STATS First of all, thanks ppl for ur valuable inputs.. Also, In my Opinion, u can collect stats on Volatile table..Tried it and it worked..whereas in many forums, i heard that u cannot?? What...
122 Sep 2011 @ 05:58 PDTGeneralTopicHelp with COLLECT STATS Can ny1 plse. ellaborate on Collect Stats..How does it work??   All I know abt it is it increases performance of Queries..But dont know the actual implementation..Can ny1 plse. thro...