Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Number of Rows Expand / Collapse
Author
Message
Posted Friday, January 18, 2013 2:53 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:20 AM
Points: 1,740, Visits: 6,366
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.

Is there a relevance to this?



That was my reaction as well. Especially as actually running the code gives different results.
Post #1408775
Posted Friday, January 18, 2013 2:53 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Hugo Kornelis (1/18/2013)
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.

Is there a relevance to this?


That's what I though as well when answering the question.

< snip very interesting explanation>

But again - back to Paul Knibb's reaction: what is the relevance of this?

+ 1


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1408776
Posted Friday, January 18, 2013 3:57 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 11:15 AM
Points: 3,964, Visits: 5,204
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.

Is there a relevance to this?


+1


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1408801
Posted Friday, January 18, 2013 4:37 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 1:50 PM
Points: 1,904, Visits: 793
Stewart "Arturius" Campbell (1/18/2013)
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.

Is there a relevance to this?


+1


+1

I wanted to see the answer and explanation without spending time in analyzing and selected '1' (lucky).


Regards,
Rals
.
Post #1408820
Posted Friday, January 18, 2013 6:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 9:47 AM
Points: 2,914, Visits: 2,525
In my naivete I'm thinking 'so what?'.

Is there a relevance to this?


Exactly.

BTW I got Command(s) completed successfully.


Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #1408851
Posted Friday, January 18, 2013 6:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:50 PM
Points: 5,322, Visits: 25,235
Missed what is the suposed correct answer. Got confused - I looked at the execution plan ... did NOT consider the message tab as part of the execution plan .


If one looks at the actual estimated execution plan for a statement such as Select * FROM tablex there is a line entry for "estimated number of rows". For the code in the QOD there is NO such entry.

So can someone tell me when the message block became part of the estimated execution plan.




If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1408858
Posted Friday, January 18, 2013 6:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:34 AM
Points: 2,071, Visits: 2,064
paul s-306273 (1/18/2013)
In my naivete I'm thinking 'so what?'.

Is there a relevance to this?

No, I don't think there is any "relevance" so to speak. Some questions are just trivia.

I was interested and curious about why the message (1 row(s) affected) was being returned. It would appear that some have confirmed my suspicion that the estimated execution plan is the row in question.

Enjoy!
Post #1408860
Posted Friday, January 18, 2013 6:36 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 531, Visits: 448
Thanks, good question!

My potentially very flawed logic was to choose the item with "OFF" as the outlier and answer 1.
Post #1408875
Posted Friday, January 18, 2013 6:37 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
Koen Verbeeck (1/18/2013)
Always hard to answer a question with no documented behaviour without running it


You can still get it wrong like I did...

SQL 2008R2 RTM - No rows affected
SQL 2008R2 SP1 - No rows affected
SQL 2012 RTM - No rows affected

Don't have a 2008 SP3 instance to test on.




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1408877
Posted Friday, January 18, 2013 6:38 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:38 AM
Points: 3,675, Visits: 72,434
mtassin (1/18/2013)
Koen Verbeeck (1/18/2013)
Always hard to answer a question with no documented behaviour without running it


You can still get it wrong like I did...

SQL 2008R2 RTM - No rows affected
SQL 2008R2 SP1 - No rows affected
SQL 2012 RTM - No rows affected

Don't have a 2008 SP3 instance to test on.


Aaah never mind... missed the whole estimated execution plan, which would have been the plan itself... duh.




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1408879
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse