#DateWhereItemComment
513 Jan 2012 @ 02:49 PSTkeep it simpleExtract and Analyse Database Object DependenciesI also use GraphViz. I have a stored procedure that accepts a database and object name and returns either a record set with all the referencing objects, or optionally, the command lines to feed in...
416 Mar 2011 @ 01:37 PDTDatabaseWhat you need to know before creating a table in TeradataNicely done.
311 Feb 2011 @ 12:17 PSTMarcio MouraLet's talk about Multilevel Partitioned Primary Indexes (MLPPI)Lathav, If check_out_dt is often used to access data, then I would go ahead and partition on it. One thing to note is that if you are using MERGE to update your data, you will want to update th...
201 Feb 2011 @ 12:58 PSTDatabaseIndexes, Too Much of a Good Thing?I'm trying to understand if I'm better of using a NUSI or STJI as a covering index. One thing I can't determine is whether or not a NUSI can take advantage of the partitioning in the underlying ta...
101 Feb 2011 @ 12:52 PSTMarcio MouraLet's talk about Multilevel Partitioned Primary Indexes (MLPPI)I've been struggling to get fast path delete when trying to delete all the data in a paritition when using MLPPI. Even if I directly reference the partition number, I still get "delete FROM partit...