Working with Large Lists in Sharepoint

So when we decided to move to Sharepoint 2010 every one was excited and so were the uses because as per the readings we can make larger lists (then what we already have) yes its never enough :) 

As they say SharePoint Lists supports Items upto 50 million  - During read operations. 

However the challenge has always been to make the data in the large list available for retrieval and display in timely and efficient manner.
Although the users can create as many items as they want the query operation shows down as the list grows in size. 

So what do poor administrators like you and me do ... 

Introducing our life saver : Resource Throttling

Resource Throttling is new with SharePoint 2010 and is set on site collections by default standard users are throttled when retrieving 5000 items from the list with a warning of 3000, these warnings can be changed using PowerShell.

the mechanics works like this:
if a user is pulling data with 4999 items the query runs all the data without any error.
however if the user or query tries to retrieve 5001 items an expensive query will be returned. 

so what we can do is we can use Central Admin to set a time frame when these expensive queries cannot be run for example a query cannot be run at some time frame like 9 to 6 and then later these query would yeild results. 

this can be done from Central admin>Application Management > Manage web application > select your application> General settings > Resource Throttling. 


hope this would help :) 

Create your SharePoint 2010 themes easy

Branding the site is something each organization is looking for and  even if I had my own personal site which I use to share stuff I would love it brand it ... throw in some colors add icons and images. 

So If you wanna quick brand your SharePoint website you can do so from the Inbuilt themes from:

Using the Interface:

1. Open SP site
2. Go to site actions > site settings 
3. under look and feel choose site theme
4. click select a color to change the color of a specific item.
5. choose theme from the list
6. click preview to view the site changes before publishing 
7. click apply

well wasn't that easy but if you want to make your own themes rather then the well defined ones before jumping into CSS  consider this option. 

Creating Themes with PowerPoint 2010

1. Open PowerPoint 
2. Create a new document but if you have an existing document that your organization uses then skip step 3.
3. Change the theme, you can do this also from the design tab of powerpoint choose the theme that defines your style, choose fonts and hyperlinks so on. 
4. Choose the color pallette for the site by clicking the Colors. 
5. Save the PowerPoint Document as MS powerpoint theme which is *.thmx
6. Now go back to your sharepoint site> upload this file under Galleries and Themes. 
7.  Keep / as destination. 
8. Then choose this new theme for your site from the about way. 

tadaaaa .. you have your custom theme for Sharepoint and did we even touch Designer or CSS ...no sir :)