3 questions

1) Which one of the following is NOT a SQL Server page type?
Index, Table, Data, Text /Image, Global Allocation MAP,
2) Which one of the following is a characteristic of a Keyset-Driven Cursor?
Order is Dynamic. , Values are Dynamic., Membership is Dynamic., Keyset is built in memory, Usage of the tempdb database is reduced.
3) Which one of the following situations benefits LEAST from parallel execution?
1) Extensive aggregation in a large corporate billing application
2) Large groups of small transactions in an OLTP application
3) Multiple joins in a decision support system
4)Large sorts in a data warehouse reporting application
5)Small groups of large queries in an OLAP application
What do you think the answers are?
David G.
|||1) Which one of the following is NOT a SQL Server page type?
Global Allocation MAP
2) Which one of the following is a characteristic of a Keyset-Driven Cursor?
Values are Dynamic
3) Which one of the following situations benefits LEAST from parallel
execution?
Large groups of small transactions in an OLTP application
-- Original Message --
From: "David Gugick" <davidg-nospam@.imceda.com>
Newsgroups: microsoft.public.sqlserver.clients
Sent: Tuesday, March 01, 2005 6:11 PM
Subject: Re: 3 questions

> What do you think the answers are?
> --
> David G.
>
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OatMxPrHFHA.3500@.TK2MSFTNGP14.phx.gbl...
> What do you think the answers are?
> --
> David G.
>
|||John wrote:
> 1) Which one of the following is NOT a SQL Server page type?
> Global Allocation MAP
I think the answer to this one is a table (see Pages and Extents in BOL)

> 2) Which one of the following is a characteristic of a Keyset-Driven
> Cursor?
> Values are Dynamic
I agree with you on this one.

> 3) Which one of the following situations benefits LEAST from parallel
> execution?
> Large groups of small transactions in an OLTP application
I agree with you on this one as well.
David Gugick
Imceda Software
www.imceda.com
sql

3 global variables 3 sql server connections?

Hello!
I've 3 sql server connections in the DTS package. They are:
conn1
conn2
conn3
Using dynamic properties task, I set up three global variables (gv1, gv2
and gv3).
For conn1 - I am getting server value from @.@.servername. (I am running
this pkg under a sql server job). see the pkg execution code:
declare @.dtsrun varchar(300)
set @.dtsrun = 'dtsrun /F d:\DTS\Mydts.dts /N Mydts /Agv1:8=' +
@.@.servername
exec master.dbo.xp_cmdshell @.dtsrun
for conn2 and conn3, I am using ActiveX script inside the DTS pkg to get
the server values (which are stored in a table in the db).
I am getting server values for 'gv2' and 'gv3'. My question is how would
I pass "gv2" value in "conn2" and "gv3" value in "conn3"?
thanks for your help!
*** Sent via Developersdex http://www.examnotes.net ***why don't have such values into global variables? It seems the most reliable
and safe way
--
Current location: Alicante (ES)
"Test Test" wrote:

> Hello!
> I've 3 sql server connections in the DTS package. They are:
> conn1
> conn2
> conn3
> Using dynamic properties task, I set up three global variables (gv1, gv2
> and gv3).
> For conn1 - I am getting server value from @.@.servername. (I am running
> this pkg under a sql server job). see the pkg execution code:
> declare @.dtsrun varchar(300)
> set @.dtsrun = 'dtsrun /F d:\DTS\Mydts.dts /N Mydts /Agv1:8=' +
> @.@.servername
> exec master.dbo.xp_cmdshell @.dtsrun
> for conn2 and conn3, I am using ActiveX script inside the DTS pkg to get
> the server values (which are stored in a table in the db).
> I am getting server values for 'gv2' and 'gv3'. My question is how would
> I pass "gv2" value in "conn2" and "gv3" value in "conn3"?
> thanks for your help!
>
>
>
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
>