SQLTeam.com | Weblogs | Forums

Missing indexes

i run next query
select d.database_id, d.object_id, d.index_handle, d.equality_columns, d.inequality_columns, d.included_columns, d.statement as fully_qualified_object,
gs.*
from sys.dm_db_missing_index_groups g
join sys.dm_db_missing_index_group_stats gs on gs.group_handle = g.index_group_handle
join
(select * from sys.dm_db_missing_index_details where database_id=15)
d on g.index_handle = d.index_handle

i have some problem with unsed db, when i try to run query i get error :
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x000000002cc000 in file 'R:\Databases\Test1.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.