How do I convert a timestamp to 'YYYYMM' in Teradata? how do i delete records from the User defined table types? How do I export BLOB (varbinary max) column to Excel or CSV file without xp_cmdshell? How do I fi
Teradata Performance issue and example I am facing an issue in our Teradata QA environment where a simple query that ran in under 1 minute is now taking 12 minutes to complete. This select is pulling 5 fields based on a simple inner join I... ...
ALTER TABLE with variable TableName ALTER vs UPDATE when creating a new column with default value. Alternate queries for MERGE Alternative for OR in WHERE clause Alternative for PIVOT Alternative of CURSOR in SQL to improve performance ? alternative query for in clause Alternative to Full Outer Joi...