Number of Rows

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dave62 » Number of Rows

48 posts, Page 2 of 5

««1 2 3 4 5 »»»

Number of Rows

Rate Topic

Display Mode

Topic Options

Author

Message

Toreador

Posted Friday, January 18, 2013 2:53 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 10:02 AM
Points: 1,383, Visits: 4,870

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

DugyC

Posted Friday, January 18, 2013 2:53 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:19 AM
Points: 1,181, Visits: 744

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

Stewart "Arturius" Campbell

Posted Friday, January 18, 2013 3:57 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:46 AM
Points: 3,157, Visits: 4,341

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

rals

Posted Friday, January 18, 2013 4:37 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:02 AM
Points: 1,732, Visits: 757

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

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

^{Regards,
Rals.}

Post #1408820

sjimmo

Posted Friday, January 18, 2013 6:00 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, June 14, 2013 7:34 AM
Points: 2,865, Visits: 2,472

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

bitbucket-25253

Posted Friday, January 18, 2013 6:08 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 5,122, Visits: 20,362

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

Dave62

Posted Friday, January 18, 2013 6:09 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 10:39 AM
Points: 1,527, Visits: 1,564

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

Tee Time

Posted Friday, January 18, 2013 6:36 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:33 AM
Points: 321, Visits: 240

Thanks, good question! Smile

My potentially very flawed logic was to choose the item with "OFF" as the outlier and answer 1.

Post #1408875

mtassin

Posted Friday, January 18, 2013 6:37 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 10:09 PM
Points: 3,250, Visits: 65,527

Koen Verbeeck (1/18/2013)

Always hard to answer a question with no documented behaviour without running it Wink

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

mtassin

Posted Friday, January 18, 2013 6:38 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 10:09 PM
Points: 3,250, Visits: 65,527

mtassin (1/18/2013)

Koen Verbeeck (1/18/2013)

Always hard to answer a question with no documented behaviour without running it Wink

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 »

48 posts, Page 2 of 5

««1 2 3 4 5 »»»

Permissions