Continuation from the previous 43 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is dedicated to the monitoring aspects of the Columnstore Indexes, which should help you understanding what is going on with your production system. Columnstore Monitoring Options First of all…
Continuation from the previous 42 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is dedicated to the Transaction Log behaviour, which might explain some of the behaviours of the Columnstore Indexes, observed in the earlier posts in the series. I decided to…
Every autumn one can observe the pilgrimage of almost all Microsoft Data Platform specialists (SQL Server, Excel, Azure Platform) for one of the cities in the USA and most of the times to Seattle. The reason behind it is the…
Continuation from the previous 41 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Important Disclaimer – I have started writing this blog post over 1 months ago, but because of all engagements such as SQLSaturday Portugal, only today at night managed to finally finish…
Did you ever faced a situation when needing to generate dynamically a SQL Server Reporting Services Report on-demand, at some strange hour, such as 4:30 AM because of the different timezones involved or because it takes so much time and…