|
Home > Archive > microsoft.public.cert.exams.mcse > May 2003 > Bulk update
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Stacie 2003-05-26, 5:23 pm |
| Again, 2 different study guides have 2 different answers...
(one says you apply the lock - the other doesn't say)??
Qu: You are admin of a new multiprocessor SQL server
2000. You are migrating data from other db management
systems to this server. You need to load data from 2 data
files into a new table on the server. The table is empty
and has no indexes.
Answers:
Use separate client connections to load the files in the
table simultaneously.
Specify the Bulk-logged Recovery model for the db
?????Do you apply the bulk update lock to the table?????
| |
| Gary - US 2003-05-26, 10:23 pm |
| This is getting repetitive. Don't use braindumps and you won't have these
problems.
--
Semper Fi & God Bless America,
Gary - US MCNGP #20
http://www.mcngp.tk
The MCNGP Team - We're here to help
"Stacie" <stacie.cato@peedee.ncemcs.com> wrote in message
news:29a901c323cf$c8fe5760$a40
1280a@phx.gbl...
> Again, 2 different study guides have 2 different answers...
> (one says you apply the lock - the other doesn't say)??
>
> Qu: You are admin of a new multiprocessor SQL server
> 2000. You are migrating data from other db management
> systems to this server. You need to load data from 2 data
> files into a new table on the server. The table is empty
> and has no indexes.
>
> Answers:
> Use separate client connections to load the files in the
> table simultaneously.
> Specify the Bulk-logged Recovery model for the db
> ?????Do you apply the bulk update lock to the table?????
| |
| Don Julio 2003-05-27, 11:23 am |
| This is getting repetitive. Don't use braindumps and you won't have these
problems.
|
|
|
|
|