marc.w.atkinson (12/11/2009)

---

Ok, I am posting my solution here because this is the first forum I looked at when I started looking.

As it turns out you cannot reuse recordsets stuffed into...

Passed it this morning, thought it was a pretty tough exam. I'm very happy though, 2 more exams to go for my MCSA 🙂

I'm studying for this also, taking the exam next Friday. I'm using the Skills Measured list and the page from Emil (thanks for sharing!). So mostly reading up on BOL.

The easiest would be to use the Import and Export Wizard. How to use this is described in the following article: http://msdn.microsoft.com/en-us/library/ms140052.aspx

I appreciate your help, but I'm not after statistics for query optimization.

My question is about the value in user_updates column in DMV sys.dm_db_index_usage_stats, it doesn't seem to be updated...

Thanks for your reply, however that doesn't say anything about statistics not being updated after BULK INSERTs.

About this view sys.dm_db_index_usage_stats, BOL states: "Returns counts of different types of index operations...