title: Can you recommend a good source for Teradata Best Practices?
body: <p>Looks like my data warehouse project is moving to Teradata next year (from SQL Server 2005).</p>
  
  <p>I'm looking for resources about best practices on Teradata - from limitations of its SQL dialect to idioms and conventions for getting queries to perform well - particularly if they highlight things which are significantly different from SQL Server 2005.  Specifically tips similar to those found in <a href="https://rads.stackoverflow.com/amzn/click/com/0596008945" rel="noreferrer" rel="nofollow noreferrer">The Art of SQL</a> (which is more Oracle-focused).</p>
  
  <p>My business processes are currently in T-SQL stored procedures and rely fairly heavily on SQL Server 2005 features like PIVOT, UNPIVOT, and Common Table Expressions to produce about 27m rows of output a month from a 4TB data warehouse.</p>