1) Which one of the following is NOT a SQL Server page type?=20

Index, Table, Data, Text /Image, Global Allocation MAP,

2) Which one of the following is a characteristic of a Keyset-Driven =
Cursor?=20

Order is Dynamic. , Values are Dynamic., Membership is Dynamic., =
Keyset is built in memory, Usage of the tempdb database is reduced.=20

3) Which one of the following situations benefits LEAST from parallel =
execution? =20

1) Extensive aggregation in a large corporate billing application =20
2) Large groups of small transactions in an OLTP application =20
3) Multiple joins in a decision support system =20
4)Large sorts in a data warehouse reporting application =20

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


[quoted text, click to view]

[quoted text, click to view]

I think the answer to this one is a table (see Pages and Extents in BOL)

[quoted text, click to view]

I agree with you on this one.

[quoted text, click to view]

I agree with you on this one as well.


--
David Gugick
Imceda Software
www.imceda.com