Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Souvik

  1. Souvik

    Populating text columns

    Thanks for your reply, If I were to use a programming language to build such a functionality, then I would have to build an UI around it to choose the file to be loaded or atleast build a coomand line executable which accepts the file location & name as parameters. With DTS, I think I can avoid...
  2. Souvik

    Populating text columns

    Hi, I need to poplulate a column of the type text with the contents of a file. Would appreciate some help on how to do this with or without using DTS. Thanks!!
  3. Souvik

    Datatype for storing text/binary files?

    Hi, Is there a particular datatype for storing text or binary files in SQL Server? 2000? Thanks!!
  4. Souvik

    Flushing the data cache

    Hi, Regarding the dbcc dropcleanbuffers method, I see that inspite of running it, my physical reads are 0 & all the data is still read logically. I wanted to know if I can clean the all the pages & read from the db file on the disk & then wanted to measure the statistics for that. Thanks again,
  5. Souvik

    Cache flushing

    Hi, Regarding the dbcc dropcleanbuffers method, I see that inspite of running it, my physical reads are 0 & all the data is still read logically. I wanted to know if I can clean the all the pages & read from the db file on the disk & then wanted to measure the statistics for that. Thanks again,
  6. Souvik

    Indexing issue

    Hi, I have a view based on a select from two underlying tables. These tables have a non-clustered index on the column used in the join for the view. But a select * on the view takes about the same time, even if I take out the indices from the underlying table. Is it then not guaranted that the...
  7. Souvik

    Cache flushing

    Hi, Kindly let me know if it is possible to flush the data & procedure caches of sql server?? If so, how?? Many thanks,
  8. Souvik

    Relationships/data fields

    Hi, Though I have not personally used it, I think ERWIN is the most useful relational database designing software. Dunno if that helps!! Thanks,
  9. Souvik

    Create table

    Is there a way to create a table in Teradta as a select statement in teradata, as there is in Oracle? If yes, what is the syntax? Thanks!!
  10. Souvik

    Indexing issue

    Think its a wee bit conceptual, but could anybody explain how exactly the the primary index, the secondary index and single table join index differ from each other in terms storage & retrieval of data with an example?? Thanks ever so much!!!
  11. Souvik

    Load utilities

    Hi, I am very new to Teradata. I have the utilities/clients on my laptop & access to a terdata database, but I am not too sure how to use the fastload/Multiload & the TPump. Could you direct me to a resource which can guide me the load utilities??
See more

Part and Inventory Search

Back
Top