chris.smith 3432 (12/15/2015)

---

Hi Nick,

I enjoyed this article very much. I am an Analysis Services user, but I put together some (much simpler) R examples for our R users to...

yogmangela (12/15/2015)

---

Hi Nick,

Thanks for the tutorial. Great to see someone putting effort to share their knowledge.

Just a little hickup.

below variables are not assigned for last graph.

- product_contributions

- by_region_trimmed

I am getting...

Kyrilluk (12/15/2015)

---

Excellent article, thank you.

For those of you that just hate creating views or would like to keep experimenting with different sql queries and have windows connection rather than a...

Completely agree with you Grant. Understanding the various tools and their applications is definitely a learning curve!

Definitely second someone else's recommendation for Andrew Ng's course, Machine Learning, on Coursera. Though...

Hi All, re. "incompatible lengths for label, colour and hjust":

I just had a realisation; in the original post I had simply removed the table names for privacy. But, the original...

Hi Grant,

So glad to hear there are lots of other people out there as excited about the marriage of R with SQL Server as I am! The following will plot...

Hi Matthew - thank you for your response, glad you like the article. Love your idea of pulling out time-series metrics for performance! What a great opportunity to use R...

Hi Bill, nice changes adding in additional identifying data such as database name and index name. The exact values you get will obviously vary from one database to another, but...

Your first time? Wow - you are flying! This should close your connection:

odbcClose(dbhandle)

Regards,

Nick

Hi Barnaby, thank you for putting it all together in one script. I think you have pretty much answered everyone's questions in one great post! 🙂 Do you think it...

Hi Grant, thank you for your eagle eyes! Well spotted mistakes in all of these cases: missing RowCount, missing closing quote in read.csv(), and requiring the GGPLOT2 library.

Many thanks!

Nick

Hi Robert - good news! This analysis does not need SQL Server 2016. Run the DMV query, save the results to a CSV and then use R to read the...

Hi Craig, thank you for your response. I don't think it is really terribly difficult, but I guess the big disappointment is that it isn't a hard and fast answer...

I so strongly disagree with Steve and the authors of the post linked to and it is an argument I am passionate about. Specifically, I do not believe that we...

Hi Paul, we actually thought about doing the same - just adding a new publication. It would have been a nice simple way to go. But in the end, the...