Performance impact of memory grants on data loads into Columnstore tables
First published on MSDN on Jun 02, 2017 Reviewed by: Dimitri Furman, Sanjay Mishra, Mike Weiner, Arvind Shyamsundar, Kun Cheng, Suresh Kandoth, John HoangBackgroundSome of the best practices when bulk inserting into a clustered Columnstore table are: Specifying a batch size close to 1048576 rows, or at least greater than 102400 rows, so that they land into compressed row groups directly.Build a recommendation system with the support for graph data in SQL Server 2017 and Azure SQL DB
First published on MSDN on Apr 21, 2017 Authored by Arvind Shyamsundar and Shreya Verma Reviewed by Dimitri Furman, Joe Sack, Sanjay Mishra, Denzil Ribeiro, Mike Weiner, Rajesh SetlemGraphs are a very common way to represent networks and relationships between objects.
