Working with lists in Sharepoint 2007

Hi folks,

i've come over an interesting white paper for querying data from sharepoint lists.
Different access-methods are explained (spquery, search, foreach,...).

Very Interesting is the well-known virtual limit with 2000 items per container (list/folder).
The document stands out, that this is "only" rlevant when viewing data with the default sharepoint ui in the browser.
If you plan to put an alternative ui on top of that, you're fine.

Here the link: http://technet.microsoft.com/en-us/library/cc262813.aspx
(There are also other white papers for capacity planning etc.)

happy querying ...

Cool STSADM Commands

Cool and huge list of stsadm commands:
http://stsadm.blogspot.com/2007/08/stsadm-commands_09.html

Although this list exists a bit longer, thanks to Gary Lapointe for this helpful and huge list (my commands are there in, too :)).

I will soon update my list with a new command for running farm jobs not assigned to a site.