How the CHECKPOINT process deals with uncommitted transactions

At the beginning of my SQL Server Performance Tuning Workshop I always start by giving a general overview of what happens within SQL Server when we execute a query. Executing a SELECT query is quite simple, but executing a DML statement is more complex, because SQL Server has to change ...

Read more

Come to SQLBits, and learn about Locking & Blocking

I’m delighted to announce that I have been chosen to present a precon about Locking & Blocking in SQL Server at SQLBits on May 5 in Liverpool/United Kingdom. As you might know I really enjoy talking about locking & blocking, because it’s one of my specialities. And I’m also already ...

Read more

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top