Pain: Performance tuning
SQL DBA’s email to SQL Developer “Your query is too slow and eating up server resources. Please tune it”
Senior SQL DBA’s email to SQL Developer “Your query is too fast. Slow it down :P”
Well there are thousands or should I say tens of thousands of ways to do performance tuning of SQL queries. Almost every SQL developer has to do it.
I will just cover one out of the box feature called ColumnStore Index introduced by Microsoft SQL Server 2012.
As we all know, Indexes are used to help SQL engine to create efficient query plans thus giving optimal result. So I wont go into basics of indices here as its a big subject as a whole.
To understand columnstore index, first we need to understand how index works.
Prior to SQL Server 2012. whenever a table was applied with index (for particular column or…
View original post 146 more words