Bertrand Le Roy

Well, then you'll be happy to know "that one guy" (who was not "placed in this position" but decided of his own volition to produce something valuable) decided not to produce any new videos.

It's impossible to diagnose from so little information. Comments on a video are also not the best for such a discussion. You can ask for help on one of the places http://www.orchardproject.net/discussions links to.

As always, look at your logs.

^ LOL :D Wait until you see the one about running on Ubuntu.

https://www.nuget.org/packages/MailKit/1.3.0-rc1-1 and https://www.nuget.org/packages/MimeKit/1.3.0-rc1

@Patrick: The audio version seems to be 44MB, which should be fine on mobile. For the video, maybe it would be better to stream it if possible, or otherwise subscribe to the low quality video version (<150MB). All videos are also available on our YouTube channel https://www.youtube.com/channel/UCvtT19MZW8dq5Wwfu6B0oxw

@OzBobWa: Thanks, I fixed the links.

Why is Stephen entirely silent?

Sure: the downloads tab on the bottom gives you access to wmv, wmv-hd and mp4.

SQL Server does optimize non-sproc queries pretty well. Contrary to what most people think, they are even faster in a number of cases because the server is often able to create a better execution plan depending on the parameters, as opposed to sprocs that have a fixed execution plan, which sometimes negates the effect of not having to compile the query.
As always when perf is involved, measurement is the only way to find out.