Browse by Tags

Internal Tables in SQL Server 2005, what are they for?

Published 2 November 7 3:17 AM | SSQA.net

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...

Filed under: sql server, indexes, security, search, xml, permissions, table, full-text, internal tables

Full Text Search is installed, but not enabled to see at table-level

Published 26 July 7 4:38 AM | SSQA.net

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...

Filed under: sql server, ssms, database, sql express, full-text, enterprise manager

SQL Server 2005 Best Practices Analyzer (July 2007) - out from CTP

Published 10 July 7 4:18 AM | SSQA.net

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...

Filed under: sql server, backup, best practices, ctp, analyzer, full-text