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.

Do you mean a single disk of a R-5 array?

We've had notifications set up before in software to notify administrators. At the least this should be written to the Windows...

I don't think that's an accurate count. If you check the properties of each database, you will see the size and space available. The difference is your data, index, and...

You can do things like

select venue, date, avg(los)

from table

group by venue, date

Are the dates really dates only or are times in there. You might be able to clean...

I guess I wasn't thinking of just bad code, but decent code you write to get a job done. We all could stand our code to be tuned to some...

Sorry to hear that David and good luck taking it again. Definitely spend some time just doing stuff in SSMS, add users, permissions, etc. Just talk through exercises and get...