Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [r]

This tag is for questions related to the R programming language.

R is a computer language designed for statistical computing and graphing plots based on those calculations. For more information you can visit R's about page.

SQL Server 2016 is featuring integration with R.

42 questions
7
votes
4 answers

Upgrade SQL Server 2016 R Service (in-database)

I am just wondering whether this is doable. I have installed R service (in-database) together with SQL Server 2016 (patched at SP1+ CU1). I notice R service version is at 3.2.2, which you can run the following script to check declare @v…
jyao
  • 3,083
  • 1
  • 14
  • 27
6
votes
3 answers

SQL Server LaunchPad "The service did not respond in a timely fashion" + No Log in ExtensibilityLog

I'm trying to start LaunchPad service but it fails to start with: Error 1053: "The service did not respond in a timely fashion" I've been reading this was common in RC versions but I'm running SQL Server 2016 SP1 + CU3. I've tried to add the…
Dan
  • 161
  • 1
  • 1
  • 5
5
votes
1 answer

System configuration to address poor PostgreSQL INSERT performance

Problem Symptom High CPU usage by postmaster child process associated with client connections attempting to INSERT low-volume rows (results in rows INSERTed 25x slower than using COPY ... FROM STDIN for identical rows). Background Trying to identify…
Whee
  • 189
  • 2
  • 13
5
votes
1 answer

Lifespan of Launchpad-Launched Exterrnal Runtime Processes

When SQL Server uses SQL Launchpad to launch an external runtime (e.g. R or Python) when sp_execute_external_script is used, what's the lifespan of the external runtime process? Does each sp_execute_external_script script execution get its own…
Ben Gribaudo
  • 659
  • 4
  • 13
4
votes
2 answers

What are exact benefits of using R services on Enterprise vs Standard?

I am currently using SQL Server 2016 SP standard edition and want to install R services. In the documentation is said that a stand alone installation is allowed only on Enterprise (Machine Learning Server (Standalone)). Also, I found a post, where…
gotqn
  • 4,348
  • 11
  • 52
  • 91
4
votes
2 answers

Can SQL Server R Services be enabled on a readable secondary?

To avoid excess load on the primary SQL Server, I'd like to install and enable R Services on a secondary replica of the primary server. Is this possible? Also, can I push computations from a remote R client onto the secondary server with R Services…
Minu
  • 391
  • 1
  • 13
4
votes
1 answer

Connecting a standalone Microsoft R Server to a SQL Server with R Services and a SQL Server without R Services

Let's assume I have 3 machines with me. My first machine has SQL Server 2016 with R Services installed on it. My second machine has SQL Server 2016 without R services enabled on it. My third machine has a standalone Microsoft R Server installed…
Minu
  • 391
  • 1
  • 13
4
votes
2 answers

Msg 39011, SQL Server was unable to communicate with the LaunchPad service

We have just installed SQL Server Enterprise 2016 CTP 3.3 on a server that already had SQL 2012 Standard installed. We installed SQL2016 as a Named Instance and have been trying to get the R integration working, but we are having problems running…
Stephen
  • 141
  • 1
  • 4
3
votes
0 answers

View(df) in R throw (function(x, df1, df2, ncp, log = FALSE))

I connected R with SQL Server (in Visual Studio 2017) the connection succeeded this is Setting.R settings <- as.environment(list()) dbConnection1 <- 'Driver={SQL Server};Server= (local);Database=SaVeITDB;Trusted_Connection=yes' this is…
Rand alrand
  • 45
  • 6
3
votes
2 answers

How to TRIGGER/RETURNING this generator function in PostgreSQL?

I am providing a key table to my users in various categories so I am thinking how to TRIGGER/RETURNING the function with each SELECT. Functions to generate shorthand unique IDs The thread answer Generating human-readable/usable, short but unique…
Léo Léopold Hertz 준영
  • 765
  • 3
  • 9
  • 22
3
votes
0 answers

execute R script using a postgresql trigger:

This is my first question here, so excuse me if it does not look well organized: I want to call a R script from a trigger (postgresql) so this script will be executed after an INSERT on my table (with a specific condition on the insert), here is…
AIA
  • 31
  • 2
3
votes
1 answer

How do you set the working directory to a mapped network drive for R language in SSMS?

So I'm messing around with the new "Integration with R" feature in SQL 2016. However, having trouble setting the working directory to a mapped network drive (Z:) within SSMS. Here's my code: EXEC sp_execute_external_script @language = N'R', @script…
Chinesinho
  • 611
  • 2
  • 8
  • 15
3
votes
2 answers

SQL Server 2016 Install - R Server and R Services Install Failed

I just installed SQL Server 2016 Developer and included R Server and R Services to get installed as well. Everything installed correctly except the R Server and R Services. The log file contained this: 2016-07-29T17:07:39 INFO Command invoked:…
Randy Minder
  • 2,032
  • 4
  • 22
  • 41
3
votes
2 answers

SQL Server R Services - Could not find stored procedure 'master..xp_ScaleR_init_job'

I'm trying to run a data science experiment as explained in this tutorial. The tutorial has 5 lessons, and each lesson has a few sub-sections in it. For this tutorial, I am using a SQL Server 2016 RC3 Virtual Machine on Azure, with R Services…
Minu
  • 391
  • 1
  • 13
3
votes
1 answer

Using SQL Server 2016 R Services over a standalone installation of Microsoft R Server

I've been experimenting with SQL Server 2016 and its R Services. I also have a standalone Microsoft R Server installed on my machine. What is a good use-case to use SQL Server R Services over a standalone Microsoft R Server, since both feature…
Minu
  • 391
  • 1
  • 13
1
2 3