#DateWhereItemComment
511 Jul 2013 @ 06:57 PDTExtensibilityAdding Geospatial Location Data - 2 Minute GuideI read all your Gespatial articles. Very interesting and it has been explained nicely. We have TD 13.1 with native functions and I tried to calculate the distance between two locations. If we are n...
405 Apr 2012 @ 09:23 PDTDatabaseWhat you need to know before creating a table in TeradataI also found that there is a difference on the identity column manipulation.... Thought we specified the start and end value along with increment count, it behaves differently. When we do Insert In...
315 Dec 2011 @ 11:26 PSTMarcio MouraLet's talk about Stored ProceduresWonderful Article, Marcio. Is there any way to execute the dynamic sql outside of the stored procedure to avoid the access issue with DBC.SysExecSQL? I have built a dynamic sql inside stored pr...
226 Aug 2011 @ 12:27 PDTDatabaseWhat you need to know before creating a table in TeradataNice explanation with example. However, I have a question on SET/NUPI performance. I feel SET/MULTISET plays the higher level than Index, do we still find any performance degrage due to SET/NUPI?
124 Jun 2011 @ 06:35 PDTcarrie's blogTips on using Sampled StatsArticle on USING SAMPLE STATS is very useful. BTW, I want to know the difference between FULL STATS and SAMPLE STATS . What is the advantage of FULL STATS when SAMPLE STATS alone enough and benefic...