sys.dm_db_index_physical_stats incorrect value

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sys.dm_db_index_physical_stats incorrect value

Author

Topic

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2013-10-15 : 09:31:15

I have added a clustered index to a table but when I run
sys.dm_db_index_physical_stats it is still showing as being a heap.

I can see in management studio that the clustered index is there.

Does anyone know why this would be?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources