Optimistic Concurrency in SQL Server

Today I want to talk about Optimistic Concurrency in SQL Server. A few weeks ago I have already blogged about Pessimistic Concurrency that is the default concurrency model that SQL Server uses out of the box.  Row Versioning Optimistic concurrency was introduced back with SQL Server 2005 and is based ...

Read more

Parallel Execution Plans

Today I want to talk in more detail about Parallel Execution Plans in SQL Server. Executing a query with a parallel execution plan means that multiple threads are used by SQL Server to perform the necessary operators from the execution plan. In the first step I will give you a general ...

Read more

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