What are the top SharePoint list best practices?

Question

I am looking for specific best practices around naming conventions and cross site list querying (site collection & subsite). I am not finding a lot of resources on these topics and assume this community may have some lessons learned information they can share with me around this area.

Answer 1

There's some guidance in this area provided by Microsoft as part of the SharePoint 2010 application development patterns and practices: Developing Applications for SharePoint 2010. Specifically, the List Patterns section that covers Large Lists and List Aggregation Patterns.

Answer 2

There are a list of articles Performance and capacity test results and recommendations (SharePoint Server 2010). I suppose you are interested in Designing large lists and maximizing list performance (SharePoint Server 2010)