Yes, or you can use LIKE.  I don't know whether it'll be more or less efficient than CHARINDEX, or exactly the same - you'll need to test.

[code...

Use INSERT...SELECT.  You can do it all in one go, or you can break it into batches if you're worried about blowing your transaction log or locking too many rows...

Almost certainly.  Please post the actual (not estimated) execution plan.  And when posting code, try to look as if you care about it - if you don't then it's likely...

(1) Find a suitable folder on the server to which the SQL Server Agent account has at least read permission
(2) Copy the .dtsx file to that folder
(3) Amend...

Either copy the file to a location on the server, or create a share on the computer where the package is stored, and put that in your job step.  The...

Yes, but is it a physical drive on the same computer that the job runs on, or is it a drive on the computer on which you're developing or storing...

Sindhu

Is H a physical drive on the computer on which the job runs, or is it a mapped network drive, or is it a drive on another computer? ...

I too am not sure what you're trying to do.  How are you attempting to do the insert and what error message do you get?  You could try creating two...

Edward

That depends on your indexing.  A log table is the perfect candidate to have its clustered index on the Date column.  If that's what you have then

Edward

Yes, you can delete in batches.  Just delete TOP 10000 (or the number of your choice) over and over until there are no more rows that you want...

Edward

With 18 million rows, and not narrow ones at that, you'd have to expect it to take a long time.  You could try creating a new table and...

Does the outorder table have a primary key or unique constraint on the outorder column?  If not, there could be duplicates in that table and that would be why you're...

SELECT TOP 25 PERCENT x.ColList
FROM (
   SELECT TOP 2 PERCENT t.ColList
    FROM MyTable t
    ) x
    

John

You could select TOP 50 PERCENT FROM TOP 1 PERCENT (or any other two numbers that multiply to 0.005).

John

I don't know, but I know where you can find a lot of ids!

John