Viewing 5 posts - 1 through 5 (of 5 total)
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...
February 19, 2014 at 5:30 am
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...
February 18, 2014 at 1:30 am
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...
July 3, 2010 at 12:01 am
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...
August 21, 2009 at 5:13 am
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...
July 27, 2009 at 4:46 am