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

What is the result ? (SQLServer 2005) Expand / Collapse
Author
Message
Posted Thursday, September 11, 2008 2:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 11, 2014 4:45 AM
Points: 230, Visits: 791
TyGas (9/10/2008)
Let me correct you... The version of SQL Server was mentioned.


Sorry I stand corrected but yes I think the wording could have been better e.g. specifically saying using SSMS would've been more accurate. I don't like questions that make assumptions for you.

One of my favourite film quotes of all time is "Assumption is the mother of all screwups!"

OK it's not screwups but another similar word beginning with f but I'm not going to post that :D
Post #567541
Posted Thursday, September 11, 2008 3:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 24, 2008 1:27 PM
Points: 350, Visits: 229
Ian Elliott (9/11/2008)
I think the wording could have been better e.g. specifically saying using SSMS would've been more accurate. I don't like questions that make assumptions for you.


I agree, you can't just make assumptions when making projects for clients, for example, as you could get it wrong.

Given the wording of the question, I think that the Incorrect syntax answer should be the correct answer as well.
Post #567558
Posted Thursday, September 11, 2008 7:03 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 23,016, Visits: 31,537
Unfortunately (or not), I disagree. By specifying SQL Server 2005 in the question, that should automatically eliminate SQL Server 2000 tools from the equation. In my environment, currently mixed 2000/2005, the only reason I even use SQL Server 2000 tools is to look at and modify (if necessary) SQL Server 2000 DTS packages. All other activities are done using the SQL Server 2005 tools.




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 #567686
Posted Thursday, September 11, 2008 7:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 AM
Points: 7,001, Visits: 8,439
Lynn Pettis (9/11/2008)
Unfortunately (or not), I disagree. By specifying SQL Server 2005 in the question, that should automatically eliminate SQL Server 2000 tools from the equation. In my environment, currently mixed 2000/2005, the only reason I even use SQL Server 2000 tools is to look at and modify (if necessary) SQL Server 2000 DTS packages. All other activities are done using the SQL Server 2005 tools.



Pffeeuuuuwww ... I'm no longer the only person in the galaxy making that assumption ( with SQL2005 only to use SSMS or SQLCMD) :D

Altough, persons using e.g. .Net may still be a bit picky on this question


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #567698
Posted Thursday, September 11, 2008 9:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 11, 2014 4:45 AM
Points: 230, Visits: 791
ALZDBA (9/11/2008)
Pffeeuuuuwww ... I'm no longer the only person in the galaxy making that assumption ( with SQL2005 only to use SSMS or SQLCMD) :D

Altough, persons using e.g. .Net may still be a bit picky on this question


Yep I agree, in a perfect world, but as this thread has now shown not everyone makes that assumption or even obeys it therefore at best the question should be noted as ambiguous.

Don't you just love being a DBA
Post #567879
Posted Thursday, September 11, 2008 10:06 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 23,016, Visits: 31,537
Again, we don't work in a perfect world. How many times do we have to make assumptions in our day to day work? Users don't tell us everything we need to get them what they need, so we have to make assumptions all the time.

To tell people who are willing to come up with QotD that they must provide completely unambiguous questions is simply , IMHO, unreasonable. They might as well just give us the answer instead of having us figure it out and get it right or wrong based on our assumtions and research.




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 #567894
Posted Thursday, September 11, 2008 10:13 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 23,016, Visits: 31,537
ALZDBA (9/11/2008)
[quote
Pffeeuuuuwww ... I'm no longer the only person in the galaxy making that assumption ( with SQL2005 only to use SSMS or SQLCMD) :D



Actually, I stopped using the SQL Server 2000 tools, except for working with DTS packages, as soon as I loaded SQL Server 2005 Developer Edition on my desktop systems. That was back in 2005.




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 #567902
Posted Thursday, September 11, 2008 10:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 11, 2014 4:45 AM
Points: 230, Visits: 791
Lynn Pettis (9/11/2008)Again, we don't work in a perfect world. How many times do we have to make assumptions in our day to day work? Users don't tell us everything we need to get them what they need, so we have to make assumptions all the time.
Yes but that's why I ask them further questions and why I stipulate that I don't get the blame for assuming things when they have not provided me with the information I need and ask for.

Lynn Pettis (9/11/2008)To tell people who are willing to come up with QotD that they must provide completely unambiguous questions is simply , IMHO, unreasonable. They might as well just give us the answer instead of having us figure it out and get it right or wrong based on our assumptions and research.


While I mostly agree with you on making all questions completely unambiguous as this can sometimes be a mammoth task, how hard would it have been to say "In SQL Server 2005 (using 2005+ tools), what is the result of this query."

Honestly I'm really not trying to be picky I just think for query questions it's not totally unreasonable to ask someone to specify the sql version and tools/versions if it is going to make a difference to the answer as not everyone will be using the same configurations and tools.

Sorry maybe lots of people will disagree with my view and as I haven't been in this field for a long time (being a relative youngster) maybe they are correct but I'll certainly take this on board for future questions now I am aware of the std thinking.

Thanks. :)
Post #567934
Posted Thursday, September 11, 2008 11:09 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 23,016, Visits: 31,537
I've been in this field for 30+ years (started in computer operations and worked up from there). Doesn't matter how many questions you ask, at some point you have to make some assumptions based on what you have at the time. Some users don't even know what they want until you give them what they ask for and realize that isn't what they wanted at all.

We never eliminate abiguity, just minimize it. As for the QotD, yes, they are a learning tool, but really will it matter tomorrow if you got the answer today right or wrong? What really matters is that you learned something from the question, and sometimes from the ensuing discussion.




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 #567955
Posted Thursday, September 11, 2008 11:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 AM
Points: 7,001, Visits: 8,439
Don't you just love the way a simple question - with some context - with the possibility of being ambiguous triggers a bunch of discussions.

"Make it fool proof and they will come up with a better fool" ;)


It just wasn't the case over here.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #567959
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse