This is where things get fun.

Defining what "correct" results look like is very entertaining. I've worked with people who put WITH NO_LOCK on every single query in the...

Combine Joe's answer with Lynn's answer and you're most of the way there.

To get the precise size of the log you're going to have to do some testing...

To implement RCSI there really isn't anything you need to do to your code. It's the more traditional snapshot isolation that requires code changes. As Perry already stated, this will...

I'd suggest you take a look at the Minion tools. They have a great deal more flexibility and management than Ola's scripts. I'm not knocking Ola's scripts, they...

Yeah that could do it fine too. It will likely block the table for a time (depending).

To keep the table from being accessed, well, it really depends a lot on your system, the configuration etc. If you do not have SA or DBO for all your...

Try switching to PowerShell.

How do you identify a return trip of the second address is different? You didn't mention it, but do you also have a RiderID or something along those lines? Otherwise,...