SQL Server Bulk Updates and Locking
When doing a large update of a table in a SQL Server database you may gain some performance by locking …
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
This is an error that you get when you try to view the built-in reports in SQL Server 2008 when …
Auto File Growth by Percentage of file size
In SQL 2000 and before setting auto file growth to a percentage meant that the file would grow by 10% …
Fix for SharePoint Search error: The search service is currently offline
psconfig -cmd upgrade -inplace b2b -wait Fix is in the comments by “maxmorgan” on the link below http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2009/02/24/the-search-service-is-currently-offline-visit-the-services-on-server-page-in-sharepoint-central-administration-to-verify-whether-the-service-is-enabled-this-might-also-be-because-an-indexer-move-is-in-progress.aspx
SQL Server 2005 Bug
I was just made aware of a new bug (oops I mean undocumented feature) in SQL 2005 that prevents the …