I saw a post asking about how to find all the large lists in SharePoint 2007 for migration purposes. Here is a query that will help you find all the large lists in your SP content database. After you find them, you need to determine if they need to be moved to a SQL Server/Oracle/DB2 database and then referenced with BDC (or reference via custom web parts).
select s.fullurl + '/' + w.fullurl + '/' + tp_title as url, tp_itemcount from alllists al, webs w, sites s
where al.tp_webid = w.id
and
w.siteid = s.id
order by tp_itemcount desc
- You can also find some cool queries by Brent v here
- Oh and seems Syed has built quite the comprehensive list of queries too: here
Enjoy!
Chris