Very inspiring article, having recently read Brad McGeehee's "How to Become an Exceptional DBA" (looking forward to the second edition) this article came up at exactly the right time for...

I'm currently working my way through this book as we are in the process of building a data warehouse here. So far I have found the book very readable, it's...

I whole heartedly agree with Jason. It is a very inspirational book full of some thought provoking stuff, I had never really thought about writing classes for example, so this...

Good choice of article.

I was lucky enough to attend Brad's Optimization of maintenance plans session at SQLBits IV last month, he seems a really nice guy.

If you have not...

Gail,

Would you mind posting the URL please?

Many thanks,

Rich

You can shrink your files without losing any data.

Please be careful that you are only releasing space that you know you are not going to need again in the near...

Does the login you are executing the statement as have rights to execute that sp on the remote server?

have you tried going on to the other server and executing it...

If you are using BO, then you could create a simple report in either Web Intelligence or Desktop intelligence using this field. Then look at the sql it suggests without...

Hi Eric,

Thanks for your reply. I have actually soved the problem by just doing an update statement in an execute sql task. However I don't believe this is the optimal...

Hi,

Thanks for your replies everyone, they've been most helpful.

Yes my employers are based in England, I mentioned the 11hr rest rule but I was told that it was only...