Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...
When calling WithInstance (https://github.com/golang-migrate/migrate/blob/master/database/sqlserver/sqlserver.go#L59) to construct the SQL Server driver, sometimes ...
In SQL Server, the WITH(NOLOCK) statement is used to perform dirty reads, which means that it allows the query to read uncommitted data from other transactions. This is commonly used to avoid locking ...