When doing a large update of a table in a SQL Server database you may gain some performance by locking at the Table level instead of allowing SQL Server to do Page or Row level locking. This can be accomplished using Table Hints. Table hints override the query optimizer default plan for the executed query. …
This is an error that you get when you try to view the built-in reports in SQL Server 2008 when the database compatibility is set to anything less than 2005(90). To fix this and make the built-in reports work: Right click on the database Select properties On the options tab change the compatibility level to …
In SQL 2000 and before setting auto file growth to a percentage meant that the file would grow by 10% of the initial file size (regardless of how large the file had grown since its creation). In SQL 2005 and later the growth by percentage setting is based on the “current” file size and not …
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
I was just made aware of a new bug (oops I mean undocumented feature) in SQL 2005 that prevents the backup of File Groups that scroll beyond the viewable area of the Backup Dialog box. This is not a problem if you have only a few file groups but if you have enough that you …