Robert Hartmann

My name is Robert Hartmann. I am an M.Sc Computer Science graduate with a specialization in databases. I've worked as a DBA for 2 years now, and recently earned an MCSA certification in SQL Server 2012. My focus of interests regarding SQL Server lies in in-depth knowledge as well as query optimizing and tuning, though I also sometimes work with SSAS and SSIS. I try to be as simple as possible in my writing in order to reach as many interested readers as I can.
Outside of work, I have a beautiful son and am married enjoying my family. You can follow me on twitter, or simply subscribe to my RSS feed on http://dirtyread.de/.

Minimal blocking UPDATE statements

by Robert Hartmann

dirtyread.de - in-depth sql server blog

How to perform minimal blocking updates in a high concurrency environment

2022-04-14

325 reads

Blogs

AI Step 1

By Vinay Thakur

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

A New Word: Nachlophobia

By Steve Jones

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

Migrating database with many orphan users.

By JasonO

I am currently upgrading a very old database running SQL Server 2008 to SQL...

Active and Active Cluster

By shiv-356842

Hi Team, I am planning to apply security updates for SQL Server 2016 on...

Visit the forum

Question of the Day

What is returned from this query?

SELECT ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011 , ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012 , ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013;

See possible answers