Viewing 15 posts - 1 through 15 (of 101 total)
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...
December 18, 2023 at 3:06 pm
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...
December 18, 2023 at 2:13 pm
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...
December 18, 2023 at 1:15 pm
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.
October 17, 2022 at 7:52 pm
DesNorton,
Thank you so much, this looks to be exactly what I need. Going to test some more.
Thank again
March 14, 2022 at 3:22 pm
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...
March 14, 2022 at 2:47 pm
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 what I...
September 29, 2021 at 7:16 pm
Jeff,
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...
December 29, 2020 at 5:49 pm
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!
December 29, 2020 at 4:44 pm
This has been great Luis!! I have some more research to do on my end, I really appreciate the insight!!
October 11, 2017 at 11:58 am
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...
October 11, 2017 at 11:08 am
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...
December 14, 2016 at 11:07 am
@jason, thanks for the reply, but that is information that I am already aware of and tried to state that in my original post.
@perry, I agree...
December 14, 2016 at 8:12 am
Thank You GilaMonster for the replies. I did get this figured out. There was in fact remnants of replication still on the database that was set up in...
July 30, 2016 at 3:15 pm
Viewing 15 posts - 1 through 15 (of 101 total)