4 Answers
4

Definitely don't want to go the SQL query route because you can easily create an ineffecient query if you don't understand the underlying data model...also possible that you'll develop a query that breaks or becomes inefficient after a CU or SP is applied.

CAML queries are very efficient and depending on the scope of your query you have a lot of options.

This looks like an excellent solution, I'll look into it first thing tomorrow! Thanks!
–
nfwAug 22 '11 at 23:25

Emphasis on the fact that the above method, as Rob mentioned, can also be done through Powershell. If it's a once off, powershell can be a very low-impact option for what you're after. If you're doing this regularly, then a deployed solution is your best option.
–
Mike ReddenAug 23 '11 at 4:35

For SharePoint 2010, I'd recommend using the Client Object Model. It allows for development without having to resort to installing SharePoint on the developer's PC (or developing ON the SharePoint server).