Forum Replies Created

Viewing 15 posts - 61 through 75 (of 112 total)

  • RE: Very Large Table

    So in my DTS task I would select the records that are => 'current max(entrydate)'? I don't want to bring over duplicates. So perhaps it needs to be...

  • RE: Very Large Table

    Yes, but it will not return 1 row. Here's what I'm trying to do: Write a DTS package that will append only Inserts into a SQL table from an...

  • RE: Very Large Table

    Okay another caveat, I need the record back with not only the max(id) but also the max(entrydate). How can I get SQL to return just one row, fast?

    Aurora

  • RE: Very Large Table

    Thanks guys, that worked like a charm! Oddly enough, I made the mistake no DBA should ever make and that is assume. Naturally I thought the index was already...

  • RE: @@LOCK_TIMEOUT

    Thanks Phill, you have been a big help pointing me in the right direction. I truly appreciate it.

  • RE: @@LOCK_TIMEOUT

    Thanks! But is the default 0 grabbing all it needs?

  • RE: Please Help, has no one done this before???

    The binary file I speak of is simply the Oracle log. Is there anyway to read this so I can determine which records need to be loaded. Does...

  • RE: @@LOCK_TIMEOUT

    What about when locks are configured with the default values such as this result from sp_configure 'locks':

    name ...

  • RE: where can i find oracle OLE DB provider or oracle

    Not sure if this is what your are looking for:

    But the ODBC drivers ship with SQL Server.

    If you are in SQL Server and wanting to set up the correct connection...

  • RE: DTS or BCP or ???

    Hi everyone,

    Me too, I would like to view the scripts. I too have a similiar situation where I am connecting to a secure FTP and pulling down a CSV...

  • RE: Please Help, has no one done this before???

    I could certainly use either of those options, but still unsure how to tackle reading the binary file.

    Ideas?

  • RE: Please Help, has no one done this before???

    Great, but although I have written a few ActiveX task before, its never been to read a Binary file. Any advice or resources I can turn to for assistance?

    Thanks...

  • RE: Table Structure Change

    Are you appending the data to the existing table? Or are you truncating the table, recreating it and loading it?

  • RE: source control for stored procedures

    I agree VSS is now more intergrated with SQL server making it easier than ever to keep version control. There is another product that I believe ships with Rational...

  • RE: Clearing transaction logs

    Also, what version of SQL Server are you running? If you are running SQL 7.0, there is a known issue regarding shrinking the transaction logs in this version. ...

Viewing 15 posts - 61 through 75 (of 112 total)