• Golfer22 (12/25/2012)


    Even though the resource database is read-only, it is updated by SQL Server, right?

    Yes

    Golfer22 (12/25/2012)


    Does sys.dm_db_missing_index_details have information that results in "missing indexes" from ad hoc queries that have been ran once?

    Yes

    Golfer22 (12/25/2012)


    sys.dm_db_missing_index_details resides in the resource database, right?

    Yes

    Here is link http://sqlblog.com/blogs/kalen_delaney/archive/2007/09/13/geek-city-the-resource-database.aspx

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)