Showing posts from March, 2010

Total Count of Items in a List in Sharepoint

I had a recent assignment to test the performance of a List. The list was behaving really slow and I need to determine the total number of items in the list.
Aaaah ………… there starts the problem. I wanted the total number of items in the list and I could only do that by navigating through the List Item pages which was around 20,000 + Items, So need to click through every single pages and it would take couple of months to figure out the exact numbers. Then I thought about the "Calculated Columns" in Sharepoint.
Finally I figured out to get the total count of the Items in a Sharepoint List. Here are the steps -

Step 1.Create a "Calculated (calculation based on other columns) " column in the List
Step 2.Column Name - "Total"
The Type of Information in this column - "Calculated"
In the Formula Column put - "=SUM(ID)" (without apostrophise)
Select "The data type returned from this formula is: " as Number
Step 3.Select "OK" -…

Sharepoint Service Pack 2 Release

Sharepoint 2007 Service Pack 2 Release(MOSS SP2)I got a new task assigned to upgrade my MOSS Farm from SP1 to SP2.
Here are the steps which I done
Step 1
Installed Service Pack 2 for Windows SharePoint Services 3.0, x86 & x64 2
Installed Service Pack 2 for Office SharePoint Server 2007, x86 & x64
Once after the upgrade checkpoints -
Check 1
Go to the Control Panel>Add remove programs > Select "Microsoft Office Sharepoint Server 2007" > Click here for Support Information. This would be updated to 12.0.6425.1000

Check 2
Go to Central Admin > Operations > Servers In Farm > The Version would be upgrade to from

Possible Errors
Strangely I was getting the below error while installing "Service Pack 2 for Office SharePoint Server 2007" Installer -

The err…

Creating SharePoint 2007 Timer Jobs

I was searching for some articles on how to Create Sharepoint 2007 Timer Jobs - and i found some nice ones, Andrew is describing it very well on his articles - Check out.