|

Performance Tuning with Columnstore index using Batch Processing

As we all are aware, SQL 2012 introduced columstore indexes which is based Microsoft’s xvelocity in-memory engineĀ  and as you might have heard and read in numerous articles it is known to provide 5-50X improvement in performance of queries. Reading and Hearing 5-50X improvement in performance of queries causes many eyes to pop-out and they…