Tagged Questions
2
votes
1answer
180 views
In SQL Server 2008, in DMV sys.dm_db_index_phsicial_stats, what does compressed_page_count mean in comparision with page_count
In SQL Server 2008, DMV sys.dm_db_index_physical_stats, what does compressed_page_count mean in comparison with page_count. I have a table with the following info:
Object_id Index_type_desc ...
3
votes
2answers
858 views
sys.database_files / sys.filegroups VS sys.sysfiles / sys.sysfilegroups
These catalog views seem to show the exact same data. What is the point of having multiple system views that seem to show the same thing?
Here is how I proved it is the same data:
select
...
4
votes
2answers
162 views
How do I track the usage of XML indexes?
My XML indexes are not listed in sys.dm_db_index_usage_stats
Does this mean they aren't being used? Or does this particular DMV not track XML index usage? (Books Online doesn't appear to answer the ...
