<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Vincent Rainardi
»
Data Warehousing Performance
Data Warehousing Performance
Rate Topic
Display Mode
Topic Options
Author
Message
VincentRainardi
VincentRainardi
Posted Tuesday, February 05, 2008 12:07 AM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, January 14, 2013 4:24 AM
Points: 81,
Visits: 188
Comments posted to this topic are about the item
Data Warehousing Performance
Post #451466
EdVassie
EdVassie
Posted Tuesday, February 05, 2008 5:37 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 5:46 AM
Points: 2,636,
Visits: 2,788
The question says 'not usually used to improve ... performance'. Is this a typo?
I would have put the right answer of 'summary tables' on the side of 'usually used'.
Author:
SQL Server FineBuild
1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005.
4 June 2013
: now over 24,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #451570
VincentRainardi
VincentRainardi
Posted Tuesday, February 05, 2008 6:26 AM
SSC Journeyman
Group: General Forum Members
Last Login: Monday, January 14, 2013 4:24 AM
Points: 81,
Visits: 188
Hi Ed,
the word "not" was meant to be there.
3 of the answers are usually used to improve DW performance (summary tables, partitioning and index), whilst 1 is not (backup).
Kind regards,
Vincent
Post #451597
Jeff Deluca
Jeff Deluca
Posted Tuesday, February 05, 2008 6:54 AM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, May 31, 2011 2:32 PM
Points: 491,
Visits: 221
I feel the question could have been worded better. Specifically, I am referring to this sentence:
Which one of the following things that is not usually used to improve data warehouse query performance?
That sentence sounds like it's asking:
Which one of the following would help query performance but is not usually used?
However, that is not what the question is really asking.
I think removal of the word 'that' in the quoted QotD sentence above would help improve readability.
Post #451611
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
