Paul White (@SQL_Kiwi) is an independent SQL Server technical consultant with 20 years experience, specializing in performance tuning the SQL Server Core Engine, and is well known for his expertise in execution plans, the query processor, and the query optimizer. Currently living in New Zealand, Paul writes the SQL Server internals blog Page Free Space.
Over the years, Paul has worked internationally on a number of high-volume critical systems where ultimate performance and reliability were the primary goals. A SQL Server MVP since 2011, he contributes regularly to a range of web sites and forums, including Database Administrators Stack Exchange. Paul has also spoken at a variety of user groups and community events such as SQL Saturdays and the annual SQL Pass Summit.
Paul White (@SQL_Kiwi) details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should read this.
Paul White (@SQL_Kiwi) has put together a fantastic series on concurrency, the ACID properties of statements and transactions, and isolation levels in SQL Server.
Paul White (@SQL_Kiwi) continues his series on ACID and transaction isolation levels in SQL Server, giving us fair warning about some potential issues with the SNAPSHOT isolation level.
Paul White (@SQL_Kiwi) looks into a limitation of filtered indexes and demonstrates some dangers involving performance degradation and the risk of deadlocks.
Paul White (@SQL_Kiwi) continues his series on ACID and transactions in SQL Server. In this installment, he discusses the SERIALIZABLE isolation level.
Paul White (@SQL_Kiwi) kicks off a new blog series about ACID – atomic, consistent, isolated, durable – and how many people make incorrect assumptions about how these things work in SQL Server.