| # | Date | Where | Item | Comment |
|---|---|---|---|---|
| 4 | 30 Dec 2013 @ 06:07 PST | Über SQL | Why 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 ... |
| 3 | 23 Dec 2013 @ 02:45 PST | Über SQL | How to simplify your statistics collection with a queue table | Like 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'... |
| 2 | 29 Dec 2011 @ 04:53 PST | Tools | Dynamic Partial Table Copies with Teradata Data Mover | Yes, 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 ... |
| 1 | 29 Dec 2011 @ 02:39 PST | keep it simple | Extract and Analyse Database Object Dependencies | I'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... |