I tend to agree with you, Wayne. No time for silly "how do you think" questions. But that's why I wouldn't work for Microsoft: I don't fit in. They're looking...

We can coordinate if you'd like and we had a number of people take their names out of the running for prizes, myself included.

Best wishes from me as well.

Great answer!!!!

That's probably why you got hired. Thinking business in practical terms.

Make sure you're using TCP/IP. Named Pipes usually is only for local connections.

We used to use a few at different times. We've run DELL servers and they can notify you when there's a failure with their system software.

We've also had the vendor's...

Chris,

I tend to agree with Brandie. I think you had a good response, but you shouldn't necessarily expect an answer back.

Good luck on the next one!

Go side by side, less risk. Big thing is to be sure that a new instance name won't mess up your code/application. This is the safest, especially if you are...

Chris, there are 2 states, but 3 modes. A snapshot should move.

Search hierarchies in SQL Server, but why bother.

Then get the results you need and you'd need to display the tree list in your ASP page. The SQL query would have...

This could be more complicated than you expect or simple. Are you looking to move the contents of a particular view to a particular file each time? Or does this...

Search hierarchies here or on Google for more samples.

I don't think you want to change this proc. Maybe add your own to master as sp_spaceused_2 or something.

Be sure you keep a copy elsewhere. If you rebuilt the master...

This has been moved.

The logs being backed up at 600MB every hour is interesting. Is this an extremely busy system? Can you give us an idea of db size, full...

The need for tuning doesn't imply poor coding. It can, and I'd agree with that, but it also could be that you're trying to make things more efficient, which is...

But does the manhole knowledge say anything about the person? It could be trivia, read on a board like this, learned in engineering class, etc.