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 …
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, …
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 …
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.
