How to grab the dependent objects and check if we have the below mentioned partition keys are used

• kbhanu15

  SSCarpal Tunnel

  Points: 4493

  More actions

  February 16, 2015 at 2:53 am

  #294692

  Hi All,

  can you please help on this below task ?

  How to grab the dependent objects and check if we have the below mentioned partition keys are used

  TABLE Partition Column

  PriceEquity_tbl pricingDate

  PriceRSI_tbl pricingDate

  PriceVolatility_tbl pricingDate

  Price52WeekChain_tbl startDate

  Currency_HistoricalConversionFactor_tblconversionDate

  PriceIndex_tbl pricingDate

• MadAdmin

  SSChampion

  Points: 11261

  More actions

  April 17, 2015 at 8:27 am

  #1791702

  To see how they are linked, go here.

  <Download SQL Server 2008 System Views Map from Official Microsoft Download Center>

  http://www.microsoft.com/en-us/download/details.aspx?id=9301

  Catch-all queries done right [/url]
  Gail Shaw's Performance Blog[/url]