|
|
Browse by Tags
All Tags » security » table (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 any user related data and schema for these tabls are always fixed. You will not be ...
-
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 Server.
It is always better to be proactive than reactive, when it comes to identifying and ...
-
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: 5LEAF level scan performed.- Pages Scanned................................: 86- Extents ...
-
|
|
|