711 Jul 2008 @ 10:58 PDTDatabaseReplyMoving data between 2 servers in Teradatadepending on volume and network you could also use OLE-load.
628 Apr 2008 @ 10:24 PDTUDAReplyExclusive Lockif you can use views with "lock row for access" for reading thats best otherwise "lock row for read" on the table by the long running queries and not executing rowhash level locks may also be contr...
528 Apr 2008 @ 09:25 PDTToolsReplySQL QuestionJust a thought but what about the use of RANK() ? RANKRANK is the most straightforward of the OLAP extensions. It not only sorts a result set but also identifies the numeric rank of each row in the...
428 Apr 2008 @ 09:06 PDTDatabaseReplyCascading rolessorry... as far as cascading role(s) to childen its a no go.
328 Apr 2008 @ 08:57 PDTDatabaseReplyCascading rolesdid you try: grant select on database.tablename to all marketing_folks;the database marketing_folks would have all "users" as a child of database marketing_folks.
209 Mar 2007 @ 03:02 PSTUDAReplyEquivalent utilities of Teradata Vs sql SERVER I recommend looking at the DatabaseAdmin Manual Appendix B:
109 Mar 2007 @ 02:54 PSTThird Party SoftwareReplyhow to extract only mondays in 2007try:select calendar_datefrom sys_calendar.calendar where day_of_week=2 and year_of_calendar = 2007order by 1;