How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far

I'm pretty sure that we've all found ourselves in the situation where we've run an INSERT, UPDATE or DELETE script and it seems to be taking an age to run. We've done all the usual checks, there's no blocking going on, things are happening but it just seems to be taking an age to finish. ... Continue Reading →

Oct 5, 2017 3

Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.

As the famous Bard once said, "To disable indexes or not to disable indexes, that is the question?". Well maybe that wasn't quite what he said but it was a discussion that came up here just recently. We've found ourselves inheriting a process that has to copy all the data from one database into another,... Continue Reading →

Sep 25, 2017 0

Up ↑

Tag: insert

How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far

Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.

David Fowler

Adrian Buckman

Archives

Follow me on Twitter

Recent Posts From The Undercover DBAs