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.

No worries, and feel free to debate it in another thread. I'd like to try and keep this more on the topic of long hours, or avoiding them. Please feel...

Just be careful you aren't using any alias like

select as.*

from AppleSales [as]

You need a WHERE clause.

select x

from mytable

where somedate > @begdate and somedate < @enddate

Yes, you don't use TRUNCATE in 2008. Just set to simple mode.

Lowell's summarized things well. You need a parsing application to strip out the HTML and get the data.