SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James' SQL Footprint

Love SQL Server, Love life.

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:

Read more

2 comments, 1,649 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…

Read more

1 comments, 2,725 reads

Posted in James' SQL Footprint on 30 March 2012

Newer posts