Yes, it's not a complete solution, of course.

You still need to have an endless loop, as you want to pick a new item in the queue as soon as it's...

Instead of deleting 90% of unwanted data keep 100 percent of wanted data.

Your data refresh process should look like this:
1. Create a "clone" table with similar name,...

Adding to the pile:

Performance of operations on DATETIME2 is 20...100 times (depending on the operation) worse than on datetime.

Because of reversed sequence of bytes statistics are...

Once again - Thank you so much Microsoft for ditching sp_makewebtask.

12 years on - people are still trying to reinvent it.