I think you're right, but I'm not sure the exam delves this far down. From what I remember, execution plan is pretty much used for the query plan as a...

webrunner, that's a good point. I'll add that to the list, and I like the idea.

So in summary

Execution Plan = Query Plan + Execution Context

Context is used specific information in terms of parameters and other data structures that could change for that proc/batch.

There are quite a few people here with Oracle skills, including Jeff. I'm not sure Jeff wants to help with Oracle, but worth a try.

I thought AIX was pretty cool,...

I'm not sure there are training trends as there just isn't a lot of variety in classes. There are specific classes on certain topics, but not enough people attend them...

Do you mean your Windows logs have wrapped? Likely you need to make them larger then, or setup a better auditing system.

AFAIK, you can't run SQL Server locally and put the files on Amazon's cloud service. You can contract with them for database services, and in that case, the speed of...

If you create #temptable, each user sees their own copy. They don't see each others.

I think that if you don't want companies to offshore, you need to do a good job here. Make it hard for them to see a value, despite paying more...

Being an economics guy, I take this a few ways. I tend to agree with what Lynn just posted about making things more US business friendly.

Outsourcing is fine. Not every...

Jeffrey is correct. You just access it with the name you used to get to it.

If you create a global temp table it is visible to other connections, but the...

You have the reasons that I'd give, and include the risk of keeping stuff together. Ultimately, however, you'd test both, then present a case to management if you and the...

Didn't know that they could integrate with SQL to set up for recovery.

The reasons you give are pretty good ones for not using their tool, especially if there is a...

Here's one: http://www.developer.com/net/csharp/article.php/2230091/Parsing-HTML-in-Microsoft-C.htm

Google for parsing HTML.

With a pad. Set the log as large as it will grow with some pad in there in case the data activity is different.