how to update users email if there is no interface in UI

Dont go to database. instead use the power shell to do same

Add-PSSnapin Microsoft.SharePoint.PowerShell
$site = Get-SPSite http://example.com
$web = $site.RootWeb
$user = $web.SiteUsers.GetByEmail("usr@example.com")
$user.Email = "user@example.com"
$user.Update()

sharepoint 2010 sesion state

1. Enter the following PowerShell command in the SharePoint 2010 Management Shell window:

Enable-SPSessionStateService –DefaultProvision

1. On each web application for which you want to use session state, edit the web.config file and set the enableSessionState property of the pages element as follows:

How to overwrite documents that require check out?

you have to fist check out file

foreach ($file in $files) {
    $file.CheckOut()
    $stream = $file.OpenRead()
    $done = $list.RootFolder.SubFolders["Hertel"].Files.Add($file.Name, $stream, $true)
    Write-Host $done.Name "Uploaded" -BackgroundColor Green
}

Click to Copy List Item to New in same list

Manually can be done by editing in datasheet
 designer work flow also works http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=107

Will exceeding 2000 documents in a SharePoint 2007 Library folder degrade only the performance of that library?

2000 is the view threshold. Index can be added

Can we use XOR in a calculated column in SharePoint 2007

 IF, AND, OR and NOT  are supported. XOR is not supported.

how to find out name of list who have particular custom column

iterate through all sites and list

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
$spSite = New-Object Microsoft.SharePoint.SPSite("http://url")
$webApp = $spSite.WebApplication
foreach ($site in $webApp.Sites) {
    foreach ($web in $site.AllWebs) {
        foreach ($list in $web.lists) {
            if ($list.fields["Custom Field name"]) {
                "List has custom field" | Out-File C:\filePath\log.txt -append
            }
        }
    }
}

validating only a part of a web Page

This can be implemented by using validation groups.

Enterprise Level Deployment: Features and solutions

Ted Pattison says "packaging and deploying your WSS development efforts using solution packages is a best practice, and knowing how to do this should be considered an essential skill." 

There are numerous ways to package   SharePoint solutions, from manual creation of manifest.xml and diamond directive files (DDFs), to Visual Studio projects that use the Windows SharePoint Services 3.0 Tools: Visual Studio 2005/2008 Extensions (VSeWSS).

LIst of custom log viewer

• SPLogViewer - supports loading and filtering one file, does not follow/tail log displays data in a DataGrid.
• SharePoint Log Viewer  
• Stonebond SharePoint Log Viewer  
• ULS Deobfuscator - 
• SharePoint ULS Log Parser - one click access to log files, supports filtering by Process Name, Level, Area and Category.
• Log Viewer Feature - access from Central Administration, select individual log basic filtering on category, event and trace severity, output as HTML in Central Administration.
• WSS / MOSS Log File Reader - Access to individual log files from Central Administration, standard DataGrid filtering and sorting options.
• Stefan Gordon's ULS Viewer - Open individual log, does not follow/tail log, displays data in ListView detail. Filter by secerity, process category and free form text.
• SQL Integration Services - All reporting, sorting and filtering options provided by MSSQL (Blog Post with ETL Package Download), time consuming to setup.
• LogParser - Familiar interface to IIS Administrators, pleanty of options. Setup takes too long for small installations.