Browse by Tags
All Tags »
full-text (RSS)
By default SQL Server automatically creates the internal tables for Full-text search, XML indexes and Service broker. These are also created when a user query is written poorly that uses tempdb heavily. At they are called internal tables but do not contain
Read More...
There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may
Read More...
It was long time ago I have used FULL-TEXT within our environment, recently I have been given a task to manage a full text SQL instance. Well to refresh my tasks I have installed Full Text Search component on Windows 2003 Server for SQL server 2000 instance.
Read More...
As I have blogged previously that SQL2005BPA is out from CTP now. The BPA for SQL 2005 release in July 2007 is complete package that gathers data from Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations
Read More...
Recently when I was out for Customer call this was the question raised by the DBA, incidentally Microsoft has released a KBA http://go.microsoft.com/?linkid=6109703 that explains the cause and solution.
Read More...