Working with large lists in Office SharePoint Server 2007

A Sharepoint single list should not have more than 2,000 items per list container. A container in this case means the root of the list, as well as any folders in the list — a folder is a container because other list items are stored within it. Maximum number of items supported in a list with recursive folders is 5 million items….(Content Source: http://technet.microsoft.com)

Here is  a white paper provided by  Microsoft. worth reading….Read/Download:Working with large lists in Office SharePoint Server 2007(White Paper)

Limit sharepoint announcement text character

To alter the character limit of an Announcements List, there is an attribute that must be set through SharePoint Designer on the page that contains the web part. Perform a search for the string “Limit Len=” on the page in question and alter the value to reflect the character limit you would like.The default character limit attribute is set to 250 characters.