Viewing 6 posts - 1 through 6 (of 6 total)
marc.w.atkinson (12/11/2009)
As it turns out you cannot reuse recordsets stuffed into...
/*----------------------------------------------------------------------------------*/
Always eager to learn.
January 6, 2013 at 11:38 am
Passed it this morning, thought it was a pretty tough exam. I'm very happy though, 2 more exams to go for my MCSA 🙂
/*----------------------------------------------------------------------------------*/
Always eager to learn.
October 5, 2012 at 6:54 am
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.
/*----------------------------------------------------------------------------------*/
Always eager to learn.
September 29, 2012 at 10:50 am
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
/*----------------------------------------------------------------------------------*/
Always eager to learn.
September 26, 2012 at 8:05 am
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...
/*----------------------------------------------------------------------------------*/
Always eager to learn.
September 26, 2012 at 7:47 am
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...
/*----------------------------------------------------------------------------------*/
Always eager to learn.
September 26, 2012 at 7:27 am
Viewing 6 posts - 1 through 6 (of 6 total)