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...

2012-03-31

1,902 reads

Select : Lock or No Lock?

Here is a post I happen to find today: why select command is not blocked by update command?

http://blog.csdn.net/zjcxc/article/details/4383113
First, I...

2012-03-30

2,981 reads

This was announced last week at Microsoft Ignite and it's been covered by others...

"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...

Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...

Comments posted to this topic are about the item The Ending Substring

Comments posted to this topic are about the item Done is Better than Good,...

Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...

In Azure SQL Database and SQL Server 2025, if I run this, what is returned?

SELECT '[' + SUBSTRING('Steve Jones', 7) + ']'