Subscribe to this blog
James' SQL Footprint
Love SQL Server, Love life.
Archives: March 2012
Monitor SQL Server Backup job duration
if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the SQL Agant backup job which is created by maintenance plan, it will be difficult to monitor the percentage of backup process.
here you can use the query below:
==========================================================
SELECT…
here you can use the query below:
==========================================================
SELECT…
0 comments, 534 reads
Posted in James' SQL Footprint on 31 March 2012
Select : Lock or No Lock?
Here is a post I happen to find today: why select command is not blocked by update command?
First, I thought it might be a transaction isolation level issue, but when I dig into the problem, something interesting pop up.
Here is the script to repro this issue
first create…
0 comments, 602 reads
Posted in James' SQL Footprint on 30 March 2012