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 «««7891011»»»

How many rows are returned from the query below? Expand / Collapse
Author
Message
Posted Friday, March 5, 2010 6:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 7:31 AM
Points: 155, Visits: 386
Chad Crawford (3/4/2010)

BTW - I thought of a few more assumptions that should have been included:
--Assume you are in the database containing tblUsers
--Assume you have been granted rights to select from tblUsers
--Assume the server has available memory
--Assume there is "sufficient" (whatever that means) disk space on the drive containing tempdb
--Assume the server room has available power (line or generator)
--Assume the server is plugged in
--Assume the server is on
--Assume the hippo is asleep



Thanks for trivializing a legitimate gripe despite what you believe.

The fact of the matter is any of the answers presented would have been correct given a certain set of assumptions. There were really no wrong answers.

Please go ahead and continue mocking me and others that feel the same as I do by posting an asinine list of assumptions. It is not like other QOTD's never included Create Table or Insert statements.
Post #877573
Posted Friday, March 5, 2010 6:25 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:35 PM
Points: 22,992, Visits: 31,471
Fatal Exception Error (3/5/2010)
Chad Crawford (3/4/2010)

BTW - I thought of a few more assumptions that should have been included:
--Assume you are in the database containing tblUsers
--Assume you have been granted rights to select from tblUsers
--Assume the server has available memory
--Assume there is "sufficient" (whatever that means) disk space on the drive containing tempdb
--Assume the server room has available power (line or generator)
--Assume the server is plugged in
--Assume the server is on
--Assume the hippo is asleep



Thanks for trivializing a legitimate gripe despite what you believe.

The fact of the matter is any of the answers presented would have been correct given a certain set of assumptions. There were really no wrong answers.

Please go ahead and continue mocking me and others that feel the same as I do by posting an asinine list of assumptions. It is not like other QOTD's never included Create Table or Insert statements.


Chad wasn't trivializing your gripe, just exaggerating the request for eliminating assumptions. Just how far do you take it?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #877577
Posted Friday, March 5, 2010 6:36 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:35 PM
Points: 22,992, Visits: 31,471
kaspencer (3/5/2010)
I think that I am probably one of those who has been criticised in this thread because I have complained about a number of the questions written for SQLServerCentral.

I am sorry if some respondents consider that I have been fickle, or overly fussy, but I really do believe that if one is to set questions on a platform such as SQLServerCentral, then one must be careful to ensure that the questions are properly phrased, in correct English, and that any assumptions are stated. And by "assumptions" I am not meaning those that one or two correspondents have taken ad absurdum - I mean for example, that if a table name is specified in the question, then it should exist in one of the standard or demo databases that are available for SQLServer, and that database should be referred to in the question. It is also only right and fair that if some specific user privileges or permissions are required then they too should be specified.

Where are the guidelines for questions? Where are the responses from the moderators?

If one wishes to place questions on this platform, one is assuming a position of authority; in some ways one might be regarded as a professional examiner in this subject. In order to claim that authoritative position, then one must aspire to certain professional standards in the the questions posed. Otherwise stick to providing answers, not questions!

Kenneth Spencer


First, most people that have submitted QotD are not authoritive individuals nor professional examiners in the subject. Some are people learning just like you that have found something interesting and took the time to write up a QotD for others to answer and learn from as well. The only exception I would have to thins would be individuals like Paul Randal that who sometimes submit QotD to SSC.

As for requiring that any tables/databases be standard or demo databases, I fully disagree. For instance, we don't have any of the demo databases installed on our development or production servers here at work. If we could get the sandbox server we have requested for several years, then I'd have those databases available at work as we would use those for experimenting.

I'd like to see you submit a QotD (and yes I am working on one myself, just haven't had much time to work on it due to work at the moment), and see how you do. As I said earlier, this question required some thought and some basic assumptions to arrive at the correct answer, and it didn't require trying to run the code to find out what the answer was before selecting it either.

The QotD is not an examination question, it is meant to make people think and test their knowledge, and with that, the discussions are very important. Too bad that for some they choose to gripe and complain.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #877586
Posted Friday, March 5, 2010 8:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 5,565, Visits: 24,704
kaspencer (3/5/2010)
then one must be careful to ensure that the questions are properly phrased, in correct English

May I point out that the SSC community includes members from countries world wide, whose native language is NOT english. Do you wish to discriminate against them, to raise a barrier to their insight and contributions?

I mean for example, that if a table name is specified in the question, then it should exist in one of the standard or demo databases that are available for SQLServer

This immediately raises in my mind the thought that you do NOT desire to test your knowledge, but rather test your ability to cut and paste.

Where are the guidelines for questions?

Here:
http://www.sqlservercentral.com/articles/SQLServerCentral/62764/


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 #877665
Posted Friday, March 5, 2010 8:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:10 PM
Points: 2,607, Visits: 17,903
Fatal Exception Error (3/5/2010)
Chad Crawford (3/4/2010)

