Bad style of the query (I know, it is intended here, but you should never write it this way in real code).

Instead of

SELECT 
  c.CustomerName,...

The full backup doesn't affect the transaction log - so you can just perform the 3pm log backup as normal and use that to restore to the 2pm point in...

You have just learned a valuable lesson - scope does matter in SQL Server.  Sub-queries have full access to the outer queries columns - so you can easily reference a...

To answer your last question - no, you cannot restore to a point in time without having the full backup *prior* to the event and all transaction log backups from...

I can see why CAST might do that (although I'd expect it to cause an error instead), but...

Make sure you check the options on all pages.  By default the GUI includes a tail log backup.

The GUI - by default - performs a tail-log backup of the existing database when you perform a restore over that existing database.  If you do not uncheck the box...

Yes - you definitely need to be using precedence constraints between tasks.

1. Reads (select) don't block other reads - locks on a select could prevent inserts/updates/deletes on the table(s) but...

First of all, the warning was telling you that you have columns that you're doing aggregates like SUM() and COUNT() on contain some NULL values.  Are you sure...

This is probably an issue with *how* SQL Server is sending the query to the DB2 instance.  As soon as you use that view - and either join to another...

Thank you for the update - glad this worked for you.

FYI - my approach is to disable the non-clustered indexes and rebuild all indexes after the data loads.  I only...

my other peer ran the query select * from db1.dbo.view1.  which worked and is the query he doesnt want to change in his app.  we arent gurus but in...

In the OLEDB Destination - in SSIS - you control the batch and commit sizes.  If you leave those as default then all of the rows processed through the pipeline...

If all you need is the last 4 from the card number - I would use this:

RIGHT(LEFT(s_Result, CHARINDEX('|', s_Result) - 1)), 4) AS last_four

No need to determine...

thx, what if he puts a surrogate db on the new server called A.   And it has a view that thru the linked server sends the correct query to...