Column Store Indexes in SQL Server 2012 October 31, 2013 Introduction: We will discuss Column Store Index and will try to understand the performance...
Mining the AWR to Identify Performance Trends October 31, 2013 Sometimes it's useful to check how performance of a SQL statement changes over time. The diagnostic...
Duplication: divide et impera September 19, 2013 For me, every Monday morning starts with the same routine. I refresh some QA databases from...
Duplicate Database from Active Database — Just Works! July 2, 2013 My friend Øyvind Isene suggested that I store a DUPLICATE RMAN script that works in a safe place in...