SQL Server, Why doesn't my update come to an end? a light post!
Hi guys, Today i present to you a light post at base level but however very useful! There are questions that come back often. For example: Why doesn't my update come to an end? Why I am not be able to drop an index? The answer is always the same: Something is blocking ! Enjoy the reading! Find who is locking! Have you an update that doesn't come to an end? Are you trying to drop and index but is not possible? Well, your T-SQL statement is blocked by another T-SQL statement . In this case you can run this command: Sp_who2 This command display a list of processes (called SPID). From this list you can identify your process through the command column. In our example we are the SPID 106 and we are executing a DROP INDEX command. Now look at the blkBy (blocked by)) columns. A value in this column is the process id (SPID) of the command that is blocking . So now we konow that is the SPID 90 that is blocking our drop index command. If y...