I'm writing a tool to bulk import log files (application activity logs). I've normalized my tables, but I can't figure out how BULK INSERT, OPENROWSET can work with normalized tables. For instance ...

Question, if I'm truncating tables I need to take care of any foreign key constraints before doing so. Is it better to Drop, Truncate and Add back the Foreign Key or Disable it through some ...