#DateWhereItemComment
420 Mar 2012 @ 12:01 PDTMarcio MouraLet's talk about Surrogate Key GenerationHi Reezun, This is a good discussion. Once you assign the SKs what other transalation are you referring to ? As you know, even in transactions, there are many types and in some cases you want to ...
319 Mar 2012 @ 01:07 PDTMarcio MouraLet's talk about Surrogate Key GenerationUse of identity columns has always caused issues. 1. it needs the columns to be Decimal(18) 2. If a system restart happens then you will see a huge jump between the sequences. The sequence does ...
219 Mar 2012 @ 12:58 PDTMarcio MouraLet's talk about Surrogate Key GenerationI know there is documentation/literature supports the use of 1 unique number generated per row in a table irrespective of the natural key. For example : First time a row for customer "A" is creat...
119 Dec 2011 @ 08:16 PSTOracleExploring Teradata 13's PERIOD FunctionsVery useful article !! I ran into a problem with partitioning, please read below : Created a table as below : CREATE multiSET TABLE t12 (a INTEGER,b PERIOD (date) FORMAT 'YYYY-MM-DD' NUL...