Forum Discussion
Poor performance when direct querying to an Azure SQL DW
Hi guys, I am currently working on a project for a client. They have an Azure SQL DW, which stores data from numerous censors in a building they own. We are talking about several 100 million rows...
Hi CNR Spicer! I think for this scenario clustered Columnstore indexes - key.
https://msdn.microsoft.com/en-us/library/dn817827.aspx?f=255&MSPPError=-2147217396
https://channel9.msdn.com/Events/DataDriven/SQLServer2016/Real-Time-Operational-analytics