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,903 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,985 reads

I was looking back at my year and decided to see if SQL Prompt...

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

I’ve often done some analysis of my year in different ways. Last year I...

Comments posted to this topic are about the item The North Star for the...

Comments posted to this topic are about the item Multiple Escape Characters

Hi, below i show various results trying to reach our ftp site (a globalscape...

In SQL Server 2025, I run this code (in a database with the appropriate collation):

SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';

What is returned?