Log in | Register

Concurrency & Transaction Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Concurrency & Transaction Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Concurrency & Transaction

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Server 2016 CTP – Alter Column Online Operation

Hi Friends,

Various new features and improvements are coming with SQL Server 2016. Various performance improvements are also added to the CTP versions. Today, I’ll show you one of them i.e. Alter Table … Alter Column online operation.

Blocking is one of the major problems when you work on performance tuning for SQL Server. We knows […]

Hidden Gems of SQL Server 2014 – Managed Lock Priority

Problem Statement:
Theoretically online index rebuild does not block. Practically boom… They do. Online index rebuild operations does not take down your indexes. But there is a point in the index rebuild where they build the new index structure and switch from your old index structure to new one. This is a simple metadata pointer […]

READ UNCOMMITTED Isolation Level honors locks

Hi Friends,

It’s a well-known fact that READ UNCOMMITTED Isolation Level in SQL Server allows dirty reads. In other words, if a transaction is running under READ UNCOMMITTED Isolation Level, it does not honor any locks held by any other transaction. Did is say ‘any’? Well there is a small exception or twist to this.

Let’s […]

Newsletter_Footer