Hi Nick,

Yeah, it's making that call on what calculation against the data is going to result in... anything.

For example, if you have two columns of data, KMean would let...

I hit those errors with the...

It really does depend on the organization.

Probably, you'll be in the on-call rotation. You'll probably have a second-tier person to back you up in case you get stuck. You'll...

Alan.B (12/7/2015)

---

I'm with what everyone has said so far. I would add, however, that, if you are doing aggregations, you might want to consider an indexed view with the aggregations...

Ah, figured out that part of my problem is that I don't have the GGPLOT library. Off to track that down.

Seriously, thanks again for this. You've started me exploring exactly...

I'm getting errors from this bit. It could be that I'm using RevolutionR, or it could be Steve's formatting:

# load GGPLOT library(ggplot2) plot.data <- data.frame(pca$x[, 1:2]) g <- ggplot(plot.data, aes(x=PC1,...

Looks like this code was missing a set of quotes:

data <- read.csv("hotspots_data.csv)

Or am I wrong on that. I ran my local copy with closing quotes around the hotspots_data.csv file name...

Thanks for this. Very timely. I'm just barely getting started in R and this was extremely useful.

A couple of notes though. The query you start with, it has an ORDER...

I'm with Orlando. At the root, all three approaches are fundamentally the same and will all perform equally well. It depends on your implementation and requirements as to which is...

You could make the call through SQL Agent and use Powershell at the command line. There are any number of examples of this.

I'm helping to write a book on data lifecycle management. You can check it out at thedlmbook.com. We're covering everything you need to set up proper processes to ensure a...

Take a look at the book "Troubleshooting for the Accidental DBA" That will give you plenty of knowledge to do this. Plus, it's free to download.

I would not make it a system function. In general if I have something I want available to all, just putting it in master is a good enough approach. there's...

Finally figured it out (I'm not sure Microsoft Edge is worth the trouble). Anyway...

These plans seem somewhat different from the earlier queries and there is no parameters or local variables...

I'm doing something wrong. I can't get either plan to download to my machine.