The form submission cannot be processed because it exceeded the maximum length allowed by the Web administrator. Please resubmit the form with less data.

Step 1: Go to Central Administration - Application Management - Web Application - General Settings and change the Maximum Upload size.
Step 2: If step 1 does not resolve, ensure that you changed the maxRequestLength in the correct web.config. Double-check in IIS for the right virtual directory and the configuration file.
Step 3: Note that the MaxRequestLength is in KB. Do your calculations accordingly.
Step 4: There could more than one web.config files and it could be overridden. Check the appropriate one.
Step 5: refer this KB article.

1. SharePoint Joel's: 10 Tips Troubleshooting Installations for SharePoint 2010 and SharePoint Foundation
   Doc File:10 Tips Troubleshooting Installations for SharePoint 2010 and SharePoint Foundation.doc (37.50 kb)
   XPS File:10 Tips Troubleshooting Installations for SharePoint 2010 and SharePoint Foundation.xps (213.01 kb)

    

2. CJG: SharePoint 2010 - Step by Step Install
   XPS File:SharePoint 2010 - Step by Step Install.xps (290.14 kb)

    

3. Installation Notice for SharePoint 2010 Public Beta
   Doc File:Installation Notice for SharePoint 2010 Public Beta.doc (39.50 kb)
   XPS File:Installation Notice for SharePoint 2010 Public Beta.xps (276.22 kb)

    

4. Microsoft (MSDN) for Win 7: Setting Up the Development Environment for SharePoint Server (Win 7 high level)
   PDF File:Setting Up the Development Environment for SharePoint Server.pdf (342.88 kb)

    

5. Faizal: Step by Step SharePoint 2010 Installation Guide (Standalone on VMware Workstation)
   PDF File:Faizal’s Step by step SharePoint Server 2010 Installation guide.pdf (1.23 mb)

    

6. CodeProject: Step by Step SharePoint Server 2010 Installation … (Standalone on VMware Workstation, good links to prerequisites)

    

7. Install SharePoint 2010 on Windows 2008
   PDF File:Install SharePoint 2010 on Windows 2008.pdf (179.90 kb)

Welcome to the Microsoft SharePoint Server 2010 Beta Resource Center

1. SharePoint Central Administration: High Availability, Load Balancing, Security & General Recommendations
   XPS File: SharePoint Central Administration - High Availability, Load Balancing, Security & General Recommendations.xps (823.79 kb)
2. Scripted provisioning of multiple Central Admin web applications
   XPS File: Scripted provisioning of multiple Central Admin web applications.xps (237.35 kb)

Week : 7 (Sunday 07/02/2010 - Saturday 13/02/2010)
=CONCATENATE(INT(([Task Date]-DATE(YEAR([Task Date]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Task Date]),1,1)),"d")))/7)+1, " (", TEXT([Task Date]-WEEKDAY([Task Date])+1,"dddd"), " ", TEXT([Task Date]-WEEKDAY([Task Date])+1,"dd/mm/yyyy"), " - " , TEXT([Task Date]+7-WEEKDAY([Task Date]),"dddd"), " " , TEXT([Task Date]+7-WEEKDAY([Task Date]),"dd/mm/yyyy"), ")")

Week : 7
=INT(([Task Date]-DATE(YEAR([Task Date]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Task Date]),1,1)),"d")))/7)+1

Week : Sunday 07/02/2010
=TEXT([Task Date]-WEEKDAY([Task Date])+1,"dddd"), " ", TEXT([Task Date]-WEEKDAY([Task Date])+1,"dd/mm/yyyy")

Week : Saturday 13/02/2010
=TEXT([Task Date]+7-WEEKDAY([Task Date]),"dddd"), " ", TEXT([Task Date]+7-WEEKDAY([Task Date]),"dd/mm/yyyy")

*************************************************************************
Common Date Time formulas for Sharepoint – Calculated Fields

Get Week of the year
=DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))+0.5-WEEKDAY(DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])),2)+1

First day of the week for a given date:
=[Start Date]-WEEKDAY([Start Date])+1

Last day of the week for a given date:
=[End Date]+7-WEEKDAY([End Date])

First day of the month for a given date:
=DATEVALUE(“1/”&MONTH([Start Date])&”/”&YEAR([Start Date]))

Last day of the month for a given year (does not handle Feb 29). Result is in date format:
=DATEVALUE (CHOOSE(MONTH([End Date]),31,28,31,30,31,30,31,31,30,31,30,31) &”/” & MONTH([End Date])&”/”&YEAR([End Date]))

