Hi Sean

Unfortunately it is a system I have inherited and the table holds 6.8 million rows there is another column that flags if the second column is a child ID...

Hi

Many thanks for the reply, one thing i did not demonstrate in my sample (sorry, me being stupid) is that the parent or child could appear in either column, which...

Thanks PaulB

I guess what i am trying to say in the first question is can the facts from one table be used in the fact table and have a dimension...

Recently i was having to reindex nightly on certain tables, i changed the fill factor from 100 to 90 and now i get a couple of days before i need...

I have done a similar thing with SSIS, you just need to add the new monitored instance into a table in your repository and ensure the account running the package...