<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 peter.skoglund
»
SELECT TOP
51 posts, Page 1 of 6
1
2
3
4
5
»
»»
SELECT TOP
Rate Topic
Display Mode
Topic Options
Author
Message
peter.skoglund
peter.skoglund
Posted Monday, December 20, 2010 9:04 PM
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 12:36 AM
Points: 9,
Visits: 285
Comments posted to this topic are about the item
SELECT TOP
Post #1037478
SQLRNNR
SQLRNNR
Posted Monday, December 20, 2010 11:16 PM
SSCoach
Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 18,858,
Visits: 12,443
Thanks for the question.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1037505
Hardy21
Hardy21
Posted Monday, December 20, 2010 11:23 PM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 7:11 AM
Points: 877,
Visits: 1,159
Nice question.
MSDN link for the same: http://msdn.microsoft.com/en-us/library/ms188385(v=SQL.105).aspx
Thanks
Post #1037508
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Monday, December 20, 2010 11:47 PM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 3:28 AM
Points: 3,165,
Visits: 4,345
Good "Back to basics" question.
thanks
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1037517
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, December 21, 2010 12:34 AM
SSCrazy Eights
Group: General Forum Members
Last Login: 2 days ago @ 6:30 AM
Points: 9,410,
Visits: 6,495
I'm confused: the correct answer is the row that is returned "most of the time"?
If yes, then it isn't a good question, as other answers might be possible. If you can receive other rows with TOP 1, then you should have added an 'It depends' answer.
For the rest: nice question
(also good layout and structure of code)
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1037541
Carlo Romagnano
Carlo Romagnano
Posted Tuesday, December 21, 2010 1:01 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 1:10 AM
Points: 1,998,
Visits: 1,866
da-zero (12/21/2010)
I'm confused: the correct answer is the row that is returned "most of the time"?
If yes, then it isn't a good question, as other answers might be possible. If you can receive other rows with TOP 1, then you should have added an 'It depends' answer.
For the rest: nice question
(also good layout and structure of code)
I agree with you: no "order by", no default sequence.
But what does this mean?
Always use the top with an ORDER BY clause!
Syntax should be appropriate to the hints.
Post #1037548
paul s-306273
paul s-306273
Posted Tuesday, December 21, 2010 2:20 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 9:12 AM
Points: 1,167,
Visits: 646
Nice question and layout, but surely the answer should be 'cannot be determined' without the 'order by' clause.
Post #1037571
cengland0
cengland0
Posted Tuesday, December 21, 2010 2:50 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354,
Visits: 1,299
I didn't like this question. I did get it right because I figured it would return 'Ann' most of the time but as the author said, it cannot be guaranteed without an order by clause. There should have been an option that said "Unknown" or "Cannot be 100% certain".
Post #1037588
paul.knibbs
paul.knibbs
Posted Tuesday, December 21, 2010 3:20 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:40 AM
Points: 1,272,
Visits: 4,310
I was expecting the answer to be something along the lines of things are always returned in the clustered index order (which would obviously raise questions in any case), but then it's talking about it being indeterminate--if that's the case, why isn't there an "it depends" answer? Question implies one thing, answer says another!
Post #1037601
jts_2003
jts_2003
Posted Tuesday, December 21, 2010 5:03 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:56 AM
Points: 1,063,
Visits: 4,261
Definitely should be "it depends"... I think the question is trying to show what happens when you add a clustered index to a heap and how the data is likely to get re-organised as the index is built.
Post #1037626
« Prev Topic
|
Next Topic »
51 posts, Page 1 of 6
1
2
3
4
5
»
»»
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.
