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,922 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

3,014 reads

Making Data AI-Ready, Part 2 (This is the second article in a three-part series...

Can you use your GPUs when running a local model under Ollama? You can,...

The concern that a particular technology is going to destroy the world seems to...

Comments posted to this topic are about the item RegEx Functions III

Comments posted to this topic are about the item Optimized Locking in SQL Server...

Comments posted to this topic are about the item Finely Tuned Models

If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.