Migrate data from Source to Destination Library without changing the audit trail column values– PowerShell

```powershell Add-PSSnapin “Microsoft.SharePoint.Powershell” -ErrorAction SilentlyContinue $sourceWebURL = “http://srcurl” $sourceListName = “Source” $destinationWebURL = “http://desurl” $destinationListName = “Destination” $spSourceWeb = Get-SPWeb $sourceWebURL $spDestinationWeb = Get-SPWeb $destinationWebURL $spSourceList = $spSourceWeb.Lists[$sourceListName] $spDestinationList = $spDestinationWeb.Lists[$destinationListName] $RootFolder = $spDestinationList.RootFolder $spSourceItems = $spSourceList.Items

Manage SharePoint incremental crawl index deletion

In SharePoint 2013, we have a content source that connects via BCS. The total items in the External table are around 7.7 million records. We have a full crawl scheduled to crawl the BCS items every month and an incremental...

SharePoint Search Suggestions

When we start typing the keywords in the SharePoint search box control it internally performs an AJAX call to /_vti_bin/client.svc/ProcessQuery and that calls the stored procedure proc_MSS_GetQuerySuggestions. The proc_MSS_GetQuerySuggestions stored procedure gets the suggestions from the MSSQLogSearchCounts table. This table...