SQL Server Quickie #28 – the Transaction Isolation Level Serializable
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
Pessimistic Concurrency in SQL Server
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 …
How to read an Execution Plan
Today I want to talk about a very “simple” topic: how to read an execution plan. At first this seems to be quite an easy question, but when you look into the details of the answer it can be surprising. There are 2 different ways to read an execution plan – from right to left, …
How SQL Server executes a query
Today I want to lay out today the foundation about how SQL Server executes a query. This is a very important topic, because everything else regarding performance tuning and troubleshooting is based on these concepts. The following pictures give you an overview about the most important components within SQL Server, that are used when we are …
The LaCie Rugged RAID Thunderbolt
In today’s blog posting I want to talk about the LaCie Rugged RAID USB 3/Thunderbolt enclosure that I have “tuned” for my personal needs a little bit . The “normal” configuration First let’s talk about the normal configuration of the LaCie Rugged RAID. The LaCie is shipped with 2x 2TB disks that you can use …
