Monthly Archives: June 2010

Important: System Objects/Views/DMV/DMF

Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored on catalog views which look like Sys.xxx Eg. Sys.databases Compatibile views: This are views to manage old compatibility Select * … Continue reading

Posted in DMV, General, Index, Memory, Performance Tuning | Tagged , | Leave a comment

List of indexes and Parallel queries

Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing this.  WITH cte  AS  (  SELECT object_name(ic.object_id) as object_name , index_name = i.name, ‘column’ = c.name,         ‘column usage’ = … Continue reading

Posted in Index, Performance Tuning, Personal, What I learned today | Tagged | Leave a comment