Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Read more

0 comments, 356 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

Read more

0 comments, 132 reads

Posted in Vinay Thakur on 3 June 2010