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.

And, of course, there's always the MSDN Books Online published by Microsoft. The documentation for SQL Server is always helpful to use.

Parameters or local variables? There is a difference. Parameters can be sniffed, sampled, so that the known value is used to retrieve statistics from your columns or indexes as part...

But they should.

More and more, it's a requirement for new functionality within SQL Server. Ultimately it's going to be a...

xsevensinzx (12/2/2015)

---

Can't stress semi-colons enough. I didn't have it in my sample, but it should be at the end of each statement. Don't forget to put it at the beginning...

Glad the book is proving useful. If you are interested in the aspects of the book not covered in the first chapter, database deployment, automation, source control, etc., we have...

Not that I know of. FORCE ORDER might do the trick. Forcing HASH or LOOP might also work. Experimentation is probably the only hope. It's just bad code.

GilaMonster (12/1/2015)

---

Yes, good teams do, because they know that making time to establish standards and practices saves time later on.

If...