Find Large Lists for SP2 and SP2010 Migration

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