Well, if u want to go that route, you could come in extra early and put all those DBs in read-only mode :), but I'd go with the first advice...

I'd work with the net admins and get it rigged so that you can back it up to your machine or any other server on the network. That is...

Believe it refers to maintenance actions such as moving a table online, partitioning a table online, accessing a database that's partially damaged, performing online piecemeal restore, etc. Got that...

Considering that they want you to write some procs, you need to understand in a small company you'll tend to wear many hats. When I worked at a company...

Here is a basic outline of how we do ours. One note, a Rebuild Index is a little misleading, it not only rebuilds but also performs a Reorg.

User and...

All excellent info in these responses and I agree with all of them. In our company we have a project request process in place and when our development team...

It certainly matters...here is a dated article but it has some good points you can reference...

http://www.sqlservercentral.com/articles/Miscellaneous/datatype/173/

😎

I realize MSPress was knocked, but I have been happy with the MCTS 70-431 training kit...

http://www.microsoft.com/mspress/books/9364.aspx

😎

I realize this thread is way old :ermm:, but for the sake of documentation I came across this same problem. I had to do the RESTORE by moving the mdf...

I realize this thread is way old, but for the sake of documentation I came across this same problem and when looking for a solution it would've been nice to...

My thoughts exactly Colin.:)

I found this article to be very helpful and informative concerning statistics...

http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx

I use a 3rd party tool by Idera called SQL Diagnostic Manager. Like Dan Owen noted, you need to have a repository to pull from or tap the backups...

I noticed a couple folks mentioned Idera SQL Diagnostic Manager, so I will third their posts. We just began to use it so I'm trying to figure out how...

We have just begun to use Idera SQL Diagnostic Manager 5.0. These are new waters I'm navigating, but I like what I see so far. Like trying to...