index rebuild online

SQL Server AlwaysOn : readable secondary replicas and index rebuild online vs offline

A couple of weeks ago, I was involved in a discussion on the French forum developpez.com about SQL Server AlwaysOn and availability groups, index strategies and the impact on the readable secondary replicas. During this discussion,(…)

SQL Server: Online index rebuild & minimally logged operations

A couple of days ago, I encountered an interesting case with a customer concerning a rebuild index operation on a datawarehouse environment. Let me introduce the situation: a “usual DBA day” with an almost usual error message found in your(…)