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.

SAN snapshots are good for speed, if you need to quickly debug things. We used to use them to get Customer support people a quick look at a current db,...

Pizza/bike shop, interesting. I'd come by!

I always wanted a book store/coffee shop, though having a liquor license at night would be fun.