book2 had a rating less than 3 so wasn't selected 😉

Typos aside I also liked the article 😀

And I would be interested in a follow-up discussing INNER JOIN vs OUTER JOIN vs LEFT JOIN vs RIGHT JOIN, with a similar...

I agree - the question should have said click all that apply and then we might have thought "I wonder if there is more than the obvious answer from BOL".

Hi Carla, I think you've summed it up perfectly 🙂

As someone relatively new to the World of the SQL DBA, I'd be only too glad to hear what third party products others are using to help monitor their servers...

I think it's worth stating that this was worth the wait?!

And don't forget that SQL Server 2008 has the benefit of http://www.sqlservercentral.com for any tricky questions you might get 😀

Hi there,

I am having a similar problem with a log file, where the database is log shipped. Therefore, I'm pretty certain that the reason I can't shrinkl the log is...

That's what I like about QotD - the simplest questions are often the most thought provoking!

This definitely proves you should be careful what identifier names you choose.

Jack Corbett (5/18/2009)

---

In addition to what Jonathan is recommending you should also check your anti-virus setting (if you have AV on your SQL Server). By default McAfee blocks Database...

Just what I was looking for - most useful.

Thanks

For me, the best thing about this post was the mention of the stored procedure sp_Msforeachdb, which I've not heard of before - it's a very useful tool and I...

I just wanted to say I was glad this was posted, even if not the perfect solution, as the debate has flagged up something I wasn't sure of: namely "by...

I think the idea of questions like these is to try and answer them WITHOUT running the code i.e. to check your understanding of what the code will do ;-)...

Thanks for this quesion, as I has never heard of / noticed the Resource database before, so I now know to include backing it up as part of any major...