Hi DHeath

If you manage 20+ servers, you might want to look into Powershell. I manage 100 of the blighters, and powershell has made my life a lot easier!

Check out this...

Thanks Daniel, I'll check it out

Hi

This should get you started:

http://msdn.microsoft.com/en-us/library/aa337562%28v=SQL.90%29.aspx

(Edited link to point to SQL2005 specific page)

No, it's not a good idea at all - and also rather pointless in this case, as all it will do is grow again

See here for a detailed explanation as...

EdA

You could either use T-SQL or SSIS for this (ie, a T-SQL type jobstep, or an Integration Services type job step.)

T-SQL would be something like:

insert into ERPPLUSDB.dbo.NCMROrders

select col1, col2, ...,...

s/he's dissed another poster's spelling now. In the words of the people from Teh Interwebz: "wat?"

I highly recommend looking through some of the videos on the SQLBits website http://www.sqlbits.com

SQLBits is probably the largest SQL Server conference in Europe. After the conference, videos of...

Thanks Martin!

That's what we do when patching our production cluster

I used the method described in this blog post to identify what was causing my tempdb to grow:

http://strictlysql.blogspot.com/2010/03/whats-causing-my-tempdb-to-grow-sql_17.html

Basically you query a couple of the DMVs every 2-3 minutes...

I recommend you have a good read of this article by Paul Randal, to get a better idea of what happens under the hood during restores

Now you've done it, I now have a craving...

The Saddest Sound, by The Devastations

I wish it would go away - lovely song but very depressing!

Jeff Moden (1/10/2011)

Did you also...

True. Trust me to worry about decimals and miss the obvious 🙂