Photo by Pixabay on Pexels.com This was an interesting question that I was asked yesterday and something that I'd never really thought of before. Can you delete the top x number of rows based on an ORDER BY? Why would you want to do that? Well let's just assume that we have a 'people' table... Continue Reading →
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 →