Running *.XDF files using RevoScaleR computational functions versus have dataset available in Columnstore table or in In-Memory OLTP table will be focus of comparison for this blog post. For this test, I will use the AirLines dataset, available here. Deliberately,…
Monthly Archives: April 2017
Performance differences between RevoScaleR, ColumnStore Table and In-Memory OLTP Table
Tagged with: columnStore, In-Memory OLTP, Memory Optimized, performance, R, Regression, RevoScaleR, sp_execute_external_script, T-SQL, thoughts
Posted in Uncategorized
Posted in Uncategorized
Saving input and output with sp_execute_external_script using temporal table and file table (part #2)
In my previous blog post, Saving input and output with sp_execute_external_script, I was exploring the possibilities how to capture the R code that external procedure sends it internally to the Launchpad.exe program. And a blog comment by reader Bob gave…
Tagged with: FileTable, input, Logs, R, sp_execute_external_script, SQL Server, Temporal Table
Posted in Uncategorized
Posted in Uncategorized
Saving input and output with sp_execute_external_script
Again I was at the point, where I needed to store and save to external file all the R code that was executed through sp_execute_external_script. Soon, you will find out several interesting things. To show the example, I will start…
 | tomaztsql on Retrieving user access list to… |
 | Paola A Zambrano on Retrieving user access list to… |
| “Reverse Hello… on Little useless-useful R functi… | |
 | Max Petter on Using R and Python in Microsof… |
 | detlef kissel on Using R and Python in Microsof… |
TomazTsql 