Thank you, Chrissy321 for the advice here.  I didn't post any code, because at this point everything I have tried hasn't been close to correct, so I am starting from...

Phil,

At this point everything is on the table!  Any info you can give on this would be appreciated.  We would be using ADF for this work as well.  It should...

Phil, adding the date logic to the WHERE clause really didnt affect performance at all.  I thought about deleting records after the INSERT as well, but again, was trying to...

Thank you all for the help!  Phil's suggestion worked for me, I was trying to avoid it as there is no leading index on the date columns.

I as well need...

Thank you for the reply, fredrico_fonseca...

Unfortunately, I am still pulling in data past Oct 31st 2023 with this additional logic, so Im still digging in.  With regards to the batch...

This is actually perfect Ken, thank you!

I must have missed the notification for this reply as I am just now seeing it.

Thank again.

DesNorton,

Thank you so much, this looks to be exactly what I need.  Going to test some more.

Thank again

Scott,  I hope you dont mind me bringing up an older topic, but I have question about this or rather I am trying to add to this logic and am...

Thanks for the reply, Scott.  That unfortunately is not working.  It moves the "incorrect syntax" line from the plus sign to the to the first @sql.  Below is...

Jeff,

Looking at https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql?view=sql-server-ver15

It states that the used_page_count accounts or in row, LOB and overflow.  And, looking at sp_spaceused, from what I can tell and from my simple example...

• This reply was modified 3 years, 11 months ago by  GBeezy.

All great answers and all of them very helpful!

I will be using the used_page_count for my calculations.

Again, I appreciate everyone's help!

Thank you both for the clarification!!

This has been great Luis!!  I have some more research to do on my end, I really appreciate the insight!!

Thanks Luis!

All three of the queries I provided Perform an Index Seek on the non clustered index and a key lookup, so they do use the Index and...

The LSBackup job places the file on a network share and the LSCopy job copies that tlog backup from the network share locally to the secondary server where the LSRestore...