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.
Author |
Topic |
szewczykm
Starting Member
1 Post |
Posted - 2013-11-05 : 14:11:07
|
I'm looking at the output that I'm getting from sys.dm_db_index_physical_stats and I've added a where clause to show me only indexes that are fragmented more than 50%.The odd thing is, I'm being returned table names and indexes that don't seem to exist. I look at the database ID and go to that DB and I don't find that table. Am I looking at this wrong?The index type is a Clustered Index. The table name looks like it fits in the purpose of the database, but looking at the database it's not there.Thanks!Mike |
|
|
|
|