Subscribe to this blog
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
0 comments, 173 reads
Posted in Vinay Thakur on 17 June 2010
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
0 comments, 62 reads
Posted in Vinay Thakur on 3 June 2010