SharePoint Secrets

Great news about increased storage capacities for SharePoint 2010: Max recommended SharePoint 2010 content database size is 200 GB! This is double that of MOSS 2007, and for specific workloads—large, single-site repositories and archives with non-collaborative IO and usage patterns such as Records Centers—content databases up to 1 TB are supported. The specific guidance is given in SharePoint Server 2010 Capacity Management: Software Boundaries and Limits: “We strongly recommended limiting the size of content databases to 200 GB to help ensure system performance. “Content database sizes up to 1 terabyte are supported only for large, single-site repositories and archives with non-collaborative I/O and usage patterns, such as Records Centers. Larger database sizes are supported for these scenarios because their I/O patterns and typical data structure formats have been designed for, and tested at, larger scales. “A site collection should not exceed 100 GB unless it is the only site colle

To Fix this problem Hotfix available : http://support.microsoft.com/kb/896861

We all know the power of SharePoint Designer. When there is any requirement in which we need to send a mail when item is added to list or document library along with its metadata column values and with some formatting. However I observed one simple limitation of designer workflow. We can add field values in the body part when we want to send an email from designer workflow. However when it comes to the subject line, we cannot add some static text and field value together. It can be wither entirely static subject line or it can be entirely a field values. So how should we overcome this difficulty? Well, the idea is have one calculated field and define its value with “static text” & [field value] and when sending mail from designer, mention this calculated field in subject line. You are ready to send a customized subject line.

We all know there is a way we can synchronize SharePoint calendar with outlook and then work from outlook or from SharePoint and changes get synchronized automatically. However, if you already have outlook calendar and want to sync the calendar with SharePoint calendar, then follow this approach. Following is the approach for outlook 2007. 1) Create one calendar in SharePoint site and connect it with outlook. 2) Open your source outlook calendar, click on that calendar. 3) Open view menu – >Current View-> All appointments. 4) Hit Ctrl+A button to select all appointments. 5) Simple drag all appointments to the respective destination calendar in outlook. (Destination calendar will be the one that we synchronized in step2) Just make sure that person who is synchronizing the calendar should have appropriate permission to write in the calendar.