Can someone of you experts please advise me on this situation:
I have a dedicated hard drive. It contains the database and log file. I have run a query over night and the log file maxed out the size of the drive (500k left). The query did not finish so I cancelled it. But nothing seems to happen (one would expect the log file to shrink ... ?). Shall I just be patient and let the query ‘cancel’ or is there another course of action (I have been waiting for almost 3 hours now)? Thanks!