Day Name of the week : e.g Monday, Mon
=TEXT(WEEKDAY([Start Date]), “dddd”)
=TEXT(WEEKDAY([Start Date]), “ddd”)

The name of the month for a given date – numbered for sorting – e.g. 01. January:
=CHOOSE(MONTH([Date Created]),”01. January”, “02. February”, “03. March”, “04. April”, “05. May” , “06. June” , “07. July” , “08. August” , “09. September” , “10. October” , “11. November” , “12. December”)

Get Hours difference between two Date-Time :
=IF(NOT(ISBLANK([End Time])),([End Time]-[Start Time])*24,0)

Date Difference in days – Hours – Min format : e.g 4days 5hours 10min :
=YEAR(Today)-YEAR(Created)-IF(OR(MONTH(Today)<MONTH(Created),AND(MONTH(Today)=MONTH(Created), DAY(Today)<DAY(Created))),1,0)&” years, “&MONTH(Today)-MONTH(Created)+IF(AND(MONTH(Today)<=MONTH(Created),DAY(Today)<DAY(Created)),11,IF(AND(MONTH(Today)<MONTH(Created),DAY(Today)>=DAY(Created)),12,IF(AND(MONTH(Today)>MONTH(Created),DAY(Today)<DAY(Created)),-1)))&” months,“&Today-DATE(YEAR(Today),MONTH(Today)-IF(DAY(Today)<DAY(Created),1,0),DAY(Created))&” days”
OR
=IF(HOUR([Ending Date])>HOUR([Starting Date]),DATEDIF([Starting Date],[Ending Date],”d”)&” days “&HOUR([Ending Date]-[Starting Date])&” hours “,(DATEDIF([Starting Date],[Ending Date],”d”)-1)&” days “& HOUR([Ending Date]-[Starting Date])&” hours “)&MINUTE([Ending Date]-[Starting Date])&” minutes”

You can get Get more formulas from
http://office.microsoft.com/en-us/sharepointtechnology/HA011609471033.aspx

Reference

Taming the Elusive “Calculated Column” – Text and Data (Part V)

Tab control using MultiView and View in asp.net C#

Source : Tab control.aspx (2.38 kb)

To Access Run Command.csv (7.51 kb)

thanks Ben for the funtastic article

Reading querry stringparameter to an array in javascript

Ask-Ben-Getting-Query-String-Values-In-JavaScript-695-1.txt (2.27 kb)

The JavaScript function for String Replace replaces the first occurrence in the string. The function is similar to the php function str_replace and takes two simple parameters. The first parameter is the pattern to find and the second parameter is the string to replace the pattern with when found. The javascript function does not Replace All...
str = str.replace(”find”,”replace”)

To ReplaceAll you have to do it a little differently. To replace all occurrences in the string, use the g modifier like this:
str = str.replace(/find/g,”replace”)

SharePoint 2007

Links

• http://www.jpy-tech.com/blog/archive.aspx#MOSS
• SharePoint 2007 Link List
•  

Files

• Office SharePoint Server 2007 Training Install Guide.docx (1.20 mb)
• SharePoint Interview questions.pdf (657.20 kb)

How to Delete SQL Server Database Duplicate Rows from a Table Using a Specified Column List and No Temp Tables

SELECT COUNT(*),
	Column1,
	Column2,
	.
	.
	Columnn
FROM TestTable
GROUP BY 
	Column1,
	Column2,
	.
	.
	Columnn
HAVING COUNT(*) > 1

--find duplicate emails in a 'users' table:
SELECT id, email, count(email) FROM users GROUP BY email HAVING count(email) > 1

--Another approach is to list all the duplicate entries. We assume the field 'id' is the primary key of the table 'users'
SELECT DISTINCT t1.id, t1.email FROM users t1, users t2 WHERE t1.email = t2.email AND t1.id <> t2.id


/*
How to find duplicates in multiple columns
I have a table with columns b and c that links two other tables b and c, and I want to find all rows that have duplicates in either b or c.
*/

create table a_b_c(
   a int not null primary key auto_increment,
   b int,
   c int
);

insert into a_b_c(b,c) values (1, 1);
insert into a_b_c(b,c) values (1, 2);
insert into a_b_c(b,c) values (1, 3);
insert into a_b_c(b,c) values (2, 1);
insert into a_b_c(b,c) values (2, 2);
insert into a_b_c(b,c) values (2, 3);
insert into a_b_c(b,c) values (3, 1);
insert into a_b_c(b,c) values (3, 2);
insert into a_b_c(b,c) values (3, 3);

select b, c, count(*) 
from a_b_c
group by b, c
having 
	count(distinct b) > 1
	or count(distinct c) > 1;