BTW - I thought of a few more assumptions that should have been included:
--Assume you are in the database containing tblUsers
--Assume you have been granted rights to select from tblUsers
--Assume the server has available memory
--Assume there is "sufficient" (whatever that means) disk space on the drive containing tempdb
--Assume the server room has available power (line or generator)
--Assume the server is plugged in
--Assume the server is on
--Assume the hippo is asleep



Thanks for trivializing a legitimate gripe despite what you believe.

The fact of the matter is any of the answers presented would have been correct given a certain set of assumptions. There were really no wrong answers.

Please go ahead and continue mocking me and others that feel the same as I do by posting an asinine list of assumptions. It is not like other QOTD's never included Create Table or Insert statements.

I deeply apologize. Although it was partially an attempt at humor, it was not my intent to mock you or anyone who is frustrated with the QOD.

My intent was to point out that there is a long list of potential assumptions for any QOD and any QOD submitter, being human, is likely to forget one or more that are applicable to their question. Yes, other QODs have included create table and insert statements, but in the 5 or so years I've been answering the QOD, I remember very few that went to that level. Maybe they should have. We (speaking of everyone frequenting SSC, not any select group) are all professionals, but there are probably very few who are professional question writers. I dare say that most of the QODs were written by someone who in the course of their normal work (whether it be DBAdmin, DBArchitecth, DBDeveloper, DB%, or even "not like '%DB%' ") found something odd or new and thought, "Hey, I'll bet no one knows this, it would make a great question". Because this is a community effort, very few QODs are written by people well versed in the art of testing and question writing. It's a community effort and that shows from time to time.

Yes, the items at the end of my list were ridiculous in nature. But the ones at the top were not. If the question were to really show the reasonable assumptions to answer the question, indicating that the user has permissions should definitely be one of them, but only one post in this discussion brought that out. Why? Because I'll wager that almost everyone assumed that was an unspoken assumption. That’s what I hoped to bring out with my list - there is a long list of assumptions that we work with all the time. Given that each of the answers had legitimate claim to be right forces one to step back and think, "What was the original intent of this question - what are they trying to test?" You may feel that there is a little luck involved there, but even recognizing that each of the answers is potentially correct shows that you have a level of knowledge greater than most, and you can take pride in that. If it's the points you need - there are about a half dozen different ways to guarantee you get the QOD right every time, and I'd be happy to share if you want some (I use two regularly - I allow myself to Google/BOL before answering and sometimes I'll read the discussion before answering if there is something I'm not clear on, but I'll already have my decision made based on what I expect to find before looking. Neither of those guarantees success, but there are two other techniques that do).
Post #877674
Posted Friday, March 5, 2010 8:33 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:06 AM
Points: 1,710, Visits: 6,235
bitbucket-25253 (3/5/2010)
kaspencer (3/5/2010)
then one must be careful to ensure that the questions are properly phrased, in correct English

May I point out that the SSC community includes members from countries world wide, whose native language is NOT english.


All the more reason to ensure that correct English is used. I know enough French to stand a reasonable chance of understanding a sentence in standard French. But show me one in badly worded, mis-spelled, ungrammatical French, and I'll struggle!
Post #877689
Posted Friday, March 5, 2010 8:36 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:35 PM
Points: 22,992, Visits: 31,471
I'll give you one right now as i have already seen it posted in other threads: Wait a day, the next days email newsletter contains the answer to the previous days question.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #877694
Posted Friday, March 5, 2010 8:38 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:35 PM
Points: 22,992, Visits: 31,471
Toreador (3/5/2010)
bitbucket-25253 (3/5/2010)
kaspencer (3/5/2010)
then one must be careful to ensure that the questions are properly phrased, in correct English

May I point out that the SSC community includes members from countries world wide, whose native language is NOT english.


All the more reason to ensure that correct English is used. I know enough French to stand a reasonable chance of understanding a sentence in standard French. But show me one in badly worded, mis-spelled, ungrammatical French, and I'll struggle!


Steve doesn't do a lot of editting on QotD or articles. As he says, he prefers that the author's voice be heard.

He will correct gross errors, but beyond that not much.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #877696
Posted Friday, March 5, 2010 9:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 5,565, Visits: 24,704
Lynn Pettis Posted Today @ 10:36 AM
I'll give you one right now as i have already seen it posted in other threads: Wait a day, the next days email newsletter contains the answer to the previous days question.


I wondered about that, and for my last published QOD (Creating a Trigger on a View published 2/24/2010) I tracked the results for a week. Although the number of people answering the question increased, the percentage of correct answers advanced from 67 percent on the first day to 67.3 percent by the 7th day. Not something I considered significant. True the question was not difficult and that may have some bearing on the matter.

Having 4 additional questions scheduled for publication between now and my birthday in April I will continue tracking to attempt to determine if this experience is typical.


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 #877728
Posted Friday, March 5, 2010 9:15 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
If you are listening Steve, these CTE's are great fun and make great questions!

Jamie
Post #877732
« Prev Topic | Next Topic »

Add to briefcase «««7891011»»»

Permissions Expand / Collapse