Tag Archives: SQL

Shrink CrawlStore Database

Posted on January 29, 2015 by Stu

A useful script for running on your dev\uat environments to free valuable disk space. The crawl store database can grow quite significantly over time. First of all, the PowerShell script: # Load the SharePoint assembly – change the version to … Continue reading →

Posted in SharePoint, SQL | Tagged , , | Leave a comment

Configuring SQL Server Whitepaper

Posted on July 23, 2014 by Stu

I recently came across the following whitepaper for configuring SQL Server to get the best performance from it when used in a SharePoint environment. Download it from here Or view it from here Lots of good information in it and … Continue reading →

Posted in SharePoint, SQL | Tagged , , | Leave a comment

Creating Entities from Dynamic SQL

Posted on January 31, 2014 by Stu

When working with a LINQ to SQL model (dbml) and you try to add a custom stored procedure that uses dynamic SQL, you will likely see an error similar to the following: The return type for the following stored procedure … Continue reading →

Posted in SQL, Visual Studio | Tagged , | Leave a comment

Move SharePoint Database

Posted on September 2, 2011 by Stu

Before attempting to move the databases associated with your SharePoint instance, make sure you backup your farm before continuing. For example, the following PowerShell script performs a full backup of the farm: Backup-SPFarm -Directory c:\backuppath -BackupMethod Full Depending on the … Continue reading →

Posted in SharePoint | Tagged , , | 3 Comments