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

Performance - check whether it is affecting application or system, don't blame SQL Server alone

Published 3 September 7 9:42 AM | SSQA.net

Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL...

Filed under: application, sql server, performance, blocking, security, query, table, wait, queue, high cpu, oltp

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value

Published 24 August 7 6:24 AM | SSQA.net

This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level...

Filed under: sql server, performance, security, dbcc, index, table, fragmentation, showcontig, defrag