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 on the principles of Row …
Yes, it can happen sometimes: you install a WordPress plugin for your website, and after some testing period you don’t like it. Therefore you uninstall it. Very simple, very easy. Unfortunately the reality is a little bit different as you will see in this blog posting. My website was slow, very slooooow As you might …
How an uninstalled WordPress Plugin can cause performance problems + read more
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 introduction to the most common …
Today I have uploaded the 28th SQL Server Quickie to YouTube. This time I’m talking about the transaction isolation level Serializable in SQL Server. Thanks for your time, -Klaus
SQL Server provides pessimistic and optimistic concurrency models that define how concurrent queries are executed. In todays blog posting I want to give you an overview of the various isolation levels that are part of the pessimistic concurrency model, and in a subsequent blog posting I will talk in more detail about the optimistic isolation …
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
