Monthly Archives: October 2011

Teradata Parallel Transporter Dependencies

When installing Teradata Parallel Transporter (TPT) there are a couple of dependencies to keep in mind.  TPT requires CLIv2, GSS client as well as Shared ICU Libraries.  These need to be installed prior to installing TPT components.  TPT will let you … Continue reading

Posted in Teradata | Tagged , , , | Leave a comment

SQL Myth–Cannot truncate table in a transaction

When asked about the difference between a truncate and delete the common answer is that delete is a logged operation but truncate is not.  Well sort of.  Referring to BOL truncate is a minimally logged operation.  SQL Server doesn’t keep … Continue reading

Posted in Database Administration | Tagged , , , | Leave a comment