In today’s blog posting I want to cover a very important topic that every DBA should know: how to perform a page level restore operation in SQL Server. Imagine that you have a corrupt page in SQL Server, and instead of restoring a complete database you only want to restore the page in question from […]
How to perform a Page Level Restore in SQL Server + read more
Today I have uploaded the 29th SQL Server Quickie to YouTube. This time I’m talking about the transaction isolation level Read Committed Snapshot Isolation (RCSI) in SQL Server. Thanks for your time, -Klaus
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
Optimistic Concurrency in SQL Server + read more
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
Parallel Execution Plans + read more
