#DateWhereItemComment
430 Dec 2013 @ 06:07 PSTÜber SQLWhy don't you use ALTER TABLE to alter a table?I'm starting to use ALTER's more and more, particularly where the Column naturally resides at the end of the Table. Interesting point about the Locking level required. Oh by the way, for ...
323 Dec 2013 @ 02:45 PSTÜber SQLHow to simplify your statistics collection with a queue tableLike the idea of the Stop Queue Macro, Dieter. Think I'll take your concept and use it with my 'mixed workload' application that I'm currently building.  Probably what I'...
229 Dec 2011 @ 04:53 PSTToolsDynamic Partial Table Copies with Teradata Data MoverYes, good stuff. What I'm planning to do, however, is generate an XML file every time I want to run it. This will be constructed (probably using Python) and will have the Tables that I want to ...
129 Dec 2011 @ 02:39 PSTkeep it simpleExtract and Analyse Database Object DependenciesI'd just like to thank you Ulrich for the SQL. Coincidentally I was trying to work out how to do 'dependents' within a View, i.e. what objects does a particular View use. Going the other way